linux环境下面修改mysql密码

https://jingyan.baidu.com/article/ab0b5630440169c15afa7df1.html 1.cd到mysql的所安装的目录文件夹中 /usr/local/mysql 2.vim my.cnf在文件的末尾添加skip-grant-tables 3.重启mysqld的服务service mysqld restart

3.登录到mysql数据库中,在密码登录阶段不输入任何密码，直接回车

[mysql@localhost mysql]$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.14 Source distribution

4.修改数据库密码

mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> update user set password=password('123456') where User='root' and Host='localhost'; Query OK, 1 row affected (0.04 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec)

3.登录测试成功