CentOS 7.4 PHP7.2.3 nginx-1.12.2 mysql5.7.21配置二（mysql-5.7.21）-CSDN博客

安装mysql-5.7.21 -----二进制安装

#下载 https://dev.mysql.com/downloads/file/?id=474759
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar
tar -xvf mysql-5.7.21-linux-glibc2.12-x86_64.tar
#解压后有两个包，用这个 mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
tar -xzvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz
#转移到自己的安装目录
mv mysql-5.7.21-linux-glibc2.12-x86_64 /web/server/mysql-5.7.21
#添加用户
groupadd mysql
useradd -g mysql -s /sbin/nologin mysql
#新建软链接
ln -s /web/server/mysql-5.7.21/ /web/server/mysql

#添加环境变量
echo "export PATH=$PATH:/web/server/mysql/bin" >> /etc/profile
source /etc/profile

#排除maraidb配置
mv /etc/my.cnf /etc/my.cnf--
mv /etc/my.cnf.d /etc/my.cnf.d--

#生成错误日志文件
touch /web/log/mysql/error.log

#权限修改
chown -R mysql.mysql /web/server/mysql/
chown -R mysql.mysql /web/log/mysql

#初始化数据库
mysqld --initialize --user=mysql --basedir=/web/server/mysql --datadir=/web/server/mysql/data
#得到初始数据库密码
A temporary password is generated for root@localhost: CAbsaT/rV7J#
#忘记初始密码就要重新初始化数据库,删除data目录里的文件,才可以初始化数据库成功!
#命令：rm -rf /web/server/mysql/data/*

chown -R mysql.mysql /web/server/mysql/data/
#先修改启动文件
vi /web/server/mysql-5.7.21/support-files/mysql.server
basedir=/web/server/mysql
#将support-file文件复制到/etc/init.d目录下
cp /web/server/mysql-5.7.21/support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
#将其添加到服务列表中
chkconfig --add mysqld
#启动mysql
systemctl start mysql #不会输出信息
#修改密码命令，把密码修改为123456
/web/server/mysql/bin/mysqladmin -u root -p password 123456

#配置文件生成
cat > /etc/my.cnf <<END
[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
log-error=/web/log/mysql/error.log
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

log-bin=mysql-bin
binlog_format=mixed
server-id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
expire_logs_days = 5
max_binlog_size = 1000M
END

#停止
systemctl stop mysql
#或者直接
/web/server/mysql-5.7.21/support-files/mysql.server start #这会输出信息
#还可以用下面命令了
service mysqld start
service mysqld stop
#添加开加启动
chkconfig mysqld on

转载于:https://my.oschina.net/wgc2010/blog/1630381