Linux下MySQL安装配置

一. MySQL安装

1. 服务端 sudo apt-get install mysql-server
2. 客户端 sudo apt install mysql-clienit

二. MySQL修改初始密码

1. 查看随机账户/ 密码
   
   • sudo more /etc/mysql/debian.cnf
2. 连接MySQL服务端
3. 修改密码
   
   1. USE mysql
   2. UPDATE user SET plugin = ‘mysql_native_password’ WHERE user = ‘root’
   3. UPDATE user SET authentication_string = PASSWORD(‘自定义密码’) WHERE user = ‘root’

三. 配置远程访问

1. 连接MySQL服务端
2. 改表法
   
   1. USE mysql
   2. UPDATE user SET host = ‘%’ WHERE user = ‘root’
   3. SELECT host, user FROM user
3. 授权法
   
   1. 授权方式
      
      • GRANT ALL PRIVILEGES ON . TO ‘myuser’@’%’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION
      • GRANT ALL PRIVILEGES ON . TO ‘myuser’@’特定IP’ IDENTIFIED BY ‘mypassword’ WITH GRANT OPTION
   2. FLUSH PRIVILEGES

参见: https://dev.mysql.com/doc/refman/8.0/en/linux-installation.html