# Ignition mariaDB connection

**URL:** <https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [January 2, 2020, 4:23pm UTC](https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012 "2020-01-02T16:23:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![andrea.wohlers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andrea.wohlers/32/17969_2.png) [@andrea.wohlers](https://forum.inductiveautomation.com/u/andrea.wohlers)\
**Post date:** [January 2, 2020, 4:23pm UTC](https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012/1 "2020-01-02T16:23:22Z")

</div>

Hello every body!  
I’ve Ignition 7.9.13 installed in a Linux server (IP: 10.0.1.66) which I can connect via VPN.

in the same server there’s a mariaDB server and a Database (db name: ‘V2949’). I tried to connect in 2 ways and none is working…

1- using “MySQL ConnectorJ” JDBC Driver

 ![db%20mysql](https://us1.discourse-cdn.com/inductiveautomation/original/2X/2/21a2be228474d39d50be1434dd5839b321ed5b18.png)

2- using a custom driver

 ![db%20mariadb](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7d42a9a7e836977e12fc05b1545e4fdb4a3b057d.png)

drivers list:

 ![sql%20driver](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/53c36117ec26d1f8eba06d3d74c6845af17034bc.png)  
mariadb driver:  
 ![mariadb%20driver](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/358858bd562d8827c518e14d5c7b06954d9b5f51.png)

 ![db](https://us1.discourse-cdn.com/inductiveautomation/original/2X/c/c94d1ceb87fdf7ff51c7b9fa28c72eb6914b8bb8.png)  
the errors are the same:

```auto
Cannot create PoolableConnectionFactory (Could not connect to address=(host=10.0.1.66)(port=3306)(type=master) : Access denied for user 'Ignition'@'10.0.1.66' (using password: YES) Current charset is UTF-8. If password has been set using other charset, consider using option 'passwordCharacterEncoding')

```

I have tried using Database Workbench to connect to this server and everything is working fine.  
 ![workbench](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/baec22cbed77ddf510f7f4ef7c3c8705daa337eb.png)

can please somebody help me? 🙂  
thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 2, 2020, 4:28pm UTC](https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012/2 "2020-01-02T16:28:45Z")

</div>

> [@andrea.wohlers](#):
>
> Access denied for user 'Ignition'@'10.0.1.66'

That looks pretty clear. Are you using that same exact user in your workbench?

---

<div class="post-metadata">

**Author:** ![andrea.wohlers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andrea.wohlers/32/17969_2.png) [@andrea.wohlers](https://forum.inductiveautomation.com/u/andrea.wohlers)\
**Post date:** [January 3, 2020, 7:44am UTC](https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012/3 "2020-01-03T07:44:39Z")

</div>

yep, that’s why i’m so upset 😕

![mariadb%20connection%20workbench](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/511d89f85bda0c13bc226c473446cf94e3c76569.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 3, 2020, 12:48pm UTC](https://forum.inductiveautomation.com/t/ignition-mariadb-connection/31012/4 "2020-01-03T12:48:57Z")

</div>

Are you running workbench itself right on the gateway? If not, then your workbench user is not @‘10.0.1.66’, but the IP address of your workstation. You need to inspect the privilege tables in MariaDB to see what is being applied. MariaDB (and MySQL) treat different source IPs as different users, unless there’s a wildcard in the privilege tables.