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

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1447808

Title:
  Access denied for user 'root'@'localhost' after upgrading to Ubuntu
  15.04

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mariadb-10.0/+bug/1447808/+subscriptions

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to