Setting different MySQL login details on live server

I’ve trawled through loads of posts and info but just can’t find the solution.

I’m working on a site locally (all fine) and am now uploading it to a live server to show the client. I’ve set up the new target and FTP has worked fine so all the files are now there. I’ve also created the MySQL database and copied all the data from my local (localhost using MAMP) machine.

I am now trying to change the connection details so it uses the database on the live server.

I’m editing the Connection Options. If I put in the IP address of the live server for the Server Address and all the other details I get this error:

Error using this Database Connection!
Server Response ; could not find driver

Other posts have said to use localhost instead but, obviously, that’s not going to find the live data.

I’ve also tried manually editing the connection script at /dmxConnect/modules/Connections on the live server but that just gives me a 500 Server Error in the browser console.

In the old days of Dreamweaver, I would upload everything to a live server, edit the connection script and just not upload that script again. I’m happy to work that way with Wappler but it just doesn’t seem to like it!

The live server is one of our dedicated servers running a very standard cPanel setup and I’ve added my local IP to the database so it allows a connection from my local machine but it’s still not having it.

Help!

Community Page
Last updated: