Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Having Difficulty with MySQL connection
09-11-2012, 09:48 AM, (This post was last modified: 09-11-2012, 10:10 AM by WhiteRabit.)
#13
RE: Having Difficulty with MySQL connection
(09-11-2012, 09:16 AM)jtrick Wrote: I just wanted to say that you have to explicitly give permissions to the db user user you want to use for the db you're creating to use for the company in webERP. This is one of a few items that could cause this error, but worth checking because it could be an easy fix for the issue.



Also, do you have the host set to 'localhost' in config.php?

(@~ line 15):
$host = 'localhost';

I didn't run into this issue and it could be something specific to the setup of your host and/or webERP, but this could be part of the problem.

Wow, thanks for the prompt reply. This is a good forum.
Yes, I set the db to use this 'mysqluser' account like other open source software. The application is hosted, and they suggest enabling remote connections.
Host: mysql.serverxxxx.com (same result when $host is 'localhost'
Port: 3306
I did not see where the post can be set.

I found the problem - Company name ie dbname is case sensitive. That means when I use webERP, I have to set that in config and folder name under Companies.


Reply


Messages In This Thread
RE: Having Difficulty with MySQL connection - by WhiteRabit - 09-11-2012, 09:48 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)