Install phpMyAdmin on LAMP Linux Apache MySQL PHP

#MySQL #PHP #WebAdministration

--------------------------------------------------------------------
What is phpMyAdmin?
--------------------------------------------------------------------
 
This tutorial assumes a working Apache2, PHP and MySQL/MariaDB environment is already installed
 
   01. Log into the Linux machine
   02. Run the following commands in terminal to install phpMyAdmin:
         # update apt repositories
         sudo apt update
         sudo apt upgrade
         # download latest phpMyAdmin
         # create phpmyadmin directory in web root
         sudo mkdir /var/www/html/phpmyadmin
         # extract the downloaded phpMyAdmin to the folder created
         # create a copy of the sample config file
          # set folder owner
          sudo chown www-data:www-data /var/www/html/phpmyadmin
         # restart apache service
         sudo systemctl restart apache2
         # connect to MySQL and create a user to use with phpMyAdmin
         sudo su
         mysql -u root
          CREATE USER 'i12bretro'@'localhost' IDENTIFIED BY 'some_very_complex_password';
         GRANT ALL PRIVILEGES ON * . * TO 'i12bretro'@'localhost';
         FLUSH PRIVILEGES;
   04. Log in using the user created in the steps above
   05. Enjoy visual browser based control over MySQL/MariaDB
 

### Connect with me and others ###