FAQ
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 testUser@localhost

Even if I grant the testUser @ localhost.

I can look in the user table and sure enough user testUser@localhost is
there.


Bruce Martin
The Martin Solution
PO Box 644
Delaware Water Gap, PA
(570) 421-0670
bruce@martinsolution.com

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 9 | next ›
Discussion Overview
groupmysql @
categoriesmysql
postedNov 5, '05 at 2:55a
activeNov 6, '05 at 7:43p
posts9
users5
websitemysql.com
irc#mysql

People

Translate

site design / logo © 2022 Grokbase