Centos下安裝Mysql5.7

標籤：unicode   mys   policy   com   完成   down   comm   set   get   

升級，建議完成後重啟

yum -y update

卸載已安裝的Mysql

yum -y remove mysql-libs

安裝依賴

yum -y install numactl-libs

下載安裝包

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-common-5.7.19-1.el7.x86_64.rpmwget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-5.7.19-1.el7.x86_64.rpmwget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpmwget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client-5.7.19-1.el7.x86_64.rpmwget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.19-1.el7.x86_64.rpm

安裝

rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm --nosignaturerpm -ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm --nosignaturerpm -ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm --nosignaturerpm -ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm --nosignaturerpm -ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm --nosignature

啟動

service mysqld start

查看初始密碼

grep "password" /var/log/mysqld.log

登入mysql後立即修改密碼

SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘newpass‘);

此處可能提示密碼不符合要求，輸入下列語句後重新修改密碼即可

set global validate_password_policy=0;

設定開機自啟

chkconfig mysqld on

修改mysql配置

vim /etc/my.cnf

修改為

[client]port=3306default-character-set=utf8mb4[mysqld]port=3306character-set-client-handshake=0character_set_server=utf8mb4collation-server=utf8mb4_unicode_cidatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socksymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pid

Centos下安裝Mysql5.7