[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Ubuntu 15.04 is no more supported and fix has been released. https://www.ubuntu.com/info/release-end-of-life ** Changed in: mariadb-10.0 (Ubuntu) Status: Fix Committed => Fix Released -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
The version 10.0.23-1 uploaded to Debian and soon synced to Ubuntu has now a reworked auth_socket configuration, where auth_socket is used by default only on new installs and on upgrades the existing mysqld root accounts are kept as-is. Therefore marking 'fix committed'. ** Changed in: mariadb-10.0 (Ubuntu) Status: Confirmed => Fix Committed -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Upgrade from 14.10 to 15.04 broke programs' access to MariaDB because they were all expecting to give a username of root and the appropriate password. To repair, I set user.plugin back to empty for user='root' and *also* had to set user.password as the upgrade had cleared it. It's not nice to discover the problem after the reboot upgrade; I didn't notice it in 15.04's release notes. Suggesting a new user be created with the desired permissions and code switch across to using that isn't practical when it's a legacy system with much code in various languages and root/password scattered to the winds by time. The client's system was being upgraded to get security updates, not be pushed into changing their codebase for a security improvement when no change wouldn't have worsened security. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Another change required having done the above is to alter /etc/mysql/debian.cnf to have user = debian-sys-maint, instead of root, with a new random password that's put into the existing row for that user. Otherwise, /etc/cron.daily/logrotate generates an email because it has problems rotating /var/log/mysql.log and friends. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Workaround/fix: http://www.versatilewebsolutions.com/blog/2015/05/dealing-with-mariadb-plugin-unixsocket-is-not-loaded.html -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
The new MariaDB 10.0 do no longer require users to set a root password. This is a security feature. You don't need root passwords (or debian- maint-user passwords) simply to run and maintain your database anymore. If you have root on the system you will get in as root to the database (or using sudo). For use cases where you need to access the database as some user from somewhere, just create a user and grant it the required permissions, and then use that user in your apps and other places. There is no need to have a general MySQL/MariaDB root user. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Can you log in from command line with simply running 'sudo mysql' ? Do that and create yourself your own MySQL/MariaDB user account, give it the neeeded permissions and use it. For security reasons it is not advised to use the root account all the time and in particular not remotely. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
I am not able to connect using python too import MySQLdb db = MySQLdb.connect(localhost,alok,alok,messages) is giving error OperationalError: (1698, Access denied for user 'root'@'localhost') -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
I am also facing the same problem after freshly installing mariadb in Kubuntu 15.04. I am able to get mysql shell with root account but not with my user account. root@alok-PORTEGE-R30-A:~# mysql -u root -proot #is owrking alok@alok-PORTEGE-R30-A:~$ mysql -u root -proot #not wokring ERROR 1698 (28000): Access denied for user 'root'@'localhost' also my java jdbc driver also not able to connect -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
I can also verify that this is an issue. Except mine is a fresh install of Ubuntu-Gnome 15.04. I have also reset the password and flushed permission. I can only login if skip-grant-tables flag is given. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
I found that the root user are now set up to login using unix_socket authentication plugin instead of a password, so one can login as root when using sudo command: sudo mysql -u root Also, what I did to solve my problem was to create another user, with log in via password and grant all permissions to that user. -- 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
[Bug 1447808] Re: Access denied for user 'root'@'localhost' after upgrading to Ubuntu 15.04
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: mariadb-10.0 (Ubuntu) Status: New = Confirmed -- 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
