Do you have a "root" user? I had similar problem and set new password:
$shell> /usr/local/mysql/bin/mysqladmin -u root -h localhost -p password 'newpassword' Then I could get access to all databases using: $shell> /usr/local/mysql/bin/mysql -u root -h localhost -p'newpassword' Of course, the paths in the above depends on your installation. I am on Linux 7.1 + Apache. NOBBY ----- Original Message ----- From: "PHP Nut" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 10:33 AM Subject: Cannot Access mysql database > Ok here is the short version of the problem. Installed mySQL database on > Cobalt server RAQ4 using Linux. Everything worked great. Now the mysql > database that is created by default with user table etc...is empty!!! (Due > to a user going in using PHPmyAdmin and changing the user and password > within the user table.) > > There is nothing in the mySQL database and now I cannot access the mysql > database due to there being an error with incorrect user and password! Well > there isn't since the mysql database does not have a user grant table. The > weird thing is that using PHPmyAdmin, I can manipulate the test database > that is installed by default. > > We have tried to re-install the database and this did not work. We then > tried the suggestions on this page: > > http://www.mysql.com/doc/D/e/Default_privileges.html > And that did not work either. I then tried copying the sql commands for > creating the user table etc, from another mySQL database located on a > different server. This does not work either due to incorrect user and > password. > > Can anyone help out?? I am in deep poop with this and need to find a > solution to get this mySQL up and running again. > > > > Thank you for taking the time to read this and any suggestions. > > Michael > > > > --------------------------------------------------------------------- > 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
