Search This Blog

Tuesday, June 1, 2010

Creating users to use MySQL and Changing Root Password in debian

How to do this?

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;

1 comment:

  1. 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;

    ReplyDelete