转载来自:https://www.cnblogs.com/fhtwins/p/7470782.html
root执行:
(1)# /etc/init.d/mysqld stop 或者 service mysqld stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('root') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart 或者 service mysqld start
# mysql -uroot -p
Enter password: <输入新设的密码newpassword>
(2)下面的做完mysqld_safe --user=mysql --skip-grant-tables --skip-networking &会退出,但是密码照样生效,试过很多就这个好使。
支持远程访问:http://blog.csdn.net/sun614345456/article/details/53672150
mysql -uroot -p
use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
service mysqld restart