- Open phpMyAdmin in a browser and log in as root.
- Create a database called
phpmyadmin
- Create a user called
pma
and 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 thephpmyadmin
database. 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
examples
you will find a file calledcreate_tables.sql
. Open it in a text editor. - In phpMyAdmin, select the
phpmyadmin
database and click on the “SQL” tab. - Copy/paste the entire text from
create_tables.sql
into 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