Sunday, December 7, 2008

steps to create host,user,db,password

./mysql -u root mysql

./mysql -u root mysql

mysql> insert into
-> host(host,db,Select_priv,Insert_priv,Update_priv,
-> Delete_priv,Create_priv,Drop_priv)
-> values('192.168.15.92','element5','Y', 'Y', 'Y', 'Y', 'Y', 'Y');

insert into user (host,user,password)
-> values('192.168.15.92','user','password('1234'));

mysql> insert into db
-> (host,db,user,Select_priv,Insert_priv,Update_priv,Delete_priv,
-> Create_priv,Drop_priv)
-> values ('192.168.15.92','element5','zmei','Y','Y','Y','Y','Y','Y');


mysqladmin reload

to test :
./mysql -u user -h 192.168.15.92 -p

No comments: