[SOLVED] MariaDB configuration Mageia2

[dmbentley]

I really want Mageia to work but the problem I have at the minute is that I cannot get MariaDB to work. I have installed the packages plus mysql workbench and PHPmyadmin and both say they cannot log into the mysql server.

What am I missing? (Probably something simple)

[djennings]

Well the simplest solution is to check if the mysqld service is running.
Look in Mageia Control Centre>System>Services

You will also need to set a root password for mariadb

Code: Select all

mysqladmin password

[dmbentley]

Sorry my mistake. I had already checked the service was running, and it is.

Thanks for the quick reply, I will try and set the password later.

[djennings]

Also check out the ownership of the files in /var/lib/mysql
When I upgraded my server to Mageia 2 it used different uid:gid numbers so mariadb would not start.

[doktor5000]

If that's the solution, please afterwards:

[dmbentley]

It was the password, thanks. Although PHPmyadmin now works MYSQLworkbench still will not connect to the localhost, I think I remember seeing a bug report saying this so I will leave it for now.

Thanks again for the fast reply.