Mengatasi Mysql PHPMyAdmin phpmyadmin.pma_recent doesn’t exist

Hi Guys, pernah alami error di PHPMyAdmin (PMA) di bagian sisi kiri terdapat error phpmyadmin.pma_recent doesnt exist?

Jadi permasalahan itu karena PHPMyadin untuk database PMA sendiri tidak ada, jadi dia kebingunan untuk melakukan track history PMA.

Solusinya buat database atau pastikan ada database bernama : phpmyadmin

Kemudian isi script adalah sebagai berikut :

— ——————————————————–

—
— Database : `phpmyadmin`
—
CREATE DATABASE IF NOT EXISTS `phpmyadmin`
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
USE phpmyadmin;

— ——————————————————–

—
— Privileges
—
— (activate this statement if necessary)
— GRANT SELECT, INSERT, DELETE, UPDATE, ALTER ON `phpmyadmin`.* TO
— ‘pma’@localhost;

— ——————————————————–

—
— Table structure for table `pma_bookmark`
—

CREATE TABLE IF NOT EXISTS `pma_bookmark` (
`id` int(10) unsigned NOT NULL auto_increment,
`dbase` varchar(255) NOT NULL default ”,
`user` varchar(255) NOT NULL default ”,
`label` varchar(255) COLLATE utf8_general_ci NOT NULL default ”,
`query` text NOT NULL,
PRIMARY KEY (`id`)
)
COMMENT=’Bookmarks’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_column_info`
—

CREATE TABLE IF NOT EXISTS `pma_column_info` (
`id` int(5) unsigned NOT NULL auto_increment,
`db_name` varchar(64) NOT NULL default ”,
`table_name` varchar(64) NOT NULL default ”,
`column_name` varchar(64) NOT NULL default ”,
`comment` varchar(255) COLLATE utf8_general_ci NOT NULL default ”,
`mimetype` varchar(255) COLLATE utf8_general_ci NOT NULL default ”,
`transformation` varchar(255) NOT NULL default ”,
`transformation_options` varchar(255) NOT NULL default ”,
`input_transformation` varchar(255) NOT NULL default ”,
`input_transformation_options` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
)
COMMENT=’Column information for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_history`
—

CREATE TABLE IF NOT EXISTS `pma_history` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default ”,
`db` varchar(64) NOT NULL default ”,
`table` varchar(64) NOT NULL default ”,
`timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP,
`sqlquery` text NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`db`,`table`,`timevalue`)
)
COMMENT=’SQL history for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_pdf_pages`
—

CREATE TABLE IF NOT EXISTS `pma_pdf_pages` (
`db_name` varchar(64) NOT NULL default ”,
`page_nr` int(10) unsigned NOT NULL auto_increment,
`page_descr` varchar(50) COLLATE utf8_general_ci NOT NULL default ”,
PRIMARY KEY (`page_nr`),
KEY `db_name` (`db_name`)
)
COMMENT=’PDF relation pages for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_recent`
—

CREATE TABLE IF NOT EXISTS `pma_recent` (
`username` varchar(64) NOT NULL,
`tables` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT=’Recently accessed tables’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_favorite`
—

CREATE TABLE IF NOT EXISTS `pma_favorite` (
`username` varchar(64) NOT NULL,
`tables` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT=’Favorite tables’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_table_uiprefs`
—

CREATE TABLE IF NOT EXISTS `pma_table_uiprefs` (
`username` varchar(64) NOT NULL,
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
`prefs` text NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`username`,`db_name`,`table_name`)
)
COMMENT=’Tables” UI preferences’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_relation`
—

CREATE TABLE IF NOT EXISTS `pma_relation` (
`master_db` varchar(64) NOT NULL default ”,
`master_table` varchar(64) NOT NULL default ”,
`master_field` varchar(64) NOT NULL default ”,
`foreign_db` varchar(64) NOT NULL default ”,
`foreign_table` varchar(64) NOT NULL default ”,
`foreign_field` varchar(64) NOT NULL default ”,
PRIMARY KEY (`master_db`,`master_table`,`master_field`),
KEY `foreign_field` (`foreign_db`,`foreign_table`)
)
COMMENT=’Relation table’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_table_coords`
—

CREATE TABLE IF NOT EXISTS `pma_table_coords` (
`db_name` varchar(64) NOT NULL default ”,
`table_name` varchar(64) NOT NULL default ”,
`pdf_page_number` int(11) NOT NULL default ‘0’,
`x` float unsigned NOT NULL default ‘0’,
`y` float unsigned NOT NULL default ‘0’,
PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
)
COMMENT=’Table coordinates for phpMyAdmin PDF output’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_table_info`
—

CREATE TABLE IF NOT EXISTS `pma_table_info` (
`db_name` varchar(64) NOT NULL default ”,
`table_name` varchar(64) NOT NULL default ”,
`display_field` varchar(64) NOT NULL default ”,
PRIMARY KEY (`db_name`,`table_name`)
)
COMMENT=’Table information for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_tracking`
—

CREATE TABLE IF NOT EXISTS `pma_tracking` (
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
`version` int(10) unsigned NOT NULL,
`date_created` datetime NOT NULL,
`date_updated` datetime NOT NULL,
`schema_snapshot` text NOT NULL,
`schema_sql` text,
`data_sql` longtext,
`tracking` set(‘UPDATE’,’REPLACE’,’INSERT’,’DELETE’,’TRUNCATE’,’CREATE DATABASE’,’ALTER DATABASE’,’DROP DATABASE’,’CREATE TABLE’,’ALTER TABLE’,’RENAME TABLE’,’DROP TABLE’,’CREATE INDEX’,’DROP INDEX’,’CREATE VIEW’,’ALTER VIEW’,’DROP VIEW’) default NULL,
`tracking_active` int(1) unsigned NOT NULL default ‘1’,
PRIMARY KEY (`db_name`,`table_name`,`version`)
)
COMMENT=’Database changes tracking for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_userconfig`
—

CREATE TABLE IF NOT EXISTS `pma_userconfig` (
`username` varchar(64) NOT NULL,
`timevalue` timestamp NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`config_data` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT=’User preferences storage for phpMyAdmin’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_users`
—

CREATE TABLE IF NOT EXISTS `pma_users` (
`username` varchar(64) NOT NULL,
`usergroup` varchar(64) NOT NULL,
PRIMARY KEY (`username`,`usergroup`)
)
COMMENT=’Users and their assignments to user groups’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_usergroups`
—

CREATE TABLE IF NOT EXISTS `pma_usergroups` (
`usergroup` varchar(64) NOT NULL,
`tab` varchar(64) NOT NULL,
`allowed` enum(‘Y’,’N’) NOT NULL DEFAULT ‘N’,
PRIMARY KEY (`usergroup`,`tab`,`allowed`)
)
COMMENT=’User groups with configured menu items’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_navigationhiding`
—

CREATE TABLE IF NOT EXISTS `pma_navigationhiding` (
`username` varchar(64) NOT NULL,
`item_name` varchar(64) NOT NULL,
`item_type` varchar(64) NOT NULL,
`db_name` varchar(64) NOT NULL,
`table_name` varchar(64) NOT NULL,
PRIMARY KEY (`username`,`item_name`,`item_type`,`db_name`,`table_name`)
)
COMMENT=’Hidden items of navigation tree’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_savedsearches`
—

CREATE TABLE IF NOT EXISTS `pma_savedsearches` (
`id` int(5) unsigned NOT NULL auto_increment,
`username` varchar(64) NOT NULL default ”,
`db_name` varchar(64) NOT NULL default ”,
`search_name` varchar(64) NOT NULL default ”,
`search_data` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `u_savedsearches_username_dbname` (`username`,`db_name`,`search_name`)
)
COMMENT=’Saved searches’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_central_columns`
—

CREATE TABLE IF NOT EXISTS `pma_central_columns` (
`db_name` varchar(64) NOT NULL,
`col_name` varchar(64) NOT NULL,
`col_type` varchar(64) NOT NULL,
`col_length` text,
`col_collation` varchar(64) NOT NULL,
`col_isNull` boolean NOT NULL,
`col_extra` varchar(255) default ”,
`col_default` text,
PRIMARY KEY (`db_name`,`col_name`)
)
COMMENT=’Central list of columns’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_designer_settings`
—

CREATE TABLE IF NOT EXISTS `pma_designer_settings` (
`username` varchar(64) NOT NULL,
`settings_data` text NOT NULL,
PRIMARY KEY (`username`)
)
COMMENT=’Settings related to Designer’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

— ——————————————————–

—
— Table structure for table `pma_export_templates`
—

CREATE TABLE IF NOT EXISTS `pma_export_templates` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(64) NOT NULL,
`export_type` varchar(10) NOT NULL,
`template_name` varchar(64) NOT NULL,
`template_data` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `u_user_type_template` (`username`,`export_type`,`template_name`)
)
COMMENT=’Saved export templates’
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

 

Ok Sekian petunjuk dari saya.

Semoga membantu