administer multiple servers • manage MySQL users and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NOT NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) TYPE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

KEY `idx_groupid` (`groupid`) USING BTREE, KEY `idx_menuid` (`menuid`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=190 DEFAULT CHARSET=utf8 COMMENT='用户或者用户组权限记录'; CREATE TABLE `pr_admin_groups` ( unsigned DEFAULT '1' COMMENT '1正常，0删除', `remark` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; CREATE TABLE `pr_admin_menus` ( `id` int(11) NOT NULL (`pid`) USING BTREE, KEY `idex_order` (`sort`) USING BTREE, KEY `idx_action` (`url`) ) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COMMENT='权限模块信息表'; CREATE TABLE `pr_admin_users` ( `id`

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NOT NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) TYPE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); (continues on next page) 6.6. Using phpMyAdmin

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); (continues on next page) 6.6. Using phpMyAdmin

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NOT NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) TYPE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT

servers • add, edit, and remove MySQL user accounts and privileges • check referential integrity in MyISAM tables • using Query-by-example (QBE), create complex queries automatically connecting required Forcing this variable to 0 with –lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM tablenames using different lettercases, index corruption may result. Next, save the file and restart NULL default '', description varchar(10) NOT NULL default '', PRIMARY KEY (country_code) ) ENGINE=MyISAM; INSERT INTO REL_countries VALUES ('C', 'Canada'); CREATE TABLE REL_persons ( id tinyint(4) NOT