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.
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. # 1
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. # 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories