Using ReadyNAS 102 as MySQL with LibreOffice direct connector
Hello guys, I recently bought a ReadyNAS 102 and I'm was wondering if I could use it to store a MySQL database (the answer in yes), managing it with Libre Office Base (the answer is: I hope)
I'm working with Xubuntu 14.04 and LibreOffice 18.104.22.168, I already installed phpMyAdmin on the NAS and, on my PC, the extension MySQL Connector from here http://extensions.libreoffice.org/extension-center/mysql-native-connector
in phpMyAdmin I created the database my_dbase, giving to the user guest all the privileges. My NAS has a static DNS like: 192.168.1.50.
Then, I followed this guide: https://wiki.openoffice.org/wiki/Database/Drivers/MySQL_Native/1.0
The problems start since: Setting up database connection
Name of the database: my_dbase
Host: 192.168.1.50 (or localhost?)
Socket: no idea if I have to use it and how...
I try to connect as guest, with the guestpassword I choose and the result is:
Can't connect to MySQL at 192.168.1.50 (111)
If I use port 7082, the same as for php, the answer takes mor time and it's:
lost connection to MySQL server at 'reading initial communication packet', system error:0
Any idea how to set it in a proper way?
Thank you very much!