安装
sudo apt update
sudo apt install mysql-server
验证是否安装成功
systemctl status mysql
登录
首次登录遇到的问题
由于未找到初始密码,登录时提示
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) or
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
可以sudo mysql
直接无密码进入
配置远程登录
1 查看user表中所有用户信息
use mysql;
select host, user, authentication_string, plugin from user;
2 更改root用户的host
update user set host='%' where user='root';
3 给予root 用户所有权限
GRANT ALL ON *.* TO 'root'@'%';
4 修改root用户密码及加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
5 刷新权限FLUSH PRIVILEGES;
6 最后sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
打开mysql配置文件注释掉bind-address=127.0.0.1
7 重启MySQL服务sudo systemctl restart mysql.service