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? To test it further I try to log in as testUser
but it tells me access denied for user [EMAIL PROTECTED]
Even if I grant the testUser @ localhost.
I can look in the user table and sure enough user [EMAIL PROTECTED] is
there.
Bruce Martin
The Martin Solution
PO Box 644
Delaware Water Gap, PA
(570) 421-0670
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]