Maridb - Unable to connect the user from client side

MySQL & MariaDB
1

The access to the (Acceptance Application server ) and (Databases) servers still does not work from our MySQL client (Citrix IP: 10.50.99.186).

Please help us how to resolve this issue

Thanks

2

Hello @pkelaska,
I don’t understand your issue. What is the IP of the application? What is IP of the MySQL server? What error message are you getting?

1 Like
3

MySQL client (Citrix IP: 10.50.99.186).
( Databases) servers : IP 10.51.111.224

1 Like
4

Database ip is 10.51.111.224

MySQL client (Citrix IP: 10.50.99.186).

Error : cannot connect to database server

They are trying to connect from windows base MYSQL client software

Thanks

1 Like
5

IP added details for your reference.

MariaDB [(none)]> SELECT User,Host FROM mysql.user;

1 Like
6

MariaDB [(none)]> SHOW GRANTS FOR ‘belharra’@‘localhost’;

1 Like
7

have you checked firewall/network? you need mysql port open to connect remotely (port 3306 by default)

1 Like
8

Hello ,
Thanks for your response

Could you please provide me the steps for open & after open port how to check the same.
Thanks

1 Like
9

From MySQL client, can you ping the database? If not, you have general networking issues that must be resolved first. I see that your DB and client are in two different class B networks. What is the netmask of the server and client?

1 Like
10

Hi @pkelaska
you should check if you are using a host based firewall such as iptables and whether there is an exception listed.
To see whether you have an exception, please execute:

iptables --list --numeric | grep 3306
1 Like