操作系统版本:
mysql版本:
详细步骤:
1.查看是否存在mysql
- yum list installed | grep mysql
2.删除系统自带mysql
- yum -y remove mysql-libs.x86_64
3.安装wget
- yum install wget
4.给centos添加rpm源
- ①wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm(一路选Y)
- ②yum localinstall mysql-community-release-el6-5.noarch.rpm
- ③yum repolist all | grep mysql
我要安装5.7,所以将5.6设置为disabled,将5.7设置为enable
- yum-config-manager --disable mysql56-community
- yum-config-manager --enable mysql57-community-dmr
5.安装mysql服务器
- yum install mysql-community-server
6.启动mysql服务
- service mysqld start
7.修改root初始密码
①查看root密码
- grep "password" /var/log/mysqld.log
②设置新密码
特别提醒:mysql对更改密码的内容有规则限定,默认必须同时包含大小写字母,数字,特殊符号,但是我们也可以自己制定密码规则(详细的密码规则相关内容可以查看博客:https://www.cnblogs.com/ivictor/p/5142809.html(表示感谢!))
密码不符合规则提示错误信息:
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- set password for 'root'@'localhost' = password('MySQL123.com');
8.赋给root所有权限{包含设置root远程访问权限(会在库名为mysql的库中的user表中新增一条记录(root用户对应host为%,表示网络通的前提下,root用户可通过任意IP远程访问))}
- ①grant all privileges on *.* to 'root'@'%' identified by '密码';
- ②grant all privileges on *.* to 'root'@'localhost' identified by '密码';
- ③flush privileges;
执行exit;退出mysql
9.查看并设置mysql开机自启动
- chkconfig --list | grep mysql
- chkcofig mysqld on
OK!到这里MySQL就已经安装完成了!
本人操作步骤是参考博客:https://my.oschina.net/ioufev/blog/1605901(表示感谢!)