[Bug 226851] Re: Users "not root" don't works correctly

Mathias Gug mathiaz at ubuntu.com
Wed May 7 20:14:09 BST 2008


Confirmed.

TESTCASE:

  * Create a test user from mysql shell:

CREATE USER X IDENTIFIED BY 'Y';
GRANT ALL PRIVILEGES ON *.* TO 'X'@'%' IDENTIFIED BY 'Y' WITH GRANT OPTION;     
FLUSH PRIVILEGES;

  * From the shell, try to connect to the server:
        mysql -uX -pY

Gutsy result: access is granted:

gutsy:~$ mysql -uX -pY
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.0.45-Debian_1ubuntu3.3-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Hardy result: access is denied:
hardy ~$ mysql -uX -pY
  ERROR 1045 (28000): Access denied for user 'X'@'localhost' (using password: YES)


A workaround is to create another privilege for 'X'@'localhost' in addition to 'X'@'%'.


** Changed in: mysql-dfsg-5.0 (Ubuntu)
   Importance: Undecided => Medium
       Status: Incomplete => Triaged

** Summary changed:

- Users "not root" don't works correctly
+ '%' hostname doesn't match localhost

-- 
'%' hostname doesn't match localhost
https://bugs.launchpad.net/bugs/226851
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.0 in ubuntu.



More information about the Ubuntu-server-bugs mailing list