ubuntu18.04安装mysql5.7

sudo apt install mysql-server
sudo apt update 

Server version: 5.7.36-0ubuntu0.18.04.1 (Ubuntu)

sudo mysql
show databases;

use mysql;

 

show tables;

select user,plugin,authentication_string from user;

 

update user set plugin='mysql_native_password' where user='root';

 

update user set authentication_string=PASSWORD('111111') where user='root;

 FLUSH PRIVILEGES  刷新权限  *或者* exit 退出mysql  使用sudo service mysql restart重启mysql数据库

FLUSH PRIVILEGES;

 

 更新后的用户表

sudo service mysql status

启动mysql服务 sudo service mysql start

停止mysql服务 sudo service mysql stop

重启mysql服务 sudo service msyql restart

mysql -uroot -p