Adminer is a powerful, open-source tool for accessing and making changes to the database.
You can easily install Adminer on your server if you would like direct access to your WordPress MySQL database.
NOTE: You must install Adminer on your Strattic server. Remote connections will not work due to security restrictions in place for remote connections.
How to Install Adminer
Follow these steps to install Adminer on your site:
Download the latest release of the MySQL Version of Adminer from their website.
Rename the downloaded file to
adminer.php. It will originally look something like
Connect to your Strattic account using SFTP. You can read how to do that here.
adminer.phpfile to the
public_htmlfolder on your server.
Launch your WordPress Dashboard from your Strattic dashboard and go to
Logging in to Adminer
Once installed, you can access Adminer by launching your WordPress site from the Strattic Dashboard an visiting the following URL:
You will change the URL to match the URL of your WordPress install.
Logging in to Adminer requires you to get your MySQL Database information from your Strattic site.
Enter the corresponding information into Adminer and click Login.
You now have access to browse tables and edit data for the MySQL database powering your WordPress site.
NOTE: Some actions like renaming or dropping tables is prohibited to prevent breaking the site.