Centos7下Mysql安装教程

所需要的安装包链接：https://pan.baidu.com/s/1Viii6hjG134BYuuDucgPvA
提取码：66an
第一步：

上传安装包到opt目录下解压

rpm -ivh MySQL-shared-compat-5.6.45-1.el7.x86_64.rpm 
rpm -ivh MySQL-devel-5.6.45-1.el7.x86_64.rpm
rpm -ivh MySQL-client-5.6.45-1.el7.x86_64.rpm
rpm -ivh MySQL-server-5.6.45-1.el7.x86_64.rpm

如果出现如下问题

警告：MySQL-shared-compat-5.6.45-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：
	mariadb-libs 被 MySQL-shared-compat-5.6.45-1.el7.x86_64 取代

可以使用 yum remove mysql-libs 解决

第二步：

启动MySQL服务

[root@node1 soft]# service mysql start
Starting MySQL. SUCCESS! 
启动成功

第三步：

查看默认密码

[root@node1 soft]# cat /root/.mysql_secret 
# The random password set for the root user at Mon Nov  2 10:36:13 2020 (local time): SbLf4pTztFZdoO9L

第四步：

登录到MySQL

[root@node1 soft]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.45

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 

登录成功

第五步：

修改默认密码

修改登录密码
set password for 'root'@'localhost'=password('root');
开启远程登录
grant all privileges on *.* to 'root'@'%' identified by 'admin' with grant option;
开放端口
firewall-cmd --zone=public --add-port=3306/tcp --permanent
修改指定主机密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' identified by 'mima' WITH GRANT OPTION;  
刷新权限
flush privileges;