- Open phpMyAdmin in a browser and log in as root.
- Create a database called
phpmyadmin - Create a user called
pmaand set the “host” to the hostname or IP address of your web server (if the web server and MySQL are on the same box uselocalhost), make a note of the password, and grant the new user full control over thephpmyadmindatabase. It is recommended that this user does not have access to anything other than this database. - Go to the phpMyAdmin installation directory, where you should find a sub-directory called
examples. - In
examplesyou will find a file calledcreate_tables.sql. Open it in a text editor. - In phpMyAdmin, select the
phpmyadmindatabase and click on the “SQL” tab. - Copy/paste the entire text from
create_tables.sqlinto the text box, and run the query. - Open the config.inc.php file in the phpMyAdmin install directory, and add the following lines (or change the existing settings if they are already there):
$cfg['Servers'][1]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][1]['controluser'] = 'pma'; $cfg['Servers'][1]['controlpass'] = '<your password>'; $cfg['Servers'][1]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][1]['relation'] = 'pma_relation'; $cfg['Servers'][1]['userconfig'] = 'pma_userconfig'; $cfg['Servers'][1]['table_info'] = 'pma_table_info'; $cfg['Servers'][1]['column_info'] = 'pma_column_info'; $cfg['Servers'][1]['history'] = 'pma_history'; $cfg['Servers'][1]['recent'] = 'pma_recent'; $cfg['Servers'][1]['table_uiprefs'] = 'pma_table_uiprefs'; $cfg['Servers'][1]['tracking'] = 'pma_tracking'; $cfg['Servers'][1]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][1]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][1]['designer_coords'] = 'pma_designer_coords';
- Save and close the file.
- Log out of phpMyAdmin
- Log in again
Problem solved.
Sumber: Stackoverflow.Com
Comments