Hello
My znote can't connet to database on a port other than 3306. I changed ports (2x) in etc/mysql/my.cnf.
(engine/database/connect.php)
$connect = new mysqli($config['sqlHost'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);
This works perfectly in port 3306
$connect = new mysqli(['xx.xx.xx.xx:3309'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);
It probably works but I see:
string(91) "SELECT `id`, `name`, `password`, `email`, `premdays` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)
who has the idea?
My znote can't connet to database on a port other than 3306. I changed ports (2x) in etc/mysql/my.cnf.
(engine/database/connect.php)
$connect = new mysqli($config['sqlHost'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);
This works perfectly in port 3306
$connect = new mysqli(['xx.xx.xx.xx:3309'], $config['sqlUser'], $config['sqlPassword'], $config['sqlDatabase']);
It probably works but I see:
string(91) "SELECT `id`, `name`, `password`, `email`, `premdays` FROM `accounts` WHERE `id` = LIMIT 1;"
(query - SQL error)
Type: select_single (select single row from database)
who has the idea?