Ok......... Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root password. Now restart the server with mysqladmin and flush-privileges.
Hope this helps.... Simon -----Original Message----- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 18:17 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Mysql connection problem Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant tables. See on line manual and don't know password. Or ./mysql --help Simon -----Original Message----- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 17:48 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Mysql connection problem Hello, I have a question for you. I have a Solaris 5.6 server running Mysql. It is our company' website. I just know the server's root password and I don't know mysql database user name and password. Is it possible to login to Mysql database by using the server root and its password? How can I do it? Your answer will be appreciated! Cindy --------------------------------------------------------------------- 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
