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: 1811)
- MySQL int (M) instruction(Views: 1910)
- MySQL database to share common commands super-utility version(Views: 2212)
- What are the advantage of using a dedicated server?(Views: 2629)
- High Performance & Availability(Views: 2537)