Monday, April 11, 2011

Creating users to use MySQL and Changing Root Password in Linux debian

By default mysql creates user as root and runs with no passport. You might need to change the root password.

To change Root Password
= mysql -u root
mysql> USE mysql;
mysql> UPDATE user SET Password=PASSWORD('new-password') WHERE user='root';
mysql> FLUSH PRIVILEGES;

2 comments: