Public bug reported:
Hi.
On a fresh mysql-server-5.5 install on 12.04:
mysql> CREATE USER 'testuser' IDENTIFIED BY 'testpw';
mysql> GRANT SELECT ON testdb.* TO 'testuser';
mysql> FLUSH PRIVILEGES;
$ mysql --user=testuser --password=testpw
ERROR 1045 (28000): Access denied for user 'testuser'@'localhost' (using
password: YES)
I have found that this is due to there are rows in the mysql.user table
where User = "":
If i remove this rows:
mysql> DELETE FROM mysql.user WHERE User = '';
mysql> FLUSH PRIVILEGES;
Every thing works as expected.
root user can login before, because its matched before User = '' in
mysql.user.
Is there a reason for this or is this a bug in the mysql-db-
initialization?
** Affects: mysql-5.5 (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1024300
Title:
Empty strings in mysql.user "disables" new users
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1024300/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
