-
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
-
What is this symbol ( %) mean?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|