Save and close the file then restart the Apache service to apply the changes: systemctl restart httpd Once the download is completed, change the ownership and permission of the Adminer directory to apache user:Ĭhown -R apache:apache /var//var/log/httpd/adminer-error.logĬustomLog /var/log/httpd/adminer-access.log combined Next, change the directory to Adminer and download Adminer with the following command:Ĭd /var/www/html/adminer wget -O index.php First, create a directory for Adminer inside the Apache web root using the following command: mkdir /var/www/html/adminer Next, you will need to download the latest version of Adminer on your server. MariaDB > FLUSH PRIVILEGES MariaDB > EXIT Download Adminer MariaDB > GRANT ALL ON adminer.* TO flush the privileges and exit from the MariaDB shell with the following command: Next, grant all the privileges to the Adminer database with the following command: MariaDB > CREATE DATABASE adminer MariaDB > CREATE USER IDENTIFIED BY 'password' Once you are log in, create a database and user with the following command: To do so, log in to the MariaDB shell with the following command: mysql Next, you will need to create a database and user for Adminer. Once you are finished, you can proceed to the next step. Systemctl start httpd mariadb systemctl enable httpd mariadb You can install all of them by running the following command:ĭnf install httpd mariadb-server php php-mysqli php-curl php-json -yĪfter installing all the packages, start and enable Apache and MariaDB service with the following command:
How to install sqlite on lamp password#
How to install sqlite on lamp how to#
In this tutorial, I will explain how to install Adminer on Alma Linux 8. It is simple, lightweight, and designed with strong security and user experience in mind.
With Adminer, you can manage several databases including, MySQL, MariaDB, PostgreSQL, SQLite, MS SQL, Oracle, Elasticsearch, MongoDB, and more. Adminer formerly known as phpMinAdmin is a full-featured database management tool written in PHP.