Victims of Military abductions surfaced due to Writ of Amparo
Full text of the writ of Amparo can be found here

Printed copies available, email rbahaguejr [at] gmail [dot] com

Tuesday, December 21, 2004

resetting mysql password

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> \q
7. restart mysql server: /etc/init.d/mysql restart

No comments: