There was an error in this gadget

Friday, June 11, 2010

How to set mysql root password

How to set mysql root password:

You can easily set the mysql root password...

# mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> exit

Now try to login with the password:

# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.......

No comments:

Post a Comment