Hi,

When I create a new Mysql user, it is impossible to login using this user and password. Only if I crate a user without a password I can login.

For example:

mysql -u root -phererootpass
 grant all privileges on mydb.* to testuser@'%' identified by '' with grant option;
 grant all privileges on mydb.* to testuser2@'%' identified by 'mypass' with grant option;
 FLUSH PRIVILEGES;
 exit;

mysql -u testuser  #<<< work fine

mysql -u testuser2 -pmypass  #<<< fail to login
ERROR 1045 (28000): Access denied for user 'testuser2'@'localhost' (using password: YES)
</code>

I'm using Mysql 5.0 on Red Hat v5

Please advice Mostar