首页 > 其他 > 详细

MYCAT 安装部署

时间:2016-12-09 08:16:14      阅读:173      评论:0      收藏:0      [点我收藏+]
下载mycat文件到对应目录直接启动
/usr/local/mycat/bin/mycat start
 
 
netstat -na|grep 8066
ps -ef|grep mycat
 
chown -R mycat .   
chgrp -R mycat .
 
groupadd mycat
adduser -r -g mycat mycat
 
 
flush privileges;
 
CREATE USER ‘mycat‘@‘192.168.6.6‘ IDENTIFIED BY ‘sdflc@mycat‘;
 
GRANT INSERT,select,UPDATE,DELETE ON soa_center.* TO ‘mycat‘@‘%‘;
GRANT INSERT,select,UPDATE,DELETE ON sdflc_weather.* TO ‘mycat‘@‘%‘;
GRANT INSERT,select,UPDATE,DELETE ON soa_cms.* TO ‘mycat‘@‘%‘;
flush privileges;
 
 
 
CREATE USER ‘read‘@‘192.168.6.6‘ IDENTIFIED BY ‘sdflc@read‘;
 
GRANT select ON *.* TO ‘read‘@‘%‘;
 
ALTER USER ‘read‘@‘192.168.6.6‘ IDENTIFIED BY ‘sdflc@read‘;
 
 

MYCAT 安装部署

原文:http://www.cnblogs.com/chenyuegu/p/6147959.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!