Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Change default port no for mysql in XAMPP

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 28-12-2009
Member
 
Join Date: Nov 2004
Posts: 1
smile Change default port no for mysql in XAMPP
  

Hello Everyone,
Seasons Greetings to all

I am using xampp and want to change the default port no. for mysql.
Also, PLZ suggest the changes that need to be done to phpmyadmin config files, so as to still use the phpmyadmin after port no. change.

Thanks.

Reply With Quote
  #2  
Old 28-12-2009
Member
 
Join Date: Oct 2005
Posts: 2,388
Re: Change default port no for mysql in XAMPP

All you need to do is to first open up the SQL server configuration manager and then click the protocols for MS sql server. Now right click the TCP/IP. In the property window select the Ip address tab and then specify the new port number for the server. Now restart the application.
Reply With Quote
  #3  
Old 28-12-2009
Member
 
Join Date: May 2008
Posts: 3,524
Re: Change default port no for mysql in XAMPP

Hey do the following to change the port number. Hope this will help you.
  • First stop the XAMPP server
  • Open this file httpd.conf file from the installation folder
  • Look for the Port that your XAMPP is using i.e. Port 80 or any thing else and change it to the other port number which you wish to.
  • Now in the same folder look for the ServerName which will define the name of the server consist of the port number, update this also.
  • Save the setting and restart your system
Reply With Quote
  #4  
Old 28-12-2009
Member
 
Join Date: May 2008
Posts: 2,378
Re: Change default port no for mysql in XAMPP

For changing the default port number in the mysql in windows. Try Open C:\Program Files\Apache Software Foundation\Apache2.2\conf and search for a file named http.conf in that file look out for a line which would be similar to the one below
Listen 12.34.56.78:80 (in my file its on line no. 53)
Change the ip address as you want.
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Change default port no for mysql in XAMPP"
Thread Thread Starter Forum Replies Last Post
How to change the root password in XAMPP? Cortney Operating Systems 3 28-12-2009 08:32 PM
How to change the Default Port and IP address in IIS Shaan12 Windows Software 3 25-12-2009 10:54 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 08:36 PM
What is the mysql default password ? avit Software Development 3 11-09-2009 05:42 PM
Can you change the default VPN port on server 2003 and XP clients? Just Guessing Windows Server Help 6 05-10-2007 10:31 AM


All times are GMT +5.5. The time now is 11:02 AM.