Softaculous

Topic : Change mysql default port

Posted By: jashirou on September 28, 2020, 10:16 pm

Hi,

I need to set the AMPPS mysql port to 3307 or 3308 not default because I have a "mariadb" instance running on port 3306 as default databases server...

Someone knows how do I change or where I can change mysql default port?

Thanks in advance...

Posted By: jashirou on September 29, 2020, 8:32 pm | Post: 1

Quote From : jashirou September 28, 2020, 10:16 pm

I found the solution by myself.

I found two "my.cnf" files on ampps directory app, and testing with both I found that the correct file to modify is on the path "AMPPS/mysql/etc/my.cnf" on mac, I guess is the same on linux and windows...

So I change

.
.
.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = ~~3306~~ ---> 3308
= /Applications/AMPPS/var/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = ~~3306~~ ---> 3308
socket = /Applications/AMPPS/var/mysql.sock
.
.
.

And then only start the services from the ampps manager and done...

I hope it is useful for someone...