Centos7 安装Mysql5.7

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

rpm -qa | grep mysql

rpm -e 已经存在的MySQL全名

sudo tar -zxvf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz -C /usr/local/

sudo mv mysql-5.7.17-linux-glibc2.5-x86_64/ mysql

sudo cp my.cnf my.cnf.bak

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

sudo vim my.cnf

[mysql]
default-character-set=utf8

[mysqld]
default-storage-engine=INNODB
character_set_server=utf8
# 忽略大小写
lower_case_table_names=1

basedir = /usr/local/mysql
datadir = /mnt/mysql/data
port = 3306

[mysqld_safe]
log-error=/mnt/mysql/logs/mysql.log

sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql

sudo groupadd mysql

sudo useradd -r -g mysql -s /bin/false mysql

sudo chown -R mysql:mysql /usr/local/mysql/

sudo chown -R mysql:mysql /mnt/mysql/

cd /usr/local/mysql/bin/

sudo ./mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/mnt/mysql/data

./mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

rpm -qa|grep libaio

sudo yum install libaio-devel.x86_64

root@localhost: SOA8W%kihjEC

sudo ./mysql_ssl_rsa_setup --datadir=/mnt/mysql/data

sudo ./mysqld_safe --user=mysql &

ps -ef|grep mysql

./mysql -uroot -p

set password=password('新密码');

grant all privileges on *.* to root@'%' identified by 'root';

flush privileges;

sudo chkconfig --add mysql

sudo chkconfig mysql on

sudo vim /etc/profile

export PATH=$JAVA_HOME/bin:/usr/local/mysql/bin:$PATH

source /etc/profile