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