Page 1 of 1

Change MySQL ports

PostPosted: 17. September 2009 09:15
by 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!

Re: Change MySQL ports

PostPosted: 17. September 2009 10:16
by 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

Re: Change MySQL ports

PostPosted: 17. September 2009 11:15
by 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!

Re: Change MySQL ports

PostPosted: 17. September 2009 11:18
by 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.