Apr
10
2008

MySQL Reset Password

371 views
# killall mysqld
# /usr/local/bin/mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("1234") WHERE User="root";
mysql> exit;
# killall mysqld
# /usr/local/etc/rc.d/mysql-server.sh start

Written by Pipo in: MySQL | Tags: ,

No Comments »

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes