At 11:45 -0600 11/12/02, Black, Kelly W [PCS] wrote:
Make sure you issued the correct GRANT statements
at the sql, query.
mysql>use mysql;
Database Changed
mysql> GRANT * ON *.* TO '[EMAIL PROTECTED]' IDENTIFIED BY 'somepassword';
That's not quite right.
- GRANT * is not legal, I suspect you mean GRANT ALL.
- '[EMAIL PROTECTED]' is quoted incorrectly. That is equivalent to
'[EMAIL PROTECTED]'@'%'. I suspect you mean 'userid'@'hostname.com'.
(user and host parts should be quoted separately.)
#note that will give FULL access...see the docs to restrict this.
mysql> FLUSH PRIVILEGES;
0 Rows Affected.
~Kelly W. Black
---------------------------------------------------------------------
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
