Kamis, 09 Agustus 2012

CHANGE USER/ROOT PASSWORD MYSQL on Terminal (Command Line)


1. Open terminal

2. Login to mysql server
    $ mysql -u root -p
   
3. Insert password for user ("root")

4. Use database mysql
    mysql> use mysql;
   
5. Change Password user
    mysql> UPDATE user SET Password=PASSWORD("newpassword") WHERE User='root';
   
6. Reload Privileges
    mysql> flush privileges;
   
7. Quit mysql
    mysql> quit;

Tidak ada komentar:

Posting Komentar