# Maridb - Unable to connect the user from client side

**URL:** <https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605>\
**Category:** MySQL & MariaDB\
**Created:** [March 3, 2022, 3:13am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605 "2022-03-03T03:13:44Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 3:13am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/1 "2022-03-03T03:13:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [March 3, 2022, 3:24am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/2 "2022-03-03T03:24:34Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 5:46am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/3 "2022-03-03T05:46:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 6:51am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/4 "2022-03-03T06:51:53Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 6:57am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/5 "2022-03-03T06:57:44Z")

</div>

IP added details for your reference.

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

---

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 7:02am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/6 "2022-03-03T07:02:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [March 3, 2022, 11:05am UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/7 "2022-03-03T11:05:04Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![pkelaska](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pkelaska/32/4868_2.png) [@pkelaska](https://forums.percona.com/u/pkelaska)\
**Post date:** [March 3, 2022, 12:23pm UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/8 "2022-03-03T12:23:13Z")

</div>

Hello ,  
Thanks for your response

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

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [March 3, 2022, 1:32pm UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/9 "2022-03-03T13:32:55Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [March 4, 2022, 5:24pm UTC](https://forums.percona.com/t/maridb-unable-to-connect-the-user-from-client-side/14605/10 "2022-03-04T17:24:23Z")

</div>

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:

```auto
iptables --list --numeric | grep 3306

```