MariaDB Warning: 'root@localhost' has both ... The password will be ignored

mysql passwords warnings mariadb root
FlorianL picture FlorianL · Apr 16, 2017 · Viewed 7.8k times · Source

I have installed MariaDB on Ubuntu LTS 16.04. Then I have run

/usr/bin/mysql_secure_installation

and set a root password. Accessing the DB via mysql -u root -p works fine. But checking the status with service mysql status opens a log file with this warning:

[Warning] 'user' entry 'root@localhost' has both a password and an authentication plugin specified. The password will be ignored.

The questions are:

  1. Is this a worry or completely normal?
  2. If this is a worry, how can I fix it?

Answer

elenst picture elenst · Apr 16, 2017

It is normal, if by saying "accessing the DB via mysql -u root -p works fine" you mean that you are running it while being a system root (or under sudo). You should not be able to do it as an ordinary user.

Packages generated by Ubuntu by default have unix_socket authentication for the local root. To check, run 

SELECT user, host, plugin FROM mysql.user;

You should see unix_socket in the plugin column for root@localhost.

If you want to use the password authentication instead, run

UPDATE mysql.user SET plugin = '' WHERE plugin = 'unix_socket';
FLUSH PRIVILEGES;

Related questions

How to log in to phpMyAdmin with WAMP, what is the username and password?

What does the word "root" mean in phpMyAdmin? Whenever I write localhost/phpmyadmin on the address bar, I am asked to enter a username and a password, but I don't know what they are. I don't remember when and where …

Read More
Setting the MySQL root user password on OS X

I just installed MySQL on Mac OS X. The next step was setting the root user password, so I did this next: Launch the terminal app to access the Unix command line. Under the Unix prompt I executed these commands: $ …

Read More
How to find out the username and password for mysql database

I've forgotten what I set as username and password for mysql database. How could I be able to find it out? I am using wamp server. I am a newbie in mysql.

Read More