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:
- LAMP configuration example(Views: 4458)
- What are the advantage of using a dedicated server?(Views: 2402)
- National domain suffix(Views: 2964)
- Remote connection MySQL database(Views: 1754)
- MySQL database to share common commands super-utility version(Views: 1973)