1. Gilles Plante
  2. Valentina Studio
  3. 火, 7月 09 2019, 08:56 PM
  4.  メールで購読
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
コメント
There are no comments made yet.
Gilles Plante 承諾済みの回答
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!
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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.
コメント
There are no comments made yet.
  • ページ :
  • 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