Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

'An error ocured while applying Grants'

Status
Not open for further replies.

spoddy

Programmer
Mar 11, 2003
1
GB
V3.23.55 on Win32
Fresh install
Removed all users from mysql.users
Users skip-grant-tables to start server
Added user 'root' OK
Tried to grant full access with
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'root' WITH GRANT OPTION
But got 'An error ocured while applying Grants' and
Error 1047:Unknow command

Any ideas folks?
Thanks in advance
Adam
 
The it is a matter of ' and "

The right command is as follows

grant all privileges
on *.*
to root@'localhost'
identified by "password"
with grant option
;


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top