CentOS6.6 yum安装percona mysql5.6

0.安装percona-release-0.1-3.noarch.rpm

yum -y install http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

1.安装Percona-Server-client-56 Percona-Server-server-56

2.检查开机自启动

3.启动mysql服务

4.为root用户设置密码

set password for root@localhost=password('rootroot'); set password for root@127.0.0.1=password('rootroot');

再次登录

再次查看用户信息

select user,host,password from mysql.user;

5.删除匿名用户

delete from mysql.user where user='';

6.创建允许从任意ip连接到数据库服务器的用户simpleware，密码simpleware

insert into mysql.user(Host,User,Password) values('%','simpleware',password('simpleware'));

7.创建simpleware_test数据库

create database simpleware_test;

8.将simpleware_test数据库的所有权限授予用户simpleware

一直有如下 报错

解决：重启mysql服务

再次执行成功

grant all on chengshi.* to 'chengshi'@'%' identified by '5WQ5IcliZcMCrRde'

远程连接

参考资料：

【完整教程】centOS下通过yum安装配置mysql

https://lvwenhan.com/web-back/371.html