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)