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:
- Points to remember Choosing between SSD and SAS Drives(Views: 1674)
- MySQL database to share common commands super-utility version(Views: 1992)
- Arp attack phenomenon and solution(Views: 3325)
- Commonly used commands in Linux(Views: 2182)
- How to redirect 301 by rewriting URL(Views: 2549)