MySQL Port change

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

MySQL Port change

Postby GEE_ » 29. November 2009 19:59

Hello,

A few years ago one of our serves got hit with a SQL attack :twisted: ...
It wiped out over 5000 tracks of music and also our server software for our station. I had someone come in and work on the server and during that time I had them change the MySQL port from 3306 to a different number. For the past 10 years no attacks and all is well. I am upgrading one of our servers with the station broadcast software on it and I would like to change the port again. Can someone help me with this since I do not know where to find the file to change in XAMPP? I thought it would be an .ini or.cnf file but I could not find one.
Any help would be greatly appreciated.

Thank you,

GEE
GEE_
 
Posts: 6
Joined: 29. November 2009 01:03

Re: MySQL Port change

Postby Izzy » 29. November 2009 22:41

Missing support info - what XAMPP version and which Windows OS?
So assuming latest stable XAMPP version.

In \xampp\mysql\bin folder find my.ini file, edit using a text editor, save the file and restart MySQL.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL Port change

Postby GEE_ » 30. November 2009 01:27

Sorry about that Izzy,

Thanks for the quick reply.
It's not like me to place a half ^rsed post up on a forum. :oops: I have the latest version of XAMPP and Mickey Soft XP Pro service pack 3.
And also double :oops: :oops: for my stupidity not seeing the my.ini. . I'm batting 100 here...

Thanks again.
GEE_
 
Posts: 6
Joined: 29. November 2009 01:03

Re: MySQL Port change

Postby Izzy » 30. November 2009 01:38

No worries, mate.

Good luck.
Izzy
 
Posts: 3344
Joined: 25. April 2006 17:06

Re: MySQL Port change

Postby GEE_ » 30. November 2009 02:58

Hi Izzy,

All set... I got the station's software connecting to the database now with the new port. I had a problem with phpMyAdmin, but I figured it out. I just had to make a couple extra changes.


Cheers
GEE_
 
Posts: 6
Joined: 29. November 2009 01:03


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 48 guests