xuxinyi/ideaDemo

1.环境

ubuntu18.04  华为云远程服务器

2.停止MySQL服务

sudo systemctl stop mysql

3.卸载MySql

sudo apt-get remove --purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*

4.删除相关文件和目录

sudo rm -rf /etc/mysql /var/lib/mysql /var/log/mysql

5.清理未使用的包

sudo apt-get autoremove
sudo apt-get autoclean

6.更新包列表

sudo apt-get update

7.安装

sudo apt-get install mysql-server

8.安全配置（可选，但推荐）

sudo mysql_secure_installation

9.启动MySQL服务

sudo systemctl start mysql

10.检查状态

sudo systemctl status mysql

11.配置MySQL以允许远程连接（非root 11-16步)

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
找到:bind-address = 127.0.0.1
更改:bind-address = 0.0.0.0
这将允许来自所有IP地址的连接。

12.重启服务器

sudo systemctl restart mysql

13.登录

mysql -u root -p  密码：1

14.在MySQL中，您需要为允许远程访问的用户创建或修改用户。进入MySQL命令行

CREATE USER 'your_user'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'your_user'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

15.配置防火墙

sudo ufw allow 3306/tcp

16.mysql -u your_user -p -h your_server_ip

17.配置MySQL以允许远程连接（root 11-16步)

CREATE USER 'root'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;