1. 下载rpm安装包
mysql-community-common-5.7.19-1.el6.x86_64.rpm
mysql-community-libs-5.7.19-1.el6.x86_64.rpm
mysql-community-client-5.7.19-1.el6.x86_64.rpm #MySQL客户端程序
mysql-community-server-5.7.19-1.el6.x86_64.rpm #MySQL服务端程序
mysql-community-devel-5.7.19-1.el6.x86_64.rpm #MySQL的库和头文件 可选
mysql-community-embedded-5.7.19-1.el6.x86_64.rpm #MySQL的嵌入式程序 可选
mysql-community-shared-5.7.19-1.el6.x86_64.rpm #MySQL的共享库 可选
mysql-community-test-5.7.19-1.el6.x86_64.rpm #MySQL的测试组件 可选
2. 检查系统中是否已经存在mysql安装包,并卸载已安装的mysql 组件
rpm -qa | grep -i mysql
删除上一步查询出来的已安装的的mysql安装包
rpm –ev --nodeps **
--nodeps 忽略组件的依赖关系,强制卸载
3.安装依赖包顺序
rpm -ivh mysql-community-common-5.7.19-1.el6.x86_64.rpm rpm -ivh mysql-community-libs-5.7.19-1.el6.x86_64.rpm rpm -ivh mysql-community-client-5.7.19-1.el6.x86_64.rpm rpm -ivh mysql-community-server-5.7.19-1.el6.x86_64.rpm
4. 启动mysql服务,设置免密登录以及字符集
service mysqld start
正常启动mysql程序说明安装成功
修改mysql配置文件
character-set-server=utf8 #字符编码
collation-server=utf8_general_ci #字符编码
skip-grant-tables #允许免密登录
port=8888 #端口号
重启mysql服务
service mysqld restart
5 设置密码
1、登陆终端
2、Use mysql
3、update mysql.user set authentication_string=password('***') where user='root' ;
(password(‘***’)):***为设置的root用户密码
4、flush privileges;?刷新权限
查看用户远程访问权限
Use mysql;
Select user,host from user;
授权root用户在任意地址访问
update user set host = '%' where user = 'root'; //用户允许从任意地址访问
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION //赋予root所有权限
FLUSH PRIVILEGES //刷新权限
注释掉skip-grant-tables
#skip-grant-tables
重启服务
service mysqld restart