Change MySQL ports

[Tremal Naik]

Hi! I'm installed XAMPP but I have a MySQL already running at the machine. How can I change the port of the XAMMP MySQL? Thanks!

[Izzy]

Try in C:\xampp\mysql\bin\my.ini and change every instance of port 3306 to the port of your choice, but make sure the port you select to replace 3306 doesn't conflict with anything else.

Save the file and then restart MySQL in XAMPP.

This link will give you an up to date list of all tcp/udp port numbers already assigned:
http://www.iana.org/assignments/port-numbers

[Tremal Naik]

Hi!

The my.ini file not exists but I've modified my.cnf at two lines on [client] and [mysqld] But phpMyAdmin don't works and the status page in XAMPP says that MySQL is desactivated.

The Windows service active is MySQL as say the mysql_installservide.bat.

Thanks!

[Tremal Naik]

Another dates:

When I run the database which is on 3306 port, the XAMPP Control Panel says that DataBase is active, but when I try close, the process never finish.