Changing the Mysql Password
Mysql is a powerful database software, reliable security and convenience in use and can integrate with other databases. steps to change the mysql password is as follows: 1. You run the mysql with the following command: /etc/init.d/mysql start || service mysql start 2.Sign in to mysql by typing the following command: mysql -u root -p when prompted enter the password in it because by default the password blank. 3.Select the mysql database by typing the following command: use mysql; 4.To find a list of existing users enter the following command : select user,password from user; 5.If there's just delete the blank user because if not delete all the one entered into the database just by typing the command mysql only. delete user from user where user=''; 6.Well now we only replace his root password update user set password=password(‘password baru’) where user=’root’; 7.Then write flush privileges; 8.Replacement of the password has been finished, now exit from mysql by typing quit;