http://morison.biz/technotes/articles/9 Ever inherit a mysql server that no one knew the root password, or perhaps any of the passwords? # do logged in as root: /etc/init.d/mysqld stop # make sure mysqld_safe is not running ps axu | grep mysql # NEXT COMMAND ONLY IF mysql IS HUNG AND WONT # SHUTDOWN NICELY; THE AUTHOR DISCLAIMS ANY DAMAGE # DUE TO kill -9 'ing... # If there are still mysql's left, kill -9 # <WARNING> dangerous to do, if kill -9 can # leave corrupted tables if the server is mid # transaction!</WARNING> pkill -9 mysql # Here's the key: --skip-grant-tables bypasses # passwords & such... /usr/sbin/mysqld --skip-grant-tables & # or, for some distros/installs installations... /usr/bin/mysqld_safe --skip-grant-tables & # run mysql client and change pass mysql mysql> USE mysql; mysql> UPDATE user SET Password=PASSWORD('newpass') WHERE User='root'; mysql> FLUSH PRIVILEGES; mysql> QUIT # Then, kill the locally running daemon and # start from /etc/init.d pkill mysql /etc/init.d/mysql start en 2006-2008, Rod Morison Software technotes@morison.biz Sun, 20 May 2012 04:52:25 GMT Yet Another Community System http://blogs.law.harvard.edu/tech/rss 70