Mark wrote:
-----Original Message-----
From: Bruce Martin [mailto:[EMAIL PROTECTED]
Sent: zaterdag 5 november 2005 3:58
To: mysql@lists.mysql.com
Subject: Add New User
When I log in as root using: mysql -u root -p mysql I get the
mysql prompt:
mysql>
I then issue this command or statement:
mysql>GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'' IDENTIFIED
BY 'some_password' WITH GRANT OPTION;
I get the following returned:
Query OK, 0 rows affected (0.00 sec)
Why is this not working?
Because, afterwards, you forgot to say:
FLUSH PRIVILEGES;
Perhaps?
- Mark
No. FLUSH PRIVILEGES is not needed with GRANT
<http://dev.mysql.com/doc/refman/5.0/en/grant.html>.
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
