Adminer is a user interface for manipulating your database. It is very similar to phpMyAdmin but has a much reduced footprint and is thus snappier to work with. For documentation see the Adminer website.
Accessing Database manager
You can access Database manager in three ways.
- Click on the “More” menu (three dots) in the site list and select “Open database manager”
- Click the “Database Manager” button at the top of the site detail page
- Database manager is available on port
15001
on your site’s IP (which you can find on the site details page)
Basic Usage
Switching databases
When you visit Adminer by clicking a button in DevKinsta you are always taken to the appropriate database automatically but you can switch between them within Adminer as well. You can switch between databases using the dropdown in the top of the left hand sidebar.
Viewing table structure
Clicking on any table name in the sidebar will take you to the structure view of that table. You can see each field and the type of data it holds.
Viewing table data
Clicking “SELECT” in the sidebar next to the table name will take you to a page that shows you the first 50 items within that table. You can dive into different parts of the table using the controls at the top of the page.
You need to click the blue title above the boxes to gain access to the forms they contain. You can then set up views using multiple select, search, sort, limit and length directives. Note that your searches are mapped to the URL so you can save views by bookmarking the page.
If you need a more elaborate SQL query to view data you can click edit next to the query displayed in the top of the screen to gain access to an SQL editor.
Manipulating data
You can edit any row by clicking the edit link within the results. When on the select data page you can add new items by clicking the “NEW ITEM” button. This will give you a form with all the fields to fill out.
You can run complex SQL queries by clicking the “SQL COMMAND” link at the top of the sidebar. This will take you to the SQL editor where you can type your query. Clicking “History” in the box below the editor will bring up recently run commands you can load up.
Go deeper via command line
If you’d like to manipulate your database via console you can do that.
Enter through virtual machine
# Enter into devkinsta_db container
docker exec -it devkinsta_db bash
# Connect to database
mysql -h localhost -u root -p
# Run SQL commands
show databases;
Enter through host machine
You can find these infos on the site details page.
# Enter into database directly from host OS
mysql -h 192.168.99.254 -P 15100 -u root -p