Warning!

When changing MySQL versions will start a blank SQL system i.e. there will be no databases. Therefore, it is necessary to export your current SQL databases and when the new version has been successfully initialised import them. You cannot copy the database files.

A recommend application for backing up and restoring databases is SQLBackupAndFTP https://sqlbackupandftp.com You can use the free version which has a limitation of only backing up maximum of 2 databases at a time. There are no restricting when it comes to restoring databases.


After installing and activating another MySQL version you must complete the following stages in order for any modified settings in the phpMyAdmin UI to be saved.

1.Log into phpMyadmin

2.Import the folowing tables:

C:\wamp64\apps\phpmyadmin5.2.1\sql\create_tables.sql

3.No need to edit the config.inc.php file as there no changes are made when installing another version of MySQL.

4.You will also need run the following two SQL queries:

CREATE USER 'pma'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'pmapass';

GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';

5.Restart WampServer by right clicking the tray icon and selecting Restart from zero

6.Can check everything has worked by hiding the system databases by:

○Log in

○Select the spanner icon (Settings) and not the cog

○Select the spanner (Features)

○Select the Databases tab

○In the section called Hide databases copy / paste the following: (information_schema|mysql|performance_schema|sys|phpmyadmin)

○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:

 

○Log out and then back in and the system database will be hidden if the above has been successful

7.To set SQL default character set utf8mb4 and collation utf8mb4_0900_ai_ci  from WampServer icon select MySQL, then select my.ini and carry out the following amendments:

And under the section called [mysqld] add the following lines:

character-set-server = utf8mb4

collation-server = utf8mb4_0900_ai_ci

character-set-filesystem = utf8mb4

8.Then to increase the Login Timeout in PHPMyAdmin, see: PHPMyAdmin Login Timeout



Topic last reviewed: 25/09/26