WP Engine provides access to your install’s database via phpMyAdmin in our User Portal. In some cases, you might need remote MySQL connections to the database, which means making a MySQL connection from some other remote client to your install’s database. This article will help you set this up.
Quick Guide
- Contact support for remote database access approval.
- Provide IP addresses to support that will be allowed to access the database. (amount of IP addresses are limited)
- Connect to your database using the credentials below
Detailed Guide
First, remote access to your install’s database requires approval from our Support department and is limited to a number of whitelisted source IP addresses. Please contact support to discuss remote database access through the User Portal.
Once your source IP addresses have been whitelisted, you can make a direct connection to your database. The connection details are as follows:
Credentials:
Hostname: INSTALL.sftp.wpengine.com
Username: Found in your install’s wp-config.php file
Password: Found in your install’s wp-config.php file
Port: 13306
SSL: Required
Some clients, including mysql command line clients 5.6 and earlier, require CA certificate validation in order to establish an SSL connection. You can download our root CA certificate for validation at the following URL:
https://storage.googleapis.com/wpengine-public-assets/certificates/wpengine_root_ca.pem