mysql generic安装_CentOS6安装MySQL-5.7(Generic版本)

MySQL官网下载mysql安装包

cd /usr/local/src

wget https://cdn.mysql.com/archives/mysql-5.7/\

mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

wget https://mirror.tuna.tsinghua.edu.cn/mysql/downloads/MySQL-5.7/\

mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz

解压

tar -zxvf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz -C /usr/local

cd /usr/local

ln -sv mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz mysql

创建mysql用户

groupadd -r mysql

useradd -r -g mysql -s /bin/false mysql

创建数据库和其他一些配置文件夹，并修改其权限

数据目录

cd mysql

mkdir -p /usr/local/mysql/data/

chown -R mysql:mysql /usr/local/mysql/data/

chmod 750 /usr/local/mysql/data/

日志目录

mkdir -p /var/log/mysql/

chown -R mysql:mysql /var/log/mysql/

chmod 750 /var/log/mysql/

启动脚本和配置文件

cp support-files/mysql.server /etc/init.d/mysqld

cp support-files/my-default.cnf /etc/my.cnf

修改参数

vim /etc/init.d/mysqld

basedir=/usr/local/mysql/

datadir=/usr/local/mysql/data/

vim /etc/my.cnf

[mysqld]

basedir=/usr/local/mysql/

datadir=/usr/local/mysql/data/

pid-file=/var/log/mysql/mysql.pid

[mysqld_safe]

log-error=/var/log/mysql/error.log

socket=/var/log/mysql/mysql.sock

初始化mysql

从版本5.7.6开始，mysql初始化使用mysqld --initialize命令，不再使用mysql_install_db命令了

./bin/mysqld --initialize \

--user=mysql \

--basedir=/usr/local/mysql \

--datadir=/usr/local/mysql/data/

MySQL 5.7 linux generic 版本安装