- 1.
- /home/local/mysql/bin/mysqladmin -u root password '123456'
- 2.
- service mysqld start #启动服务
- /home/local/mysql/bin/mysql -uroot -p -h127.0.0.1
- use mysql;
- update user set `PASSWORD` = PASSWORD('123456'); # where USER='root';
- select * FROM user;
- FLUSH PRIVILEGES; #生效
- quit;
来源: