Hey All,
I have a problem login to database after create the user name with password.

I use the following statement.
Insert into mysql.user(user,password)values('sa','sa')

After i create it, i grant the privileges i.e
grant all prilileges on *.* TO 'sa'@'%' with grant option

All the query show ok.

When i try to login, the login fail.
Same to the root user by default with no password. When i set the password under MySQL Control Centre, and click on test button. It work fine.
But when i try to connection and key in the password. It fails.

Can someone show me the direction.
It's a bug for mysql.

Thx,
LOOI