How to change the port of a MySQL server in XAMPP


To change the port successfully, i had to change the port number in following files in the mentioned manner.

You can change the port number to 3308 from 3306 in \xampp\mysql\bin\my.ini file in a couple of places.
There is also a couple of default MySQL port settings in the \xampp\php\php.ini file that would also need changing.
Save the files and restart Apache and MySQL to test.

I changed mysql port in xampp, now how do I listen to the new port?


Goto xampp>phpMyAdmin Directory.

Find the config.inc.php file.

Now change this line:

$cfg['Servers'][$i]['host'] = '127.0.0.1';
To

$cfg['Servers'][$i]['host'] = '127.0.0.1:3307';
Now, restart your server.
Latest


EmoticonEmoticon