Wednesday, September 25, 2013

how to change root password mysql

# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("your password here") WHERE User="root";
mysql> exit

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start

No comments:

Post a Comment