MySQL on lion

CentOs中iptables配置允許mysql遠端存取  

Iptables Allow MYSQL server incoming request on port 3306

CentOS 配置mysql允許遠程登入 
mysql遠程登入解決方案 

為根使用者添加遠程登入:

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.211.xx.8' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;FLUSH PRIVILEGES;

 添加新使用者:

insert into mysql.user(Host,User,Password) values("localhost","youname",password("youpassword)"));flush privileges;create database accountdb;grant all privileges on accountdb.* to 'youname'@'%' identified by 'youpassword)' with grant option;flush privileges;show grants for 'youname'@'%';

 查看使用者：

select Host,User,Password from mysql.user;