第一步
下载数据库
sudo apt install mysql-server
sudo apt install mysql-client
#查看是否安装成功
mysql --version
第二步 登录
sudo mysql -uroot -p123456
#如果登录失败
sudo vim /etc/mysql/my.cnf
#输入以下配置,免密登录
[mysqld]
skip-grant-tables
#保存退出
systemctl restart mysql
sudo mysql -uroot -p
#回车登录
进入mysql
use mysql;
select User,Host,Plugin,authentication_string from user;
#先无脑刷新一波
flush privileges;
update user set Host='%' where user='root';
flush privileges;
#清空原密码
update user set authentication_string=’’ where user=‘root’;
#修改加密规则和更新密码
ALTER USER 'root'@'%' IDENTIFIED BY '自身密码' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '自身密码';
flush privileges;
exit;
#最后检验一下
sudo vim /etc/mysql/my.cnf
#注释之前的免密配置,保存退出
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
#注释掉bind-address,保存退出;
systemctl restart mysql;
mysql -uroot -p
#输入密码,成功登录.