1、删除Centos7自带的mysql版本,有些版本不自带mysql,视版本而定
1、查询
rpm -qa | grep mysql
rpm -qa | grep mariadb
2、删除
rpm -e --nodeps 包名
2、下载并安装MySQL官方的Yum Repository
下载源:
[root@localhost ~] wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
或者下述命令:
[root@localhost ~] wget http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
安装源:
[root@localhost ~] yum -y install mysql57-community-release-el7-10.noarch.rpm
3、安装MySQL服务器
root@localhost ~] yum -y install mysql-community-server
4、MySQL数据库设置
- 启动MySQL
[root@localhost ~] systemctl start mysqld.service
- 查看MySQL运行状态
[root@localhost ~] systemctl status mysqld.service
- 此时MySQL已经开始正常运行,需要找出root的密码,查看下述文件并复制生成的密码
[root@localhost ~] grep "password" /var/log/mysqld.log
- 如下命令登录mysql(使用之前复制的密码)
切换至普通用户(没有无需切换):mysql -uroot -p
- 输入以下命令修改密码规则
mysql>show variables like 'validate_password'; ------ 可通过如下命令查看完整的初始密码规则
----------------------------------------------------------------------------------------
修改密码规则:为了解决修改密码太简单报错问题
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
----------------------------------------------------------------------------------------
此时不能做任何事情,因为MYSQL默认必须修改密码才能正常使用
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; ----- 修改密码为 123456
----------------------------------------------------------------------------------------
还有一个问题就是Yum Repository,以后每次 yum 操作都会自动更新,需要把这个卸载掉
[root@localhost ~] yum -y remove mysql57-community-release-el7-10.noarch
----------------------------------------------------------------------------------------
重新登录mysql验证配置完毕
5、为mysql设置远程用户登录的权限
为mysql设置远程用户登录的权限
-》登录mysql
-》show databases;
-》use mysql;
-》select user,host from user;
-》grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
任何节点以root用户身份都可以使用123456这个密码登录mysql,允许访问mysql下的任何库的任意表
-》 delete from user where host='localhost';
或者:
delete from user where host='ai7-server1';
delete from user where host='127.0.0.1';
-》删除后的结果:
- select user,host from user;
+------+------+
| user | host |
+------+------+
| root | % |
+------+------+
1 row in set (0.00 sec)
-》刷新信息
- flush privileges;
-》mysql的服务重新启动
- [root@localhost ~] systemctl restart mysqld.service(在linux命令行使用,先退出mysql)
6、完全卸载mysql(Centos 6.5)
安装 Centos6.5 mysql 方法:
https://blog.csdn.net/qq_16555103/article/details/87926120#t10 ---- 第五节
完全卸载Centos6.5的mysql步骤
-》rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86_64
-》删除3个配置文件:
- /var/lib/mysql
- /usr/bin/mysql
- /etc/my.cnf