MYSQL modify the password in several ways
1. For administrators or privileged users
mysql -u root mysql
mysql> UPDATE user SET password = PASSWORD ("new password") WHERE user = 'name' ;
mysql> FLUSH PRIVILEGES;
mysql> QUIT
2. -u root mysql mysql
mysql> SET PASSWORD FOR name = PASSWORD ('new password');
mysql> QUIT
(Phpmyadmin or MYSQL-front etc. tools is alternative choise to manage user permissions, more intuitive and easy)
3. Optimal:
mysqladmin -u root "old password" "new password"
Suggested Reading:
- MySQL int (M) instruction(Views: 1749)
- Points to remember Choosing between SSD and SAS Drives(Views: 1661)
- What is a MySQL database?(Views: 2112)
- Arp attack phenomenon and solution(Views: 3312)
- National domain suffix(Views: 2975)