How to configure ProxySQL port

[Alex S]

Hi,

I would like ProxySql to listen to query traffic on a port number other than 6033.

According to documentation this is the default but I do not see how this value may be modified.

Can the port number be modified and, if so, how? 

Thank you, -Alex

[Nikolaos Vyzas]

https://github.com/sysown/proxysql/wiki/Global-variables#mysql-interfaces

[Aaron]

I'm trying to set the port back to 3066.  The change persists until I do a load mysql variables to runtime then they revert back to the default values.

What is the correct way to change the client connection port and keeping it persistent?

[brianr]

Just *how* do you make the changes? 

Remember ProxySQL has a config file, whichis mostly ignored and overruled by what's inside its databse (save xxx to disk) 
So if you load to runtime, next time it restarts it will "only" read whats in the database, not in your configfile. 

[René Cannaò]

After changing mysql-interfaces or mysql-threads, you should not run LOAD MYSQL VARIABLES TO RUNTIME because these 2 variables cannot be loaded at runtime. Attempt to load them at runtime will cause their reset.
In other words, after changing mysql-interfaces or mysql-threads, you need to SAVE MYSQL VARIABLES TO DISK and then restart

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.