CentOS7二进制安装MySQL5.6

1、查询并卸载已安装的

rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs

2、安装依赖

yum -y install autoconf
yum install gcc gcc-c++ openssl openssl-devel libaio libaio-devel  ncurses  ncurses-devel

3、创建用户

useradd -s /sbin/nologin -M mysql

4、创建目录

mkdir -p /mnt/mydatas
chown -R mysql.mysql /mnt/mydatas

5、解压文件 

tar zxf mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz -C /usr/src
mv /usr/src/mysql-5.6.41-linux-glibc2.12-x86_64/ /usr/src/mysql
ln -s /usr/src/mysql /usr/local/mysql
chown -R mysql.mysql /usr/local/mysql
chown -R mysql.mysql /usr/src/mysql

6、配置/etc/my.cnf

[client]
user=mysql
socket=/mnt/mydatas/mysql.sock
default-character-set=utf8

[mysqld]
basedir = /usr/local/mysql
datadir = /mnt/mydatas
port = 3306
pid-file = /mnt/mydatas/mysql.pid
# server_id = .....
socket = /mnt/mydatas/mysql.sock
log-error = /mnt/mydatas/mysql-err.log
user = mysql
tmpdir = /tmp
character_set_server=utf8
character_set_client=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
max_connections=1000
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]
default-character-set=utf8

7、初始化数据

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/mnt/mydatas --pid-file=/mnt/mydatas/mysql.pid --tmpdir=/tmp

8、设置启动

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
vi /etc/init.d/mysqld

# 将basedir及datadir设置为如下内容

basedir=/usr/local/mysql
datadir=/mnt/mydatas

9、设置开机自启

chkconfig --add mysqld
chkconfig mysqld on
chkconfig --list mysqld

10、配置环境变量

vi /etc/profile


# 添加如下内容
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

source /etc/profile

11、设置密码

mysqladmin -u root password 'Psufool@2018'

12、设置远程连接

mysql -uroot -p

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
mysql> drop user ''@localhost;
mysql> use mysql;
mysql> update mysql.user set password = PASSWORD('Psufool@2018') where user = 'root';
mysql> flush privileges;