狮子的雄心,骆驼的耐力,孩子的执著!
发布时间:2012-06-20 22:56:29
一、主机环境 主机: master操作系统:rhel6.0IP:172.16.0.100 MySQL版本:5.1.47 从机: slave操作系统:rhel6.0IP:172.16.0.200 MySQL版本:5.1.47二、创建数据库 分别登录master机和slave机的mysql:mysql –u root –p 创建数据库:create database repl; 三、master机和slave机的相关配置 1、修改mas.........【阅读全文】
发布时间:2012-06-13 15:27:27
mysql>grant ALL PRIVILEGES on *.* to user1@% identified by "password";mysql>grant ALL PRIVILEGES on *.* to "root"@"localhost" identified by "password";mysql>show grants for user1;mysql>drop user 'user1'@'%';mysql>revoke ALL PRIVILEGES from 'user1'@'%' identified by "password";flush privileges.........【阅读全文】