Questions tagged [mariadb]
SQL database that can be used as a "drop-in" replacement for MySQL
122
questions
1
vote
1
answer
5k
views
Connect MySQL Workbench on PC to remote MariaDB server
MySQL Workbench operates on my PC at home with IP 1.2.3.4 and MariaDB is located on my server with IP 4.3.2.1.
https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ ...
1
vote
1
answer
2k
views
MariaDB root user
Good day,
I logged into mariadb with the skip grant tables option. Then I set password for the localhost root user. Then I flushed the privileges. However, I can still log in with the following ...
1
vote
1
answer
2k
views
mariadb server broken after failed package update
So I had a problem the other day when mariadb's server package failed to update correctly and would not longer run.
Log started: 2016-07-19 04:00:34
Setting up mariadb-server-10.1 (10.1.16+maria-1~...
0
votes
1
answer
918
views
Mariadb failed remove / install on Ubuntu 14.04
So I was messing around with mariadb installation on my machine and now am in a soup. I now can't either install or remove it.
When I try to install:
~# apt-get install mariadb-server
Reading ...
2
votes
1
answer
1k
views
How to display key to a file using OpenSSL?
I'm a newbie at encryption so I could do with some help:
I'm trying to follow a tutorial on the MariaDB website to create an aes-256-cbc key to encrypt my data at rest.
The line which it tells me to ...
0
votes
1
answer
2k
views
MySQL and MariaDB instances on the same server
Is there any way to install correctly MariaDB and update MySQL 5.5 to any superior version,without altering my production database?
I'm told MariaDB could be installed on the same server but I need ...
0
votes
1
answer
2k
views
installing mariadb 5 on centos 7 Unit mariadb.service failed to load: No such file or directory
I try to install mariadb on centos 7 using official documentation https://mariadb.com/kb/en/mariadb/yum/
I have installed these packages:
Installed Packages
MariaDB-server.x86_64 5....
1
vote
1
answer
23k
views
How to uninstall MariaDB 5.5 completely (including configurations) from CentOS 7
I tried command
yum remove mariadb mariadb-server
It removed the client but failed to remove the server.
error reading information on service mysql: No such file or directory
error: %preun(MariaDB-...
0
votes
1
answer
154
views
Do I need RAID1 in a galera cluster?
I have a 3-node galera cluster that supposedly performs synchronous write replication across the entire cluster. I am trying to figure out if it is a good idea to use a software RAID1 3-HD on these ...
27
votes
6
answers
128k
views
mysql (mariadb) ERROR 1698 (28000): Access denied for user 'root'@'localhost'
I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked ...
41
votes
4
answers
61k
views
Can't reset MySQL (MariaDB) root password
Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why.
I ...
1
vote
1
answer
2k
views
Can't change MySQL/MariaDB server collation option
I am trying to change the server's collation_server variable default option from latin1_swedish_ci to utf8_general_ci by adding it into the /etc/my.cnf.d/mariadb-server.cnf config file under a ...
1
vote
2
answers
7k
views
MySQL connection works on CLI, but not on Workbench
Fedora release 20 (Heisenbug) 3.19.3-100.fc20.x86_64
Packages:
mysql-workbench-community.x86_64 6.1.7-1.fc20
mariadb.x86_64 1:5.5.41-1.fc20
mariadb-libs.x86_64 ...
1
vote
1
answer
656
views
MySql service start fails without anything meaningful (CentOS 7)
[root@myserver my.cnf.d]# service mysql start
Starting MySQL. ERROR!
And this is all I get. I tried checking the logs but couldn't find anything related to this. The database worked perfectly fine ...
2
votes
1
answer
746
views
apt-get wants to remove MariaDB on Debian Wheezy
I've set up my server to use MariaDB and used the installation instructions on the web page. It worked quite well. Now, if I want to dist-upgrade, apt-get wants to replace MariaDB with MySQL:
The ...
0
votes
2
answers
344
views
MariaDB Galera on Ubuntu 12.04.4 LTS trying to overwrite /usr/bin/mysqld
This morning I noticed that there was an available update for MariaDB, from 5.5.35 to 5.5.36. So I decided to upgrade one of the three nodes in our MariaDB cluster. However the update failed:
root@${...
2
votes
1
answer
5k
views
Can't start MySQL on Fedora 20
I'm a newbie with Fedora and MySQL. I just installed Fedora 20 (virtual), then installed Apache and started it and then installed MySQL. When I tried to start MySQL using this command:
sudo service ...
0
votes
1
answer
594
views
Issues installing MariaDB (5.5.34) on Debian 7 (Wheezy)
When attempting to install MariaDB (5.5.34) on Debian 7 (Wheezy) apt-get outputs the following:
Setting up mariadb-server-5.5 (5.5.34+maria-1~wheezy) ...
[ ok ] Stopping MariaDB database server: ...
3
votes
1
answer
8k
views
Unable to install MariaDB on Centos 6.5 server - "No package available" in yum although Repo is present?
I've hit upon a strange issue with a new installation of CentOS 6.5 while trying to install MariaDB.
I've included the following information and created a MariaDB.repo file inside the /etc/yum.repos....
3
votes
0
answers
559
views
Is there any harm in using the MariaDB client to connect to a MySQL server?
I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it.
It seems like although the client command is mysql, the version is ...
0
votes
1
answer
2k
views
Can't install Galera on Ubuntu 12.04
I'm not very experienxed with Debian/Ubuntu. I follow this guide:
https://mariadb.com/kb/en/installing-mariadb-deb-files/
And this one for adding the required repositories (I don't install MariaDB!!!)...
1
vote
1
answer
294
views
Unable to install MariaDB on Debian 7
I'm trying to install MariaDB on my Debian 7 development machine and I've hit a problem.
Following this tutorial, and this workaround, I enter this command:
sudo apt-get install mariadb-server-5.5
...