linux rpm 查看安装mysql,Linux rpm安装mysql数据库

下面的所有操作建议在root权限下：

1.查看并去查依赖

rpm -qa | grep mysql

2.wget 获取rpm相应的.rpm文件

获取安装源码的方式很多，这里我就采用比较简单的一种，当然还有一种的就是直接下载

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-common-5.7.20-1.el6.x86_64.rp

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-5.7.20-1.el6.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client-5.7.20-1.el6.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.20-1.el6.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-devel-5.7.20-1.el6.x86_64.rpm

3.按顺序安装 按照上面的顺序一个个安装

rpm -ivh mysql-community-common-5.7.20-1.el6.x86_64.rpm

...

这里就忽略不写了

如果你没有暗战顺序安装的话，它会提示你当前你安装的这个.rpm的文件依赖于哪个.rpm的文件！

这种安装方式是相互依赖的

下面是安装成功的截图

4.启动mysql

service mysqld start

5.获取mysql预装root用户的密码

grep 'temporary password' /var/log/mysqld.log

6.登录mysql系统

mysql -uroot -pn%JtA0?pyfcg

7.修改root用户密码

set password = password("Hadoop123456!")密码太简单不符合它的安全策略(ERROR 1819 (HY000): Your password does not satisfy the current policy requirements)，所以设置密码的时候需要有大小写还有特殊符号！

8.允许远程登录

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

mysql> flush privileges;

9.测试

1.查看3306端口是否打开

[root@hadoop01 ~]# netstat -ntpl

Active Internet connections (only servers)

Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name

tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 2948/sshd

tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN 1646/cupsd

tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN 1897/master

tcp 0 0 :::22 :::* LISTEN 2948/sshd

tcp 0 0 ::1:631 :::* LISTEN 1646/cupsd

tcp 0 0 ::1:25 :::* LISTEN 1897/master

tcp 0 0 :::3306 :::* LISTEN 3787/mysqld

2.打开客户端尝试连接

到这里mysql的rpm安装方式就成功了！恭喜你

10.设置开机自启动

[root@hadoop01 ~]# chkconfig mysqld on

[root@hadoop01 ~]#  chkconfig --list | grep mysql

mysqld         0:off1:off2:on3:on4:on5:on6:off

注意红色的地方，这里是

mysqld不是mysql，如果写成mysql 就会报

error reading information on service mysql: No such file or directory错误

11.其他相关mysql的情况

a.查看mysql所有依赖的包 rpm -qa  | grep -i mysql

[root@hadoop01 ~]# rpm -qa | grep -i mysql

mysql-community-devel-5.7.20-1.el6.x86_64

mysql-community-libs-5.7.20-1.el6.x86_64

mysql-community-client-5.7.20-1.el6.x86_64

mysql-community-server-5.7.20-1.el6.x86_64

mysql-community-common-5.7.20-1.el6.x86_64b.查看mysql默认安装位置

[root@hadoop01 ~]# whereis mysql

mysql:

/usr/bin/mysql

/usr/lib64/mysql

/usr/include/mysql

/usr/share/mysql

/usr/share/man/man1/mysql.1.gz