Quote From : jashirou 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...
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...
|