首页 > 代码库 > MYCAT 安装部署

MYCAT 安装部署

下载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 安装部署