mysql安装
1、可以先查看服务器的版本
lsb_release -a
2、更新系统的软件仓库（apt仓库）
sudo apt update
sudo apt upgrade -y
3、安装mysql8.0
sudo apt install mysql-server
等待安装完成
4、连接数据库操作
sudo mysql
5、设置root账号密码
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'admin123456';
FLUSH PRIVILEGES;
root下添加新用户
1、选择mysql库
sudo mysql
2、创建用户
CREATE USER 'admin_user'@'localhost' IDENTIFIED BY 'admin123456';
3、配置新用户外网访问权限
update user set host='%' where user ='admin_user';
4、刷新配置
FLUSH PRIVILEGES;
5、执行授权
GRANT ALL PRIVILEGES ON *.* TO 'admin_user'@'%' WITH GRANT OPTION;
6、找到MySQL配置文件的并编辑
cd /etc/mysql/mysql.conf.d/
sudo vim mysqld.cnfc
注释掉bind-address
# bind-address = 127.0.0.1
7、重启服务
service mysql restart
