Install phpMyAdmin on LAMP Linux Apache MySQL PHP
1#MySQL #PHP #WebAdministration
Full steps can be found at https://i12bretro.github.io/tutorials/0172.html
--------------------------------------------------------------------
What is phpMyAdmin?
--------------------------------------------------------------------
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. - https://www.phpmyadmin.net
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
wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-english.tar.gz
# create phpmyadmin directory in web root
sudo mkdir /var/www/html/phpmyadmin
# extract the downloaded phpMyAdmin to the folder created
sudo tar xvf phpMyAdmin-latest-english.tar.gz --strip-components=1 -C /var/www/html/phpmyadmin
# create a copy of the sample config file
sudo cp /var/www/html/phpmyadmin/config.sample.inc.php /var/www/html/phpmyadmin/config.inc.php
# 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;
03. Once the installation completes, open a web browser and navigate to http://DNSorIP/phpmyadmin
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 ###
★ Discord: https://discord.com/invite/EzenvmSHW8
★ Reddit: https://reddit.com/r/i12bretro
★ Twitter: https://twitter.com/i12bretro