CentOS7 安装mysql5.6

CentOS7 安装MySQL5.6

1. 检查是否有MariaDB和MySQL，如果有则卸载掉

如果有，则需要用如下命令删除
[root@oracle local]# rpm -e --nodeps mariadb-server-5.5.60

2. 下载mysql5.6二进制安装包
   wget https://cdn.mysql.com//Downloads/MySQL-5.6/mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz

当然也可以离线下载好，然后再上传到对应的服务器中。我这里是用迅雷下载工具下载的，下载完成后，需要用FTP工具上传到指定的服务器中；

3. 解压到/usr/local并改名，然后创建软链接
   命令：
   tar -zxvf mysql-5.6.42-linux-glibc2.12-x86_64.tar.gz -C /usr/local
   cd /usr/local/
   mv mysql-5.6.42-linux-glibc2.12-x86_64/ mysql-5.6.42
   ln -s /usr/local/mysql-5.6.42/ /usr/local/mysql

4. 创建用户组和用户名
   groupadd mysql
   useradd -g mysql -s /sbin/nologin mysql

5. 修改配置文件
   cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

[root@oracle local]# cat /etc/my.cnf
[mysql]
default-character-set=utf8
[mysqld]
skip-name-resolve
port = 3306
server_id = 1
log_bin = mysql-bin
socket=/var/lib/mysql/mysql.sock
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
max_connections=200
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_name=1
max_allowed_packet=16M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[client]
socket = /var/lib/mysql/mysql.sock

6. 进入mysql目录初始化数据
   chown mysql.mysql -R /usr/local/mysql
   cd /usr/local/mysql/scripts/
   ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

7. 配置环境变量
   echo "export MYSQL_HOME=/usr/local/mysql/ " >> /etc/profile
   echo "export PATH=$PATH:$MYSQL_HOME/bin " >> /etc/profile
   source /etc/profile

8. 启动MySQL，并设置开机自启动
   mkdir -p /var/lib/mysql
   chown -R mysql.mysql /var/lib/mysql/
   cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
   chkconfig --add mysqld
   chkconfig mysqld on
   /etc/init.d/mysqld start

9. 设置数据库登陆密码
   mysqladmin -uroot password ‘123456’

10. 设置远程登陆
    mysql -uroot -p’123456’

mysql> grant all privileges on . to ‘root’@’%’ identified by ‘123456’ with grant option;
mysql> flush privileges;