Now we create an Nginx virtual host configuration file for phpMyAdmin: sudo nano /etc/nginx/conf. GRANT ALL PRIVILEGES ON phpmyadmin.* TO WITH GRANT OPTION Once you are connected, grant all necessary privileges to the phpMyAdmin database: CREATE USER IDENTIFIED BY 'pmapass' Next, connect to the MariaDB shell with the following command: sudo mysql -u root -p Now we create the configuration storage database and tables by running the following command below: sudo mysql < /usr/share/phpMyAdmin/sql/create_tables.sql -u root -p Configure Database and User for phpMyAdmin. * User used to manipulate with storage */ * phpMyAdmin configuration storage settings. Generate a blowfish secret and update the secret in the configuration file: $cfg = 'eDjtEzAk8N3Rk}AFY.vBW}UtYL7VPbGo' /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */Īlso, uncomment the phpMyAdmin storage settings: Next, edit the configuration file: sudo nano /usr/share/phpMyAdmin/ Now we copy the sample phpMyAdmin configuration file and rename it as follows: sudo cp -pr /usr/share/phpMyAdmin/ /usr/share/phpMyAdmin/ To manage databases with phpMyAdmin, your system must have a database instance running and the Nginx web. In this post, we will see how to install phpMyAdmin with Nginx on Ubuntu 20.04. Sudo mv phpMyAdmin-5.1.1-all-languages /usr/share/phpMyAdmin phpMyAdmin helps us to perform database activities such as creating, deleting, querying, database, tables, columns, etc. Next, extract the phpMyAdmin archive to your web server root directory: tar xvf phpMyAdmin-5.1. Installing phpMyAdmin on Debian 11.īy default, phpMyAdmin is not available on Debian 11 Bullseye repository, so you’ll need to manually download the phpMyAdmin from the official page: wget MariaDB> GRANT ALL PRIVILEGES ON app_db.* TO WITH GRANT OPTION MariaDB> CREATE USER IDENTIFIED BY 'your-strong-password' Once you are logged in to your database server you need to create a database for phpMyAdmin installation: MariaDB> CREATE DATABASE app_db This will prompt you for a password, so enter your MariaDB root password and hit Enter. Now we create a new superuser account just for phpMyAdmin: sudo mysql -u root -p If you don’t have a LEMP (Linux + Nginx+ MySQL/MariDB+ PHP) already installed on your server, you can follow our guide here. Before we install any software, it’s important to make sure your system is up to date by running the following apt commands in the terminal: sudo apt update Install phpMyAdmin with Nginx on Debian 11 Bullseye We recommend acting as a non-root sudo user, however, you can harm your system if you’re not careful when acting as the root. A non-root sudo useror access to the root user.SSH access to the server (or just open Terminal if you’re on a desktop).It’s recommended that you use a fresh OS install to prevent any potential issues.A server running one of the following operating systems: Debian 11 (Bullseye).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |