Linux环境下二进制包的MySQL安装

一、mysql搭建（Linux环境，tar.gz）

1.官网下载安装安装包
percona官网

wget https://www.percona.com/downloads/Percona-Server-5.7/Percona-Server-5.7.21-21/binary/tarball/Percona-Server-5.7.21-21-Linux.x86_64.ssl101.tar.gz

2.解压
tar -zxvf Percona-Server-5.7.21-21-Linux.x86_64.ssl101.tar.gz
mv Percona-Server-5.7.21-21-Linux.x86_64.ssl101 percona57

3.授权
groupadd mysql
useradd -r -s /sbin/nologin -g mysql mysql
chown -R mysql. /usr/local/percona57

4.创建数据目录
mkdir /data/mysql_data
mkdir /data/mysql_log
chown -R mysql. /data/mysql_data
chown -R mysql. /data/mysql_log

5.修改/etc/my.cnf配置文件
vim /etc/my.cnf

[client]
socket=/tmp/mysql.sock

[mysqld]
basedir=/usr/local/percona57
datadir=/data/mysql_data/
server-id =1
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server=utf8
socket=/tmp/mysql.sock
secure_file_priv=’’
log-bin=/data/mysql_log/mysql-bin
log-bin-index=/data/mysql_log/mysql-bin.index
relay-log=/data/mysql_log/relay-bin
relay-log=/data/mysql_log/relay-bin.index

[mysqld_safe]
pid-file=/data/mysql_log/mysql.pid
log-error=/data/mysql_log/mysqld.err

(ps:生产环境中的参数设置具体根据实际配置)

5.初始化
/urs/local/percona57/bin/mysqld --defaults-file=/etc/my.cnf --initialize --basedir=/usr/local/percona57 --datadir=/data/mysql_data/ --user=mysql

(注意：指定配置文件时–defaults-file参数一定要放在第一个，否则初始化过程中可能会出现错误)

6.启动mysqld服务
/usr/local/percona57/bin/mysqld_safe --defaults-file=/etc/my.cnf &

查看线程
ps -ef |grep mysqld

7.修改密码
初始化中有一个初始密码
mysql -uroot -p
set password=password(“123456”);

8.设置mysqld服务启动脚本
cp /usr/local/percona57/support-files/mysql-server /etc/init.d/mysqld
vim /etc/init.d/mysqld
basedir=
datadir=

##启动/关闭
/etc/init.d/mysqld [start|stop]

关于Mysql8.0+初始密码修改

##You must reset your password using ALTER USER statement before executing this statement.

mysql> alter user root@'localhost' identified by '123456';
Query OK, 0 rows affected (0.01 sec)

(ps:仅学习使用，不经同意不得转载)