Database credentials: connect to a non-standard MySQL port
Permalink
Hello,
I'd like C5 to connect to a MySQL server which runs on a non-standard port. How would I do that? I've tried config/site.php:
define('DB_SERVER', 'localhost:3333');
It seems that the colon and everything after it is ignored. I can even write 'localhost:HELLO' and it connects to port 3306.
After that I've thought about hacking the core (not nice, I know). In concrete/libraries/loader.php around line 195..200 I've tried adding '?port=3333' to both variants of $dsn string according to some AdoDB manual I found, still with no luck.
Thanks for any enlightenment in this case,
Alex
I'd like C5 to connect to a MySQL server which runs on a non-standard port. How would I do that? I've tried config/site.php:
define('DB_SERVER', 'localhost:3333');
It seems that the colon and everything after it is ignored. I can even write 'localhost:HELLO' and it connects to port 3306.
After that I've thought about hacking the core (not nice, I know). In concrete/libraries/loader.php around line 195..200 I've tried adding '?port=3333' to both variants of $dsn string according to some AdoDB manual I found, still with no luck.
Thanks for any enlightenment in this case,
Alex
Addendum: I managed to enforce the right port through php.ini's mysql.default_port setting. That works, but is a little to harsh - it may have an impact on other PHP/MySQL driven services at the same machine, in case there is more then one MySQL server to connect to.
Hey,
you'll be pleased to know that there's actually a really easy way to do this.
define('DB_DATABASE', 'dbname?port=3333');
strange but true :)
Jon
you'll be pleased to know that there's actually a really easy way to do this.
define('DB_DATABASE', 'dbname?port=3333');
strange but true :)
Jon
How Can I change mysql port ? When i try to install Concrete5 i have message "SQLSTATE[HY000] [2005] Unknown MySQL server host 'http://**********' (90)"
Which file i need to edit ?
Which file i need to edit ?
set host name to
example.com;port=3307
example.com;port=3307
