Debian安装MySQL

1. 更新下载MySQL资源仓库 https://dev.mysql.com/get/mysql-apt-config_0.8.36-1_all.deb 2. 安装更新 sudo dpkg -i mysql-apt-config_0.8.36-1_all.deb 3. 更新升级 sudo apt update sudo apt upgrade 4. 安装MySQL sudu apt install mysql-server # 期间会提示输入密码, 并确认密码 5. 修改完善MySQL相关配置 # 配置文件 vim /etc/mysql/mysql.conf.d/mysqld.cnf [mysqld] # 允许远程访问 bind-address = 0.0.0.0 # 修改端口号 port = 13306 # 内存优化，按需 performance_schema = off # 进入MySQL后，执行相关语句允许远程访问（MySQL 5.7.40版本后） > CREATE USER 'root'@'%' IDENTIFIED BY '密码'; > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION; > FLUSH PRIVILEGES; # 进入MySQL后，执行相关语句允许远程访问(5.7.38版本之前) > GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION; > FLUSH PRIVILEGES; # 查看端口 netstat -tulnp | grep mysql