mysql5.6二进制安装

1、准备好mysql5.6二进制安装包

去mysql官网下载通用版即可： mysql-5.6.49-linux-glibc2.12-x86_64.tar.gz

2、开始安装

yum install libaio* libnuma* perl perl-devel perl-Data-Dumper -y
tar -zxvf mysql-5.6.49-linux-glibc2.12-x86_64.tar.gz -C /usr/local/src/
cd /usr/local/
ln -sv /usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/ mysql
cd mysql/
chown -R mysql:mysql .
mkdir -p /data/mysqldata
chown -R mysql:mysql /data/mysqldata/

3、my.cnf配置文件

vi /etc/my.cnf

[client]
default-character-set=utf8
[mysqld]
datadir=/data/mysqldata/
socket=/usr/local/mysql/data/mysql.sock
#Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Sustemd
log-bin = /usr/local/mysql/data/mysql-bin
log_error = /usr/local/mysql/data/error
server-id=1
max_connections = 5000
explicit_defaults_for_timestamp = off
lower_case_table_names = 1
collation-server = utf8_unicode_ci
character-set-server = utf8

4、初始化mysql

scripts/mysql_install_db --user=mysql --datadir=/data/mysqldata/
cp support-files/mysql.server /etc/rc.d/init.d/mysqld
ldconfig
echo "PATH=$PATH:/usr/local/mysql/bin" > /etc/profile.d/mysql.sh
source /etc/profile.d/mysql.sh

5、启动mysql

service mysqld start
chkconfig mysqld on
ln -s /usr/local/src/mysql-5.6.49-linux-glibc2.12-x86_64/data/mysql.sock /tmp/mysql.sock
cd /usr/local/mysql/bin
./mysqladmin -uroot password '123456'
mysql -uroot -p123456