记一次二进制方式安装MySQL 5.7

OS：CentOS release 6.9 x64
DB：MySQL 5.7.25


添加mysql用户
groupadd mysql
useradd -r -g mysql -s /bin/false mysql


创建路径
mkdir /data/mysql/{data,log/{binlog,slow,relaylog},startsql} -p
touch /data/mysql/log/mysql_error.log
mkdir /var/lib/mysql


安装MySQL，为便于升级basedir使用软连接
tar zxf mysql-5.7.25-linux-glibc2.12-x86_64.tar.gz
mv mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/
ln -s /usr/local/mysql-5.7.25-linux-glibc2.12-x86_64 /usr/local/mysql
chown -R mysql:mysql /data/mysql* /var/lib/mysql

/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/data/mysql/data --basedir=/usr/local/mysql --port=3306

记下生成的默认密码
cat /data/mysql/log/mysql_error.log |grep "temporary password”

[root@wxluntest02 wxlun]# cat /data/mysql/log/mysql_error.log |grep "temporary password"

2020-06-10T06:04:10.621458Z 1 [Note] A temporary password is generated for root@localhost: ?UwpDs0/:=eh



mv /etc/my.cnf /etc/my.cnf.bak
vi /etc/my.cnf     添加内容略

chown mysql.mysql /etc/my.cnf



cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
sed -i '$a PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH' /etc/profile
sed -i '$a export PATH' /etc/profile
source  /etc/profile



启动mysql

/usr/local/mysql/bin/mysqld_safe --user=mysql &



登录数据库修改root密码
mysql -uroot -p
alter  user 'root'@'localhost' identified by '123456';



完毕