Database Connection / NAS

Scriptcase 10
#1

I wonder if anybody have used NAS for local testing ? I have strange issue with the connection.

I have PC where my project resides. From this computer I can connect to my NAS (running mariaDB).
My NAS IP is: 192.168.0.110
I can run this project locally from the PC (when the Apps connect to the NAS database).

I deploy project on the NAS server and run it. Initially it shows the config screen for the connection.

When I try to setup a connection I get an error:
SQLSTATE[HY000] [1045] Access denied for user ‘pradmin’@‘localhost’ (using password: YES)

I tired (location): localhost, 127.0.0.1, and 192.168.0.110 (which is NAS IP), and none of that works.
The same credentials work when I connect from my PC (from SC).

All of this happens through LAN , so no NAT or any kind of routing should be involved, but I still cannot connect. Firewall on the NAS has all LAN IP’s whitelisted.

Any suggestions ?

PS> running SC10/Win10
my NAS is ASUSTOR-3104T

#2

Have you used a database navigator and connected with it to your database?, mariadb is not prepared for to be used in remote way, you must change it on my.ini and cant use root, you must create another user