I've been watching this thread and wonder if not following instructions may be
contributing to the present confusion.
On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote:
>>>Show me the output of the following:
>>> SHOW GRANTS FOR 'username'@'hostname';
>
>RQ> output:
>RQ> mysql> show grants for 'root@localhost';
>RQ> ERROR 1064: You have an error in your SQL syntax near
>RQ> 'grants for 'root@localhost'' at line 1
Note the application of single quotes in the above and following. Also, note the huge
difference in the error
messages.
mysql> show grants for 'root@localhost';
ERROR 1141: There is no such grant defined for user 'root@localhost' on host '%'
mysql> show grants for 'root'@'localhost';
+-------------------------------------------------------------------------------
--------------------------------+
| Grants for root@localhost
|
+-------------------------------------------------------------------------------
--------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'some
password' WITH GRANT OPTION |
+-------------------------------------------------------------------------------
--------------------------------+
1 row in set (0.00 sec)
+-----------+
| version() |
+-----------+
| 3.23.43 |
+-----------+ on win9x.
Doug
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
