Tried it.. didnt work.. here is what i did
Quote:
Welcome to the MySQL monitor. Commands end with ; or \g
Your MySQL connection id is 202 to server version 4.0.13-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> mysql -u root mysql
-> GRANT ALL PRIVILEGES ON eq.* to XXXXXX@localhost
-> IDENTIFIED BY 'XXXXXXXXX' WITH GRANT OPTION;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root mysql
GRANT ALL PRIVILEGES ON eq.* to XXXX@loca
mysql>
|
Thats how it happened for me.