1. Gilles Plante
  2. Valentina Studio
  3. Tuesday, July 09 2019, 08:56 PM
  4.  Subscribe via email
Hi all.

I just installed Valentina Studio (Free) and would like to connect to a MariaDB database. The MariaDB server is running in a VM undewr Debian, and VM is seen from the host (ping works). To connect I select MySQL, Standard TCP/IP, set the IP address and use a USer than can connect remotely. Port is set to 3306.

When I hit Connect I get:

Error(2002) HY000: "Can't connect to MySQLServer on '<ip address>" (10061)


Searching on Internet I discovered that by default MariaDB accepts only connections from local host. I changed bind-address to 0.0.0.0 ans and I still get the same error message.

What am I doing wrong ?

Thanks

Gilles Plante
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello,

Please check that the port is opened in the firewall.

Is Debian installed in the Virtual Machine?

What is the host system? For macOS, I can use the following command to check the port:
nc -vz 192.168.1.25 3306

For Windows or Linux, I think telnet can be used.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Gilles Plante Accepted Answer
Hi Sergey,

everything now works fine. after making the change to the configuration, I forgot to restart the db server:(

I just started using Valentina Studio (Free), looks like a great tool!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories