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'
远程连接
参考资料：
https://lvwenhan.com/web-back/371.html
网友评论