云端 mysql

 

 

sudo apt install mysql-server -y
sudo systemctl start mysql
sudo systemctl enable mysql # 设置开机自启

配置文件该端口和 bind-address = 0.0.0.0 远程用：/etc/mysql/mysql.conf.d/mysqld.cnf
sudo systemctl restart mysql

一开始没有密码直接 sudo mysql 进去设一个用户名密码
  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyP@ssw0rd123!';

有密码的登录：sudo mysql -u root -p

# 给远程使用

-- 创建远程 root 用户
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'MyP@ssw0rd123!';

-- 授予所有权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

-- 刷新权限
FLUSH PRIVILEGES;

-- 验证一下 有 %  就是可以远程使用
SELECT User, Host FROM mysql.user WHERE User = 'root';
+------+-----------+
| User | Host      |
+------+-----------+
| root | %         |
| root | localhost |
+------+-----------+