yum安装mysql驱动_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 |

+---------------+-----------+