Ubuntu 20.04安装MySQL5.7&修改存储路径

一、下载mysql安装包：

MySQL :: Download MySQL Community Server (Archived Versions)https://downloads.mysql.com/archives/community/ 

二、解压tar文件

tar -xvf mysql-server_5.7.41-1ubuntu18.04_amd64.deb-bundle.tar

三、安装依赖

apt-get install libaio1

apt-get install libtinfo5

四、安装数据库

dpkg -i mysql-common_5.7.41-1ubuntu18.04_amd64.deb

dpkg-preconfigure mysql-community-server_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i libmysqlclient20_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i libmysqlclient-dev_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i libmysqld-dev_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i mysql-community-client_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i mysql-client_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i mysql-common_5.7.41-1ubuntu18.04_amd64.deb

apt-get -f install

apt-get -f install libmecab2

dpkg -i mysql-community-server_5.7.41-1ubuntu18.04_amd64.deb

dpkg -i mysql-server_5.7.41-1ubuntu18.04_amd64.deb

查看数据库运行状态

service mysql staus

 

五、更改数据存储路径

chown -R mysql:mysql /data/database

chmod -R 755 /data/database

1）停止数据库：service mysql stop

2）编辑mysqld.cnf配置文件：

        vim /etc/mysql/mysql.conf.d/mysqld.cnf

        # datadir = /var/lib/mysql
        datadir = /data/database

3）编辑usr.sbin.mysqld配置文件

        vim /etc/apparmor.d/usr.sbin.mysqld

        # Allow data dir access
        #  /var/lib/mysql/ r,
        #  /var/lib/mysql/** rwk,
          /data/database/ r,
          /data/database/** rwk,

4）重启服务

        service apparmor reload

        service apparmor restart

        service mysql start