Change the port number of the MySQL database in XAMPP

Change the port number of the MySQL database in XAMPP

If you have a MySQL database installed on your computer and you want to use a database that comes with XAMPP, you need to change the port number of the database in the XAMPP to avoid conflicts with the installed database. This example shows an example of changing to a 3307 port number.

1. Modify the My.ini in MySQL config

   After you save the restart

   But to use phpMyAdmin to manage your own MySQL database, change the database port number associated with the Apache configuration file (exactly the PHP configuration file) as follows.

2. Change the database port number in Apache

   When you save and then restart Apache, the database that Apache uses by default (the phpMyAdmin managed database) is the XAMPP database.

   Click MySQL Right admin to manage the database that is XAMPP comes with the MySQL database

3. If you want to build a WordPress site also need to pay attention to the database configuration information in WordPress

   Note: What database is used here is not related to XAMPP, which database is used to configure which database

4. Goodluck

Change the port number of the MySQL database in XAMPP