This guide explains how to connect to your WordPress database hosted on Rocket.net using DBeaver, a popular database management tool.
Step 1: Request Remote MySQL Access
Before anything else, you must ask our support team to allow your IP address for remote database connections.
Please contact Rocket.net Support and provide the following:
- Your site name or domain
- Your public IPv4 address (https://whatismyipaddress.com/)
Our team is available 24/7 and will enable remote MySQL access for your IPv4 address.
Step 2: Find Your Database Host & DB credentials
Once remote access is enabled, log in to the Rocket.net control panel.
- Go to https://control.rocket.net
- Open your site by clicking ‘Manage’
- Navigate to Site Information
- Locate the FTP / SSH / SFTP Address
This address will be used as the database host in DBeaver.
Next, you need your database credentials from the wp-config.php file under File Manager. Note down the following values:
- Database Name
- Database Username
- Database Password
Step 3: Create a New Database Connection in DBeaver
Now open DBeaver on your computer and from the top menu, click Database ⏩ New Database Connection ⏩ Choose MySQL ⏩ Click Next
Fill in the connection details as follows:
- Host: FTP / SSH / SFTP Address from the control panel
- Database: Database name from wp-config.php
- Username: Database username
- Password: Database password
- Port: 3306
After filling in the details, click Finish:
If everything is correct and your IP is allowed, the connection will be established successfully.
Need help? Contact Rocket.net Support 24/7 via Live Chat or Ticket
Comments
0 comments
Article is closed for comments.