2021-07-20: WikiSuite will now support all major Linux distros. Thus, the information below is no longer updated. It may still be valid, or not. It will be eventually removed from this site, so anything relevant should be moved to the appropriate site. For anything related to ClearOS, please search among the following: ClearOS site, code base, Developer docs, Wiki or forum.
Please contact us if you would like to help out.
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.