สามารถกำหนดผ่าน สามารถกำหนด ได้นะครับ แต่ท่านต้อง มี Host เป็นของตัวเองนะครับ
ในการติดตั้ง Mysql Server จะมีฐานข้อมูลชื่อ mysql ซึ่งเอาไว้จัดการ ฐานข้อมูล โดยเราสามารถใช้ User เดียวกันต่างสิทธิ์ กันได้นะครับ
เช่น เราเข้าใช้งาน 1. root จาก IP 192.168.1.9/255.255.255.0 ไม่สามารถ เพิ่ม / ลบ /ได้ หรือดูได้อยากเดียว
2. เราสามารถเข้าใช้งานฐานข้อมูล จาก ip 192.168.2.0 / 255.255.255.0 เราสามารถใช้งานกลุ่ม IP Class นี้ได้ทั้งหมด
2. ใช้งานจาก IP 192.168.10.9 / 255.255.255.0 สามารถใช้งาน ได้ทุกอย่าง
CREATE TABLE /*!32312 IF NOT EXISTS*/ "user" (
"Host" char(60) collate utf8_bin NOT NULL default '',
"User" char(16) collate utf8_bin NOT NULL default '',
"Password" char(41) character set latin1 collate latin1_bin NOT NULL default '',
"Select_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Insert_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Update_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Delete_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Create_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Drop_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Reload_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Shutdown_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Process_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"File_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Grant_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"References_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Index_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Alter_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Show_db_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Super_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Create_tmp_table_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Lock_tables_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Execute_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Repl_slave_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Repl_client_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Create_view_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Show_view_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Create_routine_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Alter_routine_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"Create_user_priv" enum('N','Y') character set utf8 NOT NULL default 'N',
"ssl_type" enum('','ANY','X509','SPECIFIED') character set utf8 NOT NULL default '',
"ssl_cipher" blob NOT NULL,
"x509_issuer" blob NOT NULL,
"x509_subject" blob NOT NULL,
"max_questions" int(11) unsigned NOT NULL default '0',
"max_updates" int(11) unsigned NOT NULL default '0',
"max_connections" int(11) unsigned NOT NULL default '0',
"max_user_connections" int(11) unsigned NOT NULL default '0',
PRIMARY KEY ("Host","User")
) COMMENT='Users and global privileges';
#
# Dumping data for table 'user'
#
LOCK TABLES "user" WRITE;
/*!40000 ALTER TABLE "user" DISABLE KEYS;*/
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('localhost','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0','0');
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('Computername','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','','0','0','0','0');
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('cmcsvr.cmcsamui.com','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0');
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('localhost','','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0');
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('192.168.1.0/255.255.255.0','root','','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','',0x59,0x59,0x59,'0','0','20000','150');
INSERT INTO "user" ("Host", "User", "Password", "Select_priv", "Insert_priv", "Update_priv", "Delete_priv", "Create_priv", "Drop_priv", "Reload_priv", "Shutdown_priv", "Process_priv", "File_priv", "Grant_priv", "References_priv", "Index_priv", "Alter_priv", "Show_db_priv", "Super_priv", "Create_tmp_table_priv", "Lock_tables_priv", "Execute_priv", "Repl_slave_priv", "Repl_client_priv", "Create_view_priv", "Show_view_priv", "Create_routine_priv", "Alter_routine_priv", "Create_user_priv", "ssl_type", "ssl_cipher", "x509_issuer", "x509_subject", "max_questions", "max_updates", "max_connections", "max_user_connections") VALUES
('192.168.20.50/255.255.255.0','root','','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','','0','0','0','0');
พัฒนาเว็บไซต์
