Dear Jing, > Does any one of you know how to work around this problem and access "mysql" > database?
1. Kill the server (kill -9 mysqld, you will probably need to log in as OS user 'root'). 2. Start the server with the option skip-grant-tables, e. g. mysqld --skip-grant-tables. 3. Connect to the server using MySQL Monitor, the command line tool: shell> mysql (You can connect without username/password.) 4. On the SQL command line, do: GRANT ALL ON *.* TO 'superuser'@'localhost' IDENTIFIED BY 'iwillremember' WITH GRANT OPTION; 5. Exit MySQL Monitor. 6. On the shell, do: mysqladmin -usuperuser -piwillremember shutdown 7. On the shell, do: mysqld (to start the server again) Now, this new 'superuser' can create accounts for regular users. Hope it helps, -- Stefan Hinz <[EMAIL PROTECTED]> CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Jannie Qu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 9:28 PM Subject: How to get mysql owner password? > Hi, all, > > sql, query. > > I started working on an old MySQL 3.23.47 database server on SunOS 5.7, but > I only have a regular user account. I cannot access "mysql" database. > > I tried to use OS user "root" and "mysql" to login without password, but it > failed. No one at my company knows other username and password except the > regular user account. > > Does any one of you know how to work around this problem and access "mysql" > database? > > Thank you, > Jing > > > > > > _________________________________________________________________ > MSN 8 with e-mail virus protection service: 2 months FREE* > http://join.msn.com/?page=features/virus > > > --------------------------------------------------------------------- > 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
