Welcome Guest. Please Login or Register  


You are here: Index > AMPPS > General Support > Topic : Change mysql default port



Threaded Mode | Print  

 Change mysql default port, I want to change mysql default port to other (1 Replies, Read 10863 times)
jashirou
Group: Member
Post Group: Newbie
Posts: 2
Status:
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...
IP: --   

Change mysql default port
jashirou
Group: Member
Post Group: Newbie
Posts: 2
Status:
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...
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is November 1, 2024, 12:15 am.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.034