Problem accessing MySQL server

Wappler General How To
#1

I have MySQL database in separate custom server and my project on PHP in Wappler have correct connections and with access to the data structure and the data itself inside Wappler, everything is OK.

test db
test db2078×1804 432 KB

But any attempt to make requests from the local server or also the product server gives an access error
server
server2988×714 328 KB
local
local3010×790 406 KB

A couple of weeks ago it all worked fine, I also tried to transfer this database to another server and there was the same problem

#2

The error message pretty much explains what the issue is. Either your guitar user doesn’t have permissions or the db server doesn’t allow connection from the IPs (servers) seen on both screenshots.

#3

On the server there is permission in the firewall for my IP and the question is how, with absolutely identical connection parameters, connecting and editing the database structure in Wappler works, but not in the local server?

#4

I asked the technical support of the hosting where the database is located to check the connection and they connected without any problems from another host.
I also tried connecting with the same parameters via Workbench and everything was fine with this connection too. So it looks like there is still a problem in the way Wappler is trying to do it?

host_test
host_test1324×752 48.8 KB

access
access2474×1804 428 KB

#5

So are you sure the correct database connection details are written in the dmxConnect/modules/Connections/connection_name.php

#6

Yes - there was a problem - the old password, not the one I entered into Targets and Database Connections in Wrappler itself - it seems for some reason Wappler does not update this file correctly.

#7

Well are you sure you are actually saving (ctrl+s) when making the change to the database connection in the Server Connect > Globals? I just tested this and the file is properly updated.

#8

I never use it in Globals, always to change in Database Connection section and in Targets in Project settings. It looks like these things are not synchronized with the Global connection settings

#9

Well these are two different things.
The Globals > Database Connection is used for your server actions.

The Database Manager connection is used for direct connection to your remote database and also to be able to alter and edit the database tables.

In most of the cases the details entered in these two places are different.

1 Like
#10

As far as I understand, this is necessary to properly separate the work from production and development targets? Now I’ll know :slight_smile: Thanks for the help!

#11

No, the database manager is not related to different targets.
Here it’s explained how to setup different database connection details per different targets:

1 Like