This week I installed MariaDB 10. I created a new v10 database (migrating from 5 didn’t work). I followed the instructions
https://www.qnap.com/en/how-to/faq/arti ... phpmyadmin
adding
Code: Select all
port: $cfg['Servers'][$i]['port'] = '3307';
socket: $cfg['Servers'][$i]['socket'] = '/var/run/mariadb10.sock';
I then went to run a site and got a connection error.
mysqli_real_connect(): (HY000/2002): No such file or directory
I went to control panel, webserver and edited the php.ini file changed
Code: Select all
mysql.default_socket = "/tmp/mysql.sock"
Code: Select all
mysql.default_socket = " /var/run/mariadb10.sock "
Code: Select all
$connection=mysqli_connect($myhost,$myuser,$mypass,$mydb,3307, '/var/run/mariadb10.sock');
The NAS shutdown overnight, and restarted this morning and on testing my original connection string worked
Code: Select all
$connection=mysqli_connect($myhost,$myuser,$mypass,$mydb);
Have I missed something in the setup which would allow me to remove MariaDB 5 and use the original connection string?
Thanks