centos7里mysql的安装（为搭建hive作准备）

1.解压mysql安装包到/usr/app/mysql里面，cd /usr/app/mysql

[root@master mysql]# chomd 777 *

[root@master app]# rpm -qa|grep mariadb

查看并卸载 mariadb

[root@master app]# rpm -e --nodeps mariadb...........

2. 按如下顺序依次按照 MySQL 数据库的 mysql common、mysql libs、libs-compat, mysql client

,server软件包。

安装sever包时加上--nodeps --force 

[root@master mysql]# rpm -ivh mysql-community-server-5.7.12-1.el6.x86_64.rpm --nodeps --force

3.启动mysql赋予权限

systemctl start mysqld

systemctl status mysqld

cat /var/log/mysqld.log | grep password（查看临时密码）

[root@master ~]# mysql_secure_installation （初始化数据库）

mysql -uroot -p.....进入数据库

可用help ‘grant’；查看帮助

grant all privileges on *.* to root@'localhost'

identified by 'Password123$';

grant all privileges on *.* to root@'%' identified by

'Password123$';

flush privileges;

select user,host from mysql.user where user='root';

# 查询 root 用户授权情况

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

| user | host |

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

| root | % |

| root | localhost |

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

2 rows in set (0.00 sec)