Thanks for taking the time to report this bug in Ubuntu.
I think that this is actually the intended behavior; some notes about a
'default' install:
1) mysql by default only binds to 127.0.0.1
2) the 'empty' accounts are anonymous accounts which are only usable from
localhost or the server itself
You can make the 'testuser' account in your example work by creating a
user with:
CREATE USER 'testuser'@'localhost' IDENTIFIED BY 'testpw';
GRANT SELECT ON testdb.* TO 'testuser'@'localhost';
FLUSH PRIVILEGES;
OR you can bind mysql to 0.0.0.0 and your account above will start to
work with:
mysql --user=testuser --password=testpw -h <server hostname>
The host wildcard that is created when no origin is specified will match
'localhost'.
Marking 'Invalid' as this is the intended behaviour and not a bug.
** Changed in: mysql-5.5 (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.5 in 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-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
