Cannot login after create super user

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

Please refer to the MySQL Manual to see how to add users using SQL commands.

In your case you might have locked yourself out - which means restoring from your backup, or re-installing.

Cheers

Thx nicc77,

I got it.
Btw, when i query the user from mysql database.
i.e Select host, user, password from user.

And it return the user name , password and host.

Under the host, some user host indicate localhost and some indicate percentage sign (%).
What is that mean?

Thx again
LOOI

% is the wild card character in MySQL, which means "any thing / any where / any whatever".

Think of it as an asterix '*' often used in Windows/Unix as a wild card character.

Cheers