Public bug reported: It occurs for Ubuntu 8.04 and Ubuntu 8.10 Desktop Edition (It doesn't for Ubuntu 8.04 Server Edition).
I Create a new Database: mysql> Create Database db1; I restore a backup from another MySQL 5.0 DB: $ mysql -p -u root db1 < backup.sql I create an user named dbadmin1: mysql> grant select on db1.* to dbadmin1 identified by "a" with grant option; Then, when I try to log in using that user: $ mysql -p -u dbadmin1 It doesn't let me connect to the server using the password I chose, but it does if i let the password empty although I just see "information_schema" database. ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Undecided Status: New -- Grant sentence doesn't work https://bugs.launchpad.net/bugs/297574 You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu. -- 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