I wasn't sure if I was supposed to use 'root' or 'root@localhost' so I did it for both. I'm still getting this:
[root@web01 phil]# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Ugh. :) -----Original Message----- From: Paul DuBois [mailto:paul@;snake.net] Sent: Tuesday, November 12, 2002 7: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 >mysql> '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 --------------------------------------------------------------------- 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
