How to Install and Use Adminer for Accessing Your Site Database

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:

1. Download the latest release of the MySQL Version of Adminer from their website.

2. Rename the downloaded file to adminer.php. It will originally look something like adminer-4.7.7-mysql,

3. Connect to your Strattic account using SFTP. You can read how to do that here.

4. Upload the adminer.php file to the public_html folder on your server.

5. Launch your WordPress Dashboard from your Strattic dashboard and go to https://your-project.site.strattic.io/adminer.php.

Logging in to Adminer

Once installed, you can access Adminer by launching your WordPress site from the Strattic Dashboard an visiting the following URL:

https://your-project.site.strattic.io/adminer.php.

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.