Results 1 to 4 of 4

Thread: Change default port no for mysql in XAMPP

  1. #1
    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.

  2. #2
    Join Date
    Oct 2005
    Posts
    2,394

    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.

  3. #3
    Join Date
    May 2008
    Posts
    3,518

    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

  4. #4
    Join Date
    May 2008
    Posts
    2,393

    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.

Similar Threads

  1. How to change the root password in XAMPP?
    By Cortney in forum Operating Systems
    Replies: 3
    Last Post: 28-12-2009, 08:32 PM
  2. How to change the Default Port and IP address in IIS
    By Shaan12 in forum Windows Software
    Replies: 3
    Last Post: 25-12-2009, 10:54 PM
  3. Replies: 3
    Last Post: 07-11-2009, 08:36 PM
  4. What is the mysql default password ?
    By avit in forum Software Development
    Replies: 3
    Last Post: 11-09-2009, 05:42 PM
  5. Can you change the default VPN port on server 2003 and XP clients?
    By Just Guessing in forum Windows Server Help
    Replies: 6
    Last Post: 05-10-2007, 10:31 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •