"Bruce Martin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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;
You haven't specified the host, try this : To connect only from the localhost : GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'localhost' IDENTIFIED BY 'some_password' WITH GRANT OPTION; Or if you want to be able to connect from any host : GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'%' IDENTIFIED BY 'some_password' WITH GRANT OPTION; Or if you would like to be able to connect from some host : GRANT ALL PRIVILEGES ON *.* TO 'testUser'@'host_name_or_ip' 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]