Mageia forum

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)

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

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.

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.

If that's the solution, please afterwards:

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.