Change MySQL ports

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Change MySQL ports

Postby Tremal Naik » 17. September 2009 09:15

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!
Tremal Naik
 
Posts: 8
Joined: 27. August 2009 09:18

Re: Change MySQL ports

Postby Izzy » 17. September 2009 10:16

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
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: Change MySQL ports

Postby Tremal Naik » 17. September 2009 11:15

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
 
Posts: 8
Joined: 27. August 2009 09:18

Re: Change MySQL ports

Postby Tremal Naik » 17. September 2009 11:18

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.
Tremal Naik
 
Posts: 8
Joined: 27. August 2009 09:18


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 59 guests