Switch Ports in XAMPP MYSQL

[Elijah]

Hi all,

Want to know how I can change the output port when I install mysql with XAMPP. I want to change the 3307. Awaiting for your response.

Thanks

[Neel]

Edit the value to "port" in xampp / mysql / bin / my.ini

[Elijah]

Hello,

Thank you for your response, I found the file and change it

# Password = your_password  
port             =  3306  --->  3307 
socket           =  "/ xampp / mysql / mysql.sock"

and here also

# The MySQL server 
[ mysqld ] 
port =  3306  --->  3307 
socket =  "/ xampp / mysql / mysql.sock"

After starting the MySQL service, I get this

Mysql start  ( Port 3306 )

Am I missing Something?

[Neel]

I forgot a few things. You have to open port in your router and redirect to the ip. Additionally, although not if it affects, find this line # master-port = <port> uncomment and put 3307. Also seeks the line # skip-networking. But beware, you'll have to check all your settings on the clients, in php.ini, phpmyadmin, etc.

[Elijah]

I figured our why it do not change, however, I tried without this modification and it worked well.