i forgot the root password in mysql. after some "googling" i found the solution:
1. Login as root
2. stop mysql server: /etc/init.d/mysql stop
3. edit mysql start up script: vim /etc/init.d/mysql
4. find the line invoking the safe_mysqld command. Add the parameter "--skip-grant-tables"
5. start mysql server: /etc/init.d/mysql start
6. login as mysql user:
# su
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newrootpassword') WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> \q
7. restart mysql server: /etc/init.d/mysql restart
Printed copies available, email rbahaguejr [at] gmail [dot] com |
Tuesday, December 21, 2004
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment