1) Grant select,insert privileges on all databases to user dennis
dennis can connect to mysql server from anywhere
Method <1>
==========
grant select,insert on *.* to dennis identified by 'dennis';
revoke all on *.* from dennis;Method <2>
==========
grant select,insert on *.* to dennis@'%' identified by 'dennis';
revoke all on *.* from dennis@'%';User privileges data in table mysql.user
================================================================2) Grant select, insert privileges on specific database "syty" all tables to
user dennis. He can connect to mysql server from anywhereMethod <1>
==========
grant insert,select on SYTY.* to dennis identified by 'dennis';
revoke all on SYTY.* from dennis;Method <2>
==========
grant insert,select on SYTY.* to dennis@'%' identified by 'dennis';
revoke all on SYTY.* from dennis dennis@'%';User privileges data in table mysql.db
================================================================3) Grant select,insert privileges on current database(select database()) to
user dennis, He can connect to mysql server from anywhere
Waring: If you spcify ON * and you don't have a current database, you will
effect the global privileges!grant insert,select on * to dennis@'%' identified by 'dennis';
revoke all on * from dennis dennis@'%';4) Grant privileges on speicfic table and culumn.
e.g. grant select privilege on database SYTY.navigator.node_namegrant select(node_name)on SYTY.navigator to dennis identified by 'dennis';
revoke select(node_name)on SYTY.navigator from dennis;User privileges data will stored in mysql.tables_priv and mysql.columns_priv
======================== ~ the end ~ ===================================
Good Lucky!
dennis can connect to mysql server from anywhere
Method <1>
==========
grant select,insert on *.* to dennis identified by 'dennis';
revoke all on *.* from dennis;Method <2>
==========
grant select,insert on *.* to dennis@'%' identified by 'dennis';
revoke all on *.* from dennis@'%';User privileges data in table mysql.user
================================================================2) Grant select, insert privileges on specific database "syty" all tables to
user dennis. He can connect to mysql server from anywhereMethod <1>
==========
grant insert,select on SYTY.* to dennis identified by 'dennis';
revoke all on SYTY.* from dennis;Method <2>
==========
grant insert,select on SYTY.* to dennis@'%' identified by 'dennis';
revoke all on SYTY.* from dennis dennis@'%';User privileges data in table mysql.db
================================================================3) Grant select,insert privileges on current database(select database()) to
user dennis, He can connect to mysql server from anywhere
Waring: If you spcify ON * and you don't have a current database, you will
effect the global privileges!grant insert,select on * to dennis@'%' identified by 'dennis';
revoke all on * from dennis dennis@'%';4) Grant privileges on speicfic table and culumn.
e.g. grant select privilege on database SYTY.navigator.node_namegrant select(node_name)on SYTY.navigator to dennis identified by 'dennis';
revoke select(node_name)on SYTY.navigator from dennis;User privileges data will stored in mysql.tables_priv and mysql.columns_priv
======================== ~ the end ~ ===================================
Good Lucky!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货