# Remore databse connection problem

**URL:** <https://community.open-emr.org/t/remore-databse-connection-problem/5300>\
**Category:** OpenEMR Development\
**Created:** [November 20, 2011, 12:02pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300 "2011-11-20T12:02:07Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [November 20, 2011, 12:02pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300/1 "2011-11-20T12:02:07Z")

</div>

**[tpalmieri](https://sourceforge.net/u/tpalmieri/)** wrote on [Sunday, November 20, 2011](https://sourceforge.net/p/openemr/discussion/202506/thread/30e71f7a/#0554):

Operating System: Ubuntu 11.10  
EMR Version: 4.1.0

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [November 20, 2011, 12:09pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300/2 "2011-11-20T12:09:31Z")

</div>

**[tpalmieri](https://sourceforge.net/u/tpalmieri/)** wrote on [Sunday, November 20, 2011](https://sourceforge.net/p/openemr/discussion/202506/thread/30e71f7a/#e41a):

I am trying to install OpenEMR with a connection to a remote database.&nbsp; I can login into and create databases/users etc. from the command line.

When I configure the setup page with the database server host address(IP) for the Server Host (line 1) and the webs erver host address (IP) for the User Hostname and runt the setup page (http://\<site address\>/openemr/setup.php) the database and user is created, but when the setup page tries to reconnecting as the new user the setup fails with the following error:

OpenEMR Setup

Step 3

Configuring OpenEMR…

Connecting to MySQL Server… OK.  
Creating site directory…OK.  
Creating database… OK.  
Creating user with permissions for database… OK.  
Reconnecting as new user… ERROR. Check your login credentials. unable to connect to database as user: ‘openemr’

Can anyone help?

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [November 21, 2011, 1:39pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300/3 "2011-11-21T13:39:14Z")

</div>

**[yehster](https://sourceforge.net/u/yehster/)** wrote on [Monday, November 21, 2011](https://sourceforge.net/p/openemr/discussion/202506/thread/30e71f7a/#0975):

I had some problems with this too, so rather than have the OpenEMR setup script create the database. (Just the empty shell and user without any tables.)&nbsp; I created an empty database and user and used the “I have already created a database” option during setup.  
-Kevin Yeh

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [November 21, 2011, 9:35pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300/4 "2011-11-21T21:35:54Z")

</div>

**[tpalmieri](https://sourceforge.net/u/tpalmieri/)** wrote on [Monday, November 21, 2011](https://sourceforge.net/p/openemr/discussion/202506/thread/30e71f7a/#9695):

I did finally get OpenEMR to connect to the database, and go through the install program , and I can even logon!

But when I return to OpenEMR it starts running the setup page again.&nbsp; I’ve tried this on both a single server, and connecting to a remote database, and get the same results.

Any ideas?

---

<div class="post-metadata">

**Author:** ![system](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb9e4e8ae2ea7faac2e952fd9e38a3ce03aac403.png) [@system](https://community.open-emr.org/u/system)\
**Post date:** [February 1, 2017, 7:39pm UTC](https://community.open-emr.org/t/remore-databse-connection-problem/5300/5 "2017-02-01T19:39:05Z")

</div>

**[leesedol](https://sourceforge.net/u/leesedol/)** wrote on [Wednesday, February 01, 2017](https://sourceforge.net/p/openemr/discussion/202506/thread/30e71f7a/#3b47):

I encounter the same issue. I have not investigate much, I kind of get around the bug by using my root user instead of a new DB user.