RE: Installation Help

[Paul DuBois]

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 'userid@stripped' IDENTIFIED BY 'somepassword';

That's not quite right.

- GRANT * is not legal, I suspect you mean GRANT ALL.

- 'userid@stripped' is quoted incorrectly.  That is equivalent to
   'userid@stripped'@'%'.  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
>