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

[luca dep]

The user was made by this script (where X and Y are user and password)
CREATE USER X IDENTIFIED BY 'Y';
and privileges with
GRANT ALL PRIVILEGES ON *.* TO 'X'@'%' IDENTIFIED BY 'Y' WITH GRANT OPTION;

FLUSH PRIVILEGES;
so I flushed privileges after giving them.
The error was on access:
luca at UBdp-XPS:~$ mysql -u X -p
Enter password: 
ERROR 1045 (28000): Access denied for user 'X'@'localhost' (using password: YES)
I used the same script to generate the db on a gutsy, with tha same version of mysql (5.0) and got no errors there.

-- 
Users "not root" don't works correctly
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.