Ubuntu
mariadb-10.0 package

  1. Bug #1447808
  2. Comment #6

Comment 6 for bug 1447808

Revision history for this message
Jesús Abelardo Saldívar Aguilar (jasaldivara) wrote :

I think, this problem is because the root mysql account is now setup to aunthenticate via unix_socket instead of a password:

https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/

So, you can enter to mysql as root user if you are logged in to the system using the root unix user (or using sudo) and you don't need to type the mysql password:

sudo mysql -u root

(this only will ask you for your root's system password, not your root's mysql password

This is the output from mysql when I query for the root account grants (SHOW GRANTS FOR 'root'@'localhost';):

GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED VIA unix_socket WITH GRANT OPTION

So, if you want to connect to mysql using a password, I suggest to create another mysql user, and identify it using a password