Stop mysqld and start it again using the --skip-grant-tables command line option.
---------------------------------------------------------------------------- -------------- FROM THE MANUAL AT http://www.mysql.com/doc/en/Command-line_options.html This option causes the server not to use the privilege system at all. This gives everyone full access to all databases! (You can tell a running server to start using the grant tables again by executing mysqladmin flush-privileges or mysqladmin reload.) ---------------------------------------------------------------------------- -------------- It seems that you are trying to access mysql using the "root" account without a password. If part of your changes to the user accounts have been to change (or add) the password for the "root" account you need to specify that password. I can't remember how that is done in PHP, but from the command-line you would use this: "mysql -u root -p" Using the -p switch will tell the client to prompt you for the password. There is more helpful info at http://www.mysql.com/doc/en/Access_denied.html. Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -----Original Message----- From: Steve J Racicot [mailto:sracicot@;nhbis.com] Sent: Monday, November 04, 2002 7:24 AM To: [EMAIL PROTECTED] Subject: Logging In Errors Hi Group, I made some changes to user privileges in mysql and now I cant log in. Can anyone provide a step by step guide as to how I can fix the issue below, without reinstalling mysql? And if I reinstall, will I lose all of the databases created? Warning: Access denied for user: 'root@localhost' (Using password: NO) in /usr/local/etc/httpd/htdocs/mysql/lib.inc.php on line 308 Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in /usr/local/etc/httpd/htdocs/mysql/lib.inc.php on line 308 Error Thanks Steve --------------------------------------------------------------------- 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
