Ubuntu
mysql-dfsg-5.0 package

  1. Bug #226851
  2. Comment #2

Comment 2 for bug 226851

Revision history for this message
Luca de Pasqua (depasqua) wrote : Re: Users "not root" don't works correctly

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@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.