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.登录测试成功