CentOS7_安装MySQL8修改密码

1. 添加MySQL8的本地源

执行以下命令获取安装MySQL源

[root@virde ~]# wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
[root@virde ~]# sudo yum localinstall mysql80-community-release-el7-1.noarch.rpm 

可以用下面命令检测源是否添加成功

[root@virde ~]# yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64 MySQL Connectors Community                  51
mysql-tools-community/x86_64      MySQL Tools Community                       63
mysql80-community/x86_64          MySQL ⑧0 Community Server                  17

2. 安装MySQL服务器

执行以下命令进行安装

[root@virde ~]# sudo yum install mysql-community-server

安装过程中有询问输入y回车即可.

启动MySQL

用下面命令启动MySQL

[root@virde ~]# sudo service mysqld start
Starting mysqld:[ OK ]

你可以用下面的命令检查MySQL的运行状态

[root@virde ~]# sudo service mysqld status
mysqld (pid 3066) is running.

重启MySQL

[root@virde ~]# sudo service mysqld restart
Starting mysqld:[ OK ]

停止MySQL

[root@virde ~]# sudo service mysqld stop
Starting mysqld:[ OK ]

软件安装好之后,会在错误日志中生成一个超级用户的初始密码,用下面的命令可以查看这个初始密码

[root@virde ~]# sudo grep 'temporary password' /var/log/mysqld.log
2018-04-27T05:20:2⑧645777Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: nDjEy-#jv7Dn

[root@virde ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 19
Server version: ⑧0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, 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> flush privileges;

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!'; Query OK, 0 rows affected (0.08 sec) 

注意：MySQL对密码复杂度有一定的要求（新版本允许修改规则）,默认密码规则如下：

必须包含至少一个数字,一个小写字母,一个大写字母和一个特殊字符

修改root账号远程访问权限

执行以下命令进行修改

mysql> use mysql;
mysql> update user set host="%" where user='root';
mysql> GRANT ALL ON *.* TO 'root'@'%';
mysql> flush privileges;

需要注意的几个问题

有些系统会因为服务器防火墙导致即使配置成功,也无法远程链接MySQL.如果无法链接,可以先暂时关闭防火墙测试一下是否时因为防火墙的原因(不同版本的Centos系统防火墙配置可能不一样,具体可能需要另查资料)防火墙命令:[root@virde ~]# service firewalld stop或者[root@virde ~]# systemctl stop firewalld.service

以上就是土嘎嘎小编大虾米为大家整理的相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用，就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！