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'