List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 13 2002 12:20am
Subject:RE: Installation Help
View as plain text  
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
>

Thread
Solaris 2.6leaddog112 Nov
  • Installation HelpPhil Iovino12 Nov
Re: Installation HelpScott Pippin12 Nov
RE: Installation HelpPhil Iovino12 Nov
RE: Installation HelpScott Pippin12 Nov
RE: Solaris 2.6Kelly W [PCS] Black12 Nov
RE: Installation HelpKelly W [PCS] Black12 Nov
  • RE: Installation HelpPaul DuBois13 Nov
    • RE: Installation HelpPhil Iovino13 Nov
RE: Installation HelpKelly W [PCS] Black13 Nov
RE: Installation HelpKelly W [PCS] Black13 Nov
  • RE: Installation HelpPhil Iovino13 Nov