help center

On this page

Use Adminer to access your site database

Last Update: March 18, 2024

Adminer is a powerful, open-source tool for accessing and making changes to the database.

image 113 Use Adminer to access your site database 1

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 static website server. Remote connections will not work due to security restrictions in place for remote connections.

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 site using SFTP. You can read how to do that here.
  4. Upload the adminer.php file to the public_html folder on your server.

Log in to Adminer

Once installed, you can access Adminer by launching your WordPress site from the  My Elementor Dashboard and navigating to https://example.site.strattic.io/adminer.php.

Logging in to Adminer requires you to get your MySQL Database information for your Elementor static website.

Here is how to find your MySQL credentials for your website.

  1. Log in to your My Elementor Dashboard.
  2. Hover over the website card, and click Manage this website.
image 106 Use Adminer to access your site database 3


3. Click on the Three Dots in the top right of the screen, and select Show DB details. You can easily copy and paste your credentials or view your password.

image 116 Use Adminer to access your site database 5

NOTE: Each static site in your Elementor account has one set of DB credentials.

4. Enter the corresponding information into Adminer and click Login.

image 114 Use Adminer to access your site database 7

You now have access to browse tables and edit data for the MySQL database powering your WordPress site.

image 115 Use Adminer to access your site database 9

NOTE: Some actions like renaming or dropping tables is prohibited to prevent breaking the site.

Have more questions? We’re more than happy to assist.

Link is copied to clipboard!
On this page

Is this article helpful?

Share this article

Wait! You get 30-Day Money-back Guarantee

You have nothing to lose – but the discount

days
hours
minutes
seconds