1.下载数据库二进制包 ```bash cd /root wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz ``` 2.解压到安装目录 ```bash cd /root tar xvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz mv mysql-5.7.22-linux-glibc2.12-x86_64 /opt/mysql5.7 ln -s /opt/mysql5.7 /opt/mysql ``` 3.增加mysql用户/修改数据库目录权限 创建mysql组： ```bash groupadd mysql ``` 创建mysql用户： ```bash useradd -M -g mysql -s /sbin/nologin mysql ``` 4.初始化数据库(注意:记住初始化生成的密码) ```bash /opt/mysql/bin/mysqld --initialize --user=mysql --basedir=/opt/mysql/ --datadir=/home/data/mysql/data_dev/ /opt/mysql/bin/mysqld --initialize --user=mysql --basedir=/opt/mysql/ --datadir=/home/data/mysql/data_test/ ``` 5.增加数据库配置文件 ```bash cd /opt/mysql/support-files vim my_test.cnf ``` ``` [mysqld] innodb_buffer_pool_size = 128M cp my_test.cnf my_dev.cnf ``` 6.增加systemctl启动mysql脚本 ```bash cd /lib/systemd/system ``` 测试库脚本 ```bash cat mysql_test.service ``` ``` [Unit] Description=MySQL TEST ENV PORT 3306 [Service] Type=simple PIDFile=/home/data/mysql/data_test/mysqld_test.pid ExecStart=/opt/mysql/bin/mysqld --defaults-file=/opt/mysql/support-files/my_test.cnf --basedir=/opt/mysql/ --datadir=/home/data/mysql/data_test/ --user=mysql --log-error=/home/data/mysql/data_test/error_test.log --pid-file=/home/data/mysql/data_test/mysqld_test.pid --socket=/home/data/mysql/data_test/mysqld_test.sock --port=3306 [Install] WantedBy=multi-user.target ``` 研发库脚本 ```bash cat mysql_dev.service ``` ``` [Unit] Description=MySQL DEV ENV PORT 3307 [Service] Type=simple PIDFile=/home/data/mysql/data_dev/mysqld_dev.pid ExecStart=/opt/mysql/bin/mysqld --defaults-file=/opt/mysql/support-files/my_dev.cnf --basedir=/opt/mysql/ --datadir=/home/data/mysql/data_dev/ --user=mysql --log-error=/home/data/mysql/data_dev/error_dev.log --pid-file=/home/data/mysql/data_dev/mysqld_dev.pid --socket=/home/data/mysql/data_dev/mysqld_dev.sock --port=3307 [Install] WantedBy=multi-user.target ``` 7.修改数据库默认密码 测试库脚本 ```bash /opt/mysql/bin/mysqladmin -P3306 -h127.0.0.1 -u root -p password ``` 研发库脚本 ```bash /opt/mysql/bin/mysqladmin -P3307 -h127.0.0.1 -u root -p password ``` 8.增加数据库用户 ```mysql mysql>grant all privileges on *.* to dev@'%' identified by '123456'; mysql>flush privileges; ``` 9.测试 ``` mysql -h127.0.0.1 -udev -p123456 ```