Yum安装MySQL

一、安装mysql

[root@vip ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

[root@vip ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm

[root@vip ~]# yum -y install mysql-community-server

二、上传mysql驱动包到/usr/share/java目录中 　　　　　　　　　　　　　　　　　　 //没有java目录自己手工建立

[root@vip ~]# cp mysql-connector-java.jar /usr/share/java

三、第一次启动mysqld程序

[root@centos_a ~]# systemctl start mysqld.service

四、查看mysql默认密码

[root@vip ~]# grep "password" /var/log/mysqld.log 　　　　　　　　　　　　　　　　 //使用grep调出/var/log/mysqld.log的初始密码:5B&-r-Xhr0zu

2019-11-29T05:31:54.114144Z 1 [Note] A temporary password is generated for root@localhost: 5B&-r-Xhr0zu

五、登陆mysql,修改默认密码

[root@vip ~]# mysql -uroot -p
Enter password: //此处为密文不显示密码，复制粘贴初始密码回车

ALTER USER 'root'@'localhost' IDENTIFIED BY 'Aadmin@1234'; 　　　　　　　　 //修改初始密码

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 　　　　　　  //如报以下错误，说明密码太过于简单不合规

grant all on *.* to admin@'%' identified by 'Aadmin@1234' with grant option; 　　　　　　　　　　　　　　 //添加远程用户
flush privileges; //刷新

grant all privileges on *.* to 'root'@'%' identified by 'Aadmin@1234' with grant option; 　　　　　　　　　 //添加远程用户
flush privileges; //刷新

mysql> use mysql; //进入mysql

mysql> select user,host from user; //查看用户
+---------------+-----------+
| user | host |
+---------------+-----------+
| admin | % |
| root | % |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+---------------+-----------+