How to reset mysql user password in linux through command prompt

ARUN Post in MYSQL
0

Login to mysql.

mysql -u root -p

In mysql prompt use

mysql> use mysql;

Now change the password for user “arun”   to  “secret123″ as below :

[    mysql> update user set password=PASSWORD(“secret123″) where User=’arun';     ]

 

« Prev: :Next »

Leave a Reply

You must be logged in to post a comment.