一、下载地址
https://download.csdn.net/download/java_road_far/11459574
二、删除自带的 MariaDB
rpm -qa | grep -i mariadb
rpm -e --nodeps mariadb-libs
三、解压安装
-
将安装包剪切到 /usr/mysql/ 目录下
[root@bigdata-12 mysql]# ll total 518440 -rw-r--r-- 1 root root 530882560 Mar 2 17:15 mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar [root@bigdata-12 mysql]# tar -axvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm mysql-community-libs-5.7.26-1.el7.x86_64.rpm mysql-community-embedded-5.7.26-1.el7.x86_64.rpm mysql-community-test-5.7.26-1.el7.x86_64.rpm mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm mysql-community-common-5.7.26-1.el7.x86_64.rpm mysql-community-devel-5.7.26-1.el7.x86_64.rpm mysql-community-client-5.7.26-1.el7.x86_64.rpm mysql-community-server-5.7.26-1.el7.x86_64.rpm mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm [root@bigdata-12 mysql]# ll total 1036896 -rw-r--r-- 1 root root 530882560 Mar 2 17:15 mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar -rw-r--r-- 1 7155 31415 25381952 Apr 15 2019 mysql-community-client-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 280904 Apr 15 2019 mysql-community-common-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 3838100 Apr 15 2019 mysql-community-devel-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 47076368 Apr 15 2019 mysql-community-embedded-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 24086952 Apr 15 2019 mysql-community-embedded-compat-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 130023844 Apr 15 2019 mysql-community-embedded-devel-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 2274268 Apr 15 2019 mysql-community-libs-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 2118444 Apr 15 2019 mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 173541272 Apr 15 2019 mysql-community-server-5.7.26-1.el7.x86_64.rpm -rw-r--r-- 1 7155 31415 122249684 Apr 15 2019 mysql-community-test-5.7.26-1.el7.x86_64.rpm
-
安装
[root@bigdata-12 mysql]# rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm warning: mysql-community-common-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-common-5.7.26-1.e################################# [100%] [root@bigdata-12 mysql]# rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm warning: mysql-community-libs-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-libs-5.7.26-1.el7################################# [100%] [root@bigdata-12 mysql]# rpm -ivh mysql-community-devel-5.7.26-1.el7.x86_64.rpm warning: mysql-community-devel-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-devel-5.7.26-1.el################################# [100%] [root@bigdata-12 mysql]# rpm -ivh mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm warning: mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-libs-compat-5.7.2################################# [100%] [root@bigdata-12 mysql]# rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm warning: mysql-community-client-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-client-5.7.26-1.e################################# [100%] [root@bigdata-12 mysql]# rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm warning: mysql-community-server-5.7.26-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-server-5.7.26-1.e################################# [100%] [root@bigdata-12 mysql]#
-
启动MySql服务:
查看MySql运行状态:
service mysqld status
启动MySql:
systemctl start mysqld
查看root随机密码:
grep 'temporary password' /var/log/mysqld.log
-
修改登录密码, MySQL的密码策略比较复杂,过于简单的密码会被拒绝
mysql -u root -p mysql> Enter password: (输入刚才查询到的随机密码) mysql> SET PASSWORD FOR 'root'@'localhost'= "xxxxxxxx"; mysql> exit
-
设置root可以远程登录:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'xxxxxxxx' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; mysql> exit;
-
开启防火墙mysql 3306端口的外部访问:
firewall-cmd --zone=public --add-port=3306/tcp --permanent firewall-cmd --reload
-
设置MySql忽略大小写:
用root登录,打开并修改
vim /etc/my.cnf
;在[mysqld]节点下,加入一行:lower_case_table_names=1
重启MySql服务:
systemctl restart mysqld