查看rpm有没有安装mysql_rpm安装mysql

下载rpm包

官网下载

https://dev.mysql.com/downloads/mysql/5.7.html

mysql-community-client-5.7.29-1.el7.x86_64.rpm

mysql-community-common-5.7.29-1.el7.x86_64.rpm

mysql-community-libs-5.7.29-1.el7.x86_64.rpm

mysql-community-server-5.7.29-1.el7.x86_64.rpm

安装

依次通过rpm -ivh安装

[root@localhost mysql]# rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm

warning: mysql-community-common-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql-community-common-5.7.29-1.e################################# [100%]

[root@localhost mysql]# rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm

warning: mysql-community-libs-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql-community-libs-5.7.29-1.el7################################# [100%]

[root@localhost mysql]# rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm

warning: mysql-community-client-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql-community-client-5.7.29-1.e################################# [100%]

[root@localhost mysql]# rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

warning: mysql-community-server-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY

Preparing... ################################# [100%]

Updating / installing...

1:mysql-community-server-5.7.29-1.e################################# [100%]

登录

[root@localhost mysql]# cat /var/log/mysqld.log | grep 'password'

如果此文件没有内容,需要无密码登录

关闭数据库

[root@localhost mysql]# systemctl stop mysqld

查看数据库状态

[root@localhost mysql]# systemctl status mysqld

添加内容

[root@localhost mysql]# vim /etc/my.cnf

skip-grant-tables

开启数据库

[root@localhost mysql]# systemctl start mysqld

登录

[root@localhost mysql]# mysql -uroot

修改root用户远程访问

查看用户名和登录权限

mysql> select user,host from user;

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

| user | host |

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

| mysql.session | localhost |

| mysql.sys | localhost |

| root | localhost |

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

修改权限

mysql> update user set host='%' where user='root' and host='localhost';

Query OK, 1 row affected (0.00 sec)

Rows matched: 1 Changed: 1 Warnings: 0

mysql> commit;

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

修改密码

修改密码

mysql> set password=password('qingdao_MYSQL123');

Query OK, 0 rows affected, 1 warning (0.00 sec)

关闭数据库,将my.cnf文件,添加的内容删除

[root@localhost mysql]# systemctl stop mysqld

[root@localhost mysql]# vim /etc/my.cnf

启动数据库

[root@localhost mysql]# systemctl start mysqld

使用密码登录

[root@localhost mysql]# mysql -uroot -p'qingdao_MYSQL123'