CentOS 7 安装 MySQL 5.6

yum install libaio #安装libaio
yum install deltarpm #安装deltarpm
yum install perl-Data-Dumper.x86_64 #安装Perl模块

wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz

tar -zxvf mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz  -C /usr/local
mv mysql-5.6.26-linux-glibc2.5-x86_64/ mysql

useradd mysql -s /sbin/nologin

mkdir -p /data/mysql
chown -R mysql:mysql /data/mysql
chown -R mysql:mysql /usr/local/mysql

./scripts/mysql_install_db --user=mysql --datadir=/data/mysql

mv /etc/my.cnf /etc/my.cnf.bak
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

datadir=/data/mysql
port=3306
socket=/tmp/mysql.sock

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
vi /etc/init.d/mysqld
datadir=/data/mysql   #修改数据库目录文件
basedir=/usr/local/mysql

service mysqld start
 
Usage: mysqld  {start|stop|restart|reload|force-reload|status}  [ MySQL server options ]

echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
source /etc/profile

[root@localhost ~]# mysql -uroot -p #第一次登录不需要密码 直接按回车
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.26 MySQL Community Server (GPL)
 
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
 
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> update mysql.user set password=password("123456") where user="root"; #修改root 密码
flush privileges;