External database connection
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:
I turned on error display. Shows:
Error: 1044 Description: Access denied for user 'xxx'@'ipadres' to database 'dbename'
-
This means you have not set up the proper grants on the remote database. 0 -
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! 0 -
How to solve the problem? The external server's IP address has been added to the remote database. 0 -
Can you try using this tool to ensure the user has access to the database? MySQL" Databases | cPanel & WHM Documentation 0 -
I've created a database user before. 0 -
Alight, and just a bit lower on that page is that user also granted access to the database? 0 -
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. 0 -
to nie pomaga :( 0 -
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. 0
Please sign in to leave a comment.
Comments
9 comments