Linux上安装MySQL5.7

yum install libaio*

wget http://dev.MySQL.com/get/Downloads/MySQL-5.7/mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz

tar -xvf mysql-5.7.11-Linux-glibc2.5-x86_64.tar.gz

cp -r mysql-5.7.11-linux-glibc2.5-x86_64/ /usr/local/mysql

groupadd mysql

useradd -g mysql mysql

cd /usr/local/mysql/

mkdir data

chown -R mysql:mysql ./

./bin/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/

cp -a ./support-files/my-default.cnf /etc/my.cnf

cp -a ./support-files/mysql.server /etc/init.d/mysqld

vi /etc/my.cnf

i录入
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
socket = /tmp/mysql.sock
character-set-server = utf8
:wq

ln -s /usr/local/mysql/bin/mysql /usr/bin

service mysqld start

ps -ef|grep mysql

cat /root/.mysql_secret

mysql -u root -p

alter user root@localhost identified by '新密码';

flush privileges;

exit

mysql -uroot -p

show databases;

use mysql;

select user,host from user;

update user set host = '%' where user = 'root';

select user,host from user;

flush privileges;

exit