mysql-5.7.xx在lcentos7下的安装以及mysql在windows以及linux上的性能差异

 rpm -qa | grep mariadb

 yum remove mariadb-libs-5.5.56-2.e17.x86_64 

rpm -qa | grep mysql

df -h

cd /home            
mkdir mysql   
cd mysql      
wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

tar -zxvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz      
mv  mysql-5.7.28-linux-glibc2.12-x86_64   mysql-5.7.28  

cd /usr/local                       
ln -s /home/mysql/mysql-5.7.28 mysql  

useradd -s /bin/false -M mysql     
cd /home/mysql                   
chown -R mysql:mysql mysql-5.7.28 

vi /etc/my.cnf 

[mysqld]
# binlog 配置
log-bin=/usr/local/mysql/logs/mysql-bin.log
expire-logs-days=14
max-binlog-size=500M
server-id=1
# GENERAL
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
default-storage-engine=InnoDB
character-set-server=utf8lower_case_table_names = 1explicit_defaults_for_timestamp=true
[mysqld_safe]
log-error=/usr/local/mysql/mysql-error.log
pid-file=/usr/local/mysql/mysqld.pid
[client]
socket=/usr/local/mysql/mysql.sock
[mysql]
default-character-set=utf8
socket=/usr/local/mysql/mysql.sock

yum -y install autoconf          
cd /home/mysql/mysql-5.7.28     
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data  

mkdir logs
touch mysql-bin.index
chgrp -R mysql /home/mysql/mysql-5.7.28

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

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

service mysqld start

cd /home/mysql/mysql-5.7.28
touch mysql-error.log
chown mysql:mysql mysql-error.log

service mysqld start

vim /etc/profile 

#mysql
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin

source /etc/profile

mysql -uroot -p

mysql> alter user 'root'@'localhost' identified by '******';
mysql> flush privileges;

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '******' WITH GRANT OPTION;