Adminer is an alternative to phpMyAdmin to manage your MySQL / MariaDB (and even Elasticsearch!) data.
Please note that
- ClearOS ships with phpMyAdmin when you install MariaDB (MySQL) so you may not need Adminer.
- Adminer is part of the Elasticsearch for ClearOS app (for browsing your Elasticsearch data)
How to install via the command line
Go to a web accessible directory such as
cd /var/www/html
Get the latest stable version
wget https://www.adminer.org/latest-mysql-en.php
Use here:
http://example.org/latest-mysql-en.php
When you are finished, make sure to delete
cd /var/www/html rm latest-mysql-en.php
How to create a user with full access only to one specific DB
Login you on root user of MariaDB
- Server: localhost
- Username: root
- Password: created in ClearOS's MariaDB app
- Database: leave blank
Then create a new database and select it or select one in a list.
Unless you have a reason to do otherwise, pick utf8_unicode_ci as a database collation (when creating a new database)
Click on Privileges
Click on Create a user
Fill out Server, Username and Password area, then check the All Privileges box. Don't forget to click on save button.
Testing
To test everything is OK. Log out, and login with the newly created user. This user should only have access to one database.