Server Connection Database Connection Denied For User

database
serverconnect
#1

OS info

  • Operating System : Windows 10.0.17763
  • Wappler Version : 1.9.9

Problem description


I am sure based on the subject that many people will first say “Check your credentials!” Please rest assured that I have checked my credentials and they are correct.

I am receiving the following error when I try to insert a record into a database:

INSERT command denied to user ‘usoflzpu_usofaadmin’@‘localhost’ for table ‘GroupType’"

So, let me explain how I know my credentials are correct.

Here is the screenshot showing the credentials (password is masked)

Screenshot showing connection is ok.

Screenshot of the results of a simple php file (outside of wappler) connecting to the database via mysqli using the same credentials.

wappler%203

Screenshot of the results of a simple php file (outside of wappler) connecting to the database via PDO using the same credentials.

wappler%204

The error message from the Chrome DevTools is in the screenshot below:

And finally, a screenshot of the User Privileges from cPanel.

I am at a loss as to how to correct this issue.

Thanks in advance for your assistance :slight_smile:

Steps to reproduce

#2

Hi Scott, Be sure to check if your database includes “localhost” as an Additional MySQL Access Hosts. I just migrated servers and also had trouble with SFTP because DNS not resolving perfectly. Also MySql may have bind to something else… I’m not a programmer if syntax error is issue, but many here will help. Be sure to do the coding in Wappler interface AFTER successful connections. Good luck!

1 Like