Configuration Essentials
If the default out of box phpMyAdmin settings are changed by the UI they will only work for that login session. If you logout they will be revert back to default.
However, this can be changed with very little effort by carrying out the following procedure.
1.Log into phpMyadmin
2.Import the folowing tables:
C:\wamp64\apps\phpmyadmin5.2.1\sql\create_tables.sql
3.After having imported the create_tables.sql file, you should specify the table names in your config.inc.php file. This file is located in the following directory example:
C:\wamp64\apps\phpmyadmin5.2.1 (Note! file cannot be accessed from the WampServer tray icon)
4.Sample section taken from a working config.inc.php file:
/* Storage database and tables */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';
$cfg['Servers'][$i]['relation'] = 'pma__relation';
$cfg['Servers'][$i]['table_info'] = 'pma__table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma__table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma__pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma__column_info';
$cfg['Servers'][$i]['history'] = 'pma__history';
$cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['favorite'] = 'pma__favorite';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
$cfg['Servers'][$i]['savedsearches'] = 'pma__savedsearches';
$cfg['Servers'][$i]['central_columns'] = 'pma__central_columns';
$cfg['Servers'][$i]['designer_settings'] = 'pma__designer_settings';
$cfg['Servers'][$i]['export_templates'] = 'pma__export_templates';
5.You will also need to have a controluser ($cfg['Servers'][$i]['controluser'] and $cfg['Servers'][$i]['controlpass'] settings) with the proper rights to those tables. For example you can create it using following SQL queries:
CREATE USER 'pma'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'pmapass';
GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';
6. Restart WampServer by right clicking the tray icon and selecting Restart from zero
7.Can check everything has worked by hiding the system databases by:
1.Log in
2.Select the spanner icon (Settings) and not the cog
3.Select the spanner (Features)
4.Select the Databases tab
5.In the section called Hide databases copy / paste the following: (information_schema|mysql|performance_schema|sys|phpmyadmin)
6.Save the changes by selecting Apply and you then should get a confirmation message towards the top of the page saying the changes have been saved
7.Log out and then back in and the system database will be hidden if the above has been successful
8.Set the default Case, Character Set and Collation fro MYSQL:
In order to prevent suprious MySQL errors set the following in my.ini which can be accessed via the WampSever tray menu "MySQL". Under [mysqld] section (useally found at the end) add the following lines and then restart WampServer:
character_set_server=utf8mb4
collation_server=utf8mb4_unicode_ci
character_set_filesystem=utf8mb4c
lower_case_table_names=1 (there is no need to use this entry)
9.To prevent the language option appearing on the phpMyAdmin log in screen edit C:\wamp64\apps\phpmyadmin5.2.1\config.inc.php file adding at the end and then restart all service:
$cfg['Lang'] = 'en_GB'
Note! If you receive the following error message at the bottom of the login screen then check the corresponding language is correctly represented in C:\wamp64\apps\phpmyadmin5.2.1\locale
