External database connection

[mati771]

Hi,
I have a problem connecting an external vps server to the cpanel database.
I added the ip of the external database server to the cepanel database.


The php file to connect to the database has been completed correctly:

<?php
$host = "ip";
$db_user = "user";
$db_password = "password";
$db_name = "dbname";
?>


I turned on error display. Shows:
Error: 1044 Description: Access denied for user 'xxx'@'ipadres' to database 'dbename'

 

[GOT]

This means you have not set up the proper grants on the remote database.

 

[cPRex]

Thanks, @GOT - that error indicates the connection is working, but that user doesn't have access, so checking the grants is the way to go!

 

[mati771]

How to solve the problem?
The external server's IP address has been added to the remote database.

 

[cPRex]

Can you try using this tool to ensure the user has access to the database? MySQL® Databases | cPanel & WHM Documentation

 

[mati771]

I've created a database user before.

 

[cPRex]

Alight, and just a bit lower on that page is that user also granted access to the database?

 

[mati771]

 

[cPRex]

You can always re-add the user to the database - it won't hurt anything if that user already has been added, so I would recommend trying that just to see if that helps.

 

[mati771]

to nie pomaga

 

[cPRex]

If you have root access to the server, feel free to submit a support ticket to our team so we can look into this for you.