ubuntu安装mysql8.x以及配置

• xiaohu
• 24/12/07
• 0
• 339

[前言]

[环境]

[过程]

sudo apt install mysql-server

# mysql-server 服务名称就是mysql
systemctl start mysql
# 设置开机自启动
systemctl enable mysql

# 首次无密码进入
mysql
# 使用mysql系统表
use mysql;
# 查询所有用户和权限
select user,host,plugin from user;
# 设置root为任意远程主机连接，仅在测试环境建议使用
GRANT all  PRIVILEGES  ON *.* to 'root'@'%' with GRANT  OPTION;
# 修改root为caching_sha2_password，即密码验证
ALTER user 'root'@'%'  IDENTIFIED WITH caching_sha2_password BY '2024@@!!Hu';
# 刷新权限，即刻生效
FLUSH PRIVILEGES;
 ------------------ ----------- ----------------------- 
| user             | host      | plugin                |
 ------------------ ----------- ----------------------- 
| root             | %         | caching_sha2_password |
| debian-sys-maint | localhost | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
 ------------------ ----------- ----------------------- 
5 rows in set (0.00 sec)

# 查看所有允许的端口
ufw status

Status: active

To                         Action      From
--                         ------      ----
80                         ALLOW       Anywhere                  
22                         ALLOW       Anywhere                  
3306                       ALLOW       Anywhere                  
80 (v6)                    ALLOW       Anywhere (v6)             
22 (v6)                    ALLOW       Anywhere (v6)             
3306 (v6)                  ALLOW       Anywhere (v6) 

# 放开3306端口
ufw allow 3306

Rule added
Rule added (v6)

# 自动卸载mysql（包括server和client）
sudo apt-get autoremove mysql* --purge
sudo apt-get remove apparmor
# 删除mysql的数据文件
sudo rm /var/lib/mysql/ -R
# 删除mysql的配置文件
sudo rm /etc/mysql/ -R

[下载]