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';
#note that will give FULL access...see the docs to restrict this. mysql> FLUSH PRIVILEGES; 0 Rows Affected. ~Kelly W. Black -----Original Message----- From: Phil Iovino [mailto:phil@;nxtek.net] Sent: Tuesday, November 12, 2002 8:14 AM To: 'Scott Pippin' Cc: [EMAIL PROTECTED] Subject: RE: Installation Help I believe root has all permissions. I'm using Webmin to verify it. I started it with -u root but still got the same error. Since I installed with the RPM didn't it give root permission? -----Original Message----- From: Scott Pippin [mailto:spippin@;mtctrains.com] Sent: Tuesday, November 12, 2002 10:43 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Installation Help Scott Pippin [EMAIL PROTECTED] >>> "Phil Iovino" <[EMAIL PROTECTED]> 11/12/02 08:13AM >>> >I'm trying to install MySQL under RedHat 8. I installed the MySQL >3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs. >Per the instructions at >http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.ht m >l#Post-installation, I started the server with "/usr/bin/safe_mysqld &" >and it appears to have started. >When I try to test it, I get this: >[root@web01 bin]# mysqladmin version >mysqladmin: connect to server at 'localhost' failed >error: 'Access denied for user: 'root@localhost' (Using password: NO)' >I'm kinda stuck. Any ideas? Did you set up root as a user? If you did, try "/usr/bin/safe_mysqld -u root If not set up a user. http://www.mysql.com/doc/en/Adding_users.html hope this helps. (sql, mysql) --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
