ubuntu mysql 改密码_Ubuntu下修改MySQL5.7.21的root密码

使用sudo apt install mysql-server方法安装的MySQL服务，安装后没有临时密码日志。想修改root密码，尝试了好多方法都无效。亲测可用的方法如下:

1.系统版本

test@localhost:~$ lsb_release -aNo LSB modules are available.Distributor ID: UbuntuDescription:    Ubuntu 18.04 LTSRelease:        18.04Codename:       bionic

2.安装MySQL

test@localhost:~$sudo apt install mysql-servertest@localhost:~$sudo service mysql starttest@localhost:~$sudo service mysql status

3.支持远程登录

修改mysql的配置文件/etc/mysql/mysql.conf.d/mysqld.cnf

test@localhost:~$sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf，将bind-address改为0.0.0.0

4. 重启mysql服务

test@localhost:~$sudo apt install mysql-servertest@localhost:~$sudo service mysql starttest@localhost:~$sudo service mysql status

5. 5.7之后的mysql安装直接完成，不会让使用者配置用户名和密码，可以通过使用超级权限直接进入MySQL

test@localhost:~$sudo mysql

6. 输入以下语句，修改root密码

mysql>show databases；mysql>use mysql;mysql>update user set authentication_string=PASSWORD("自定义密码") where user='root';mysql>update user set plugin="mysql_native_password";mysql>flush privileges;mysql>quit;

7. 修改完密码，重启mysql

test@localhost:~$sudo service mysql restart

8. 再次登录就可以使用密码登录了。

test@localhost:~$ mysql -u root -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 8Server version: 5.7.21-1ubuntu1 (Ubuntu)Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.