ubuntu20.04安装mysql5.7.42

1、MySql官网下载mysql-server_5.7.42-1ubuntu18.04_amd64.deb-bundle.tar 下载地址：https://dev.mysql.com/downloads/mysql/ 2、下载依赖 libtinfo5_6.2-0ubuntu2_amd64.deb libaio1_0.3.110-2_amd64.deb libmecab2_0.996-1.2ubuntu1_amd64.deb 3、解压mysql-server_5.7.42-1ubuntu18.04_amd64.deb-bundle.tar，将3个依赖包放入解压目录 4、安装依赖 进入解压目录，执行以下命令： dpkg -i libmecab2_0.996-1.2ubuntu1_amd64.deb dpkg -i libaio1_0.3.110-2_amd64.deb dpkg -i libtinfo5_6.2-0ubuntu2_amd64.deb 5、安装MySql 执行以下命令： sudo dpkg -i mysql-common_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg-preconfigure mysql-community-server_5.7.42-1ubuntu18.04_amd64.deb //这里需要输入数据库root的密码 sudo dpkg -i libmysqlclient20_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i libmysqlclient-dev_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i libmysqld-dev_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i mysql-community-client_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i mysql-client_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i mysql-common_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i mysql-community-server_5.7.42-1ubuntu18.04_amd64.deb sudo dpkg -i mysql-server_5.7.42-1ubuntu18.04_amd64.deb 6、检查安装 mysql -u root -p //刚刚输入的密码 7、停止服务 service mysql stop 8、拷贝 cp -r /var/lib/mysql/* /opt/data/mysql 备注：/var/lib/mysql是Mysql的原始安装目录， /opt/data/mysql 是要更改存放数据库的目录，不存在则创建 9、授权 sudo chown -R mysql:mysql /opt/data/mysql sudo chown 777 /opt/data/mysql 10、修改配置 sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 更改datadir = /opt/data/mysql  #自定义目录 更改bind-address = 0.0.0.0 添加skip-grant-tables sudo vim /etc/apparmor.d/usr.sbin.mysqld # Allow data dir access #增加自定义目录   /opt/data/mysql/ r,   /opt/data/mysql/** rwk, 11、启动并授权root远程访问 service mysql start #启动mysql mysql -u root -p123456 #123456是密码 grant all privileges on *.* to 'root'@'%' identified by '123456!'; flush privileges;