> -----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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
