# Specify which database Ignition uses

**URL:** <https://forum.inductiveautomation.com/t/specify-which-database-ignition-uses/18376>\
**Category:** Ignition\
**Tags:** database\
**Created:** [June 9, 2018, 4:15pm UTC](https://forum.inductiveautomation.com/t/specify-which-database-ignition-uses/18376 "2018-06-09T16:15:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![SvbHvman](https://avatars.discourse-cdn.com/v4/letter/s/858c86/32.png) [@SvbHvman](https://forum.inductiveautomation.com/u/SvbHvman)\
**Post date:** [June 9, 2018, 4:15pm UTC](https://forum.inductiveautomation.com/t/specify-which-database-ignition-uses/18376/1 "2018-06-09T16:15:43Z")

</div>

OK so we can add a connection in the Gateway settings but how do we specify what to name the database that Ignition will create and store the data in? It looks like it created a DB called test on my “learning” machine but I already have a DB called test on my production server.

---

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [June 9, 2018, 8:44pm UTC](https://forum.inductiveautomation.com/t/specify-which-database-ignition-uses/18376/2 "2018-06-09T20:44:06Z")

</div>

Specifying DB name depends on which DB driver you are using. Start here:  
[https://docs.inductiveautomation.com/display/DOC79/Connecting+to+Databases](https://docs.inductiveautomation.com/display/DOC79/Connecting+to+Databases)  
There are additional links on that page for specific DB drivers. Using MySQL as an example. the Connect URL includes the DB name like this:

```auto
jdbc:mysql://localhost:3306/test 

```

The portion after the last slash (“test”) is the DB name. If you want a different DB, create it, and change the Connect URL accordingly.

---

<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:** [June 9, 2018, 8:46pm UTC](https://forum.inductiveautomation.com/t/specify-which-database-ignition-uses/18376/3 "2018-06-09T20:46:22Z")

</div>

Ignition _ **won’t** _ create a database for you. It _ **will** _ create _ **tables** _ within a DB automatically for many situations, but you have to create the DB, user credentials, whatever, with that database’s tools, before a connection will work.