Right. My mistake.
I think you get the general idea. ~K Black -----Original Message----- From: Paul DuBois [mailto:paul@;snake.net] Sent: Tuesday, November 12, 2002 4:21 PM To: Black, Kelly W [PCS]; 'Phil Iovino'; 'Scott Pippin' Cc: [EMAIL PROTECTED] Subject: RE: Installation Help 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
