How to Install phpMyAdmin in apache Ubuntu?
To Installing phpMyAdmin You need to follow two stepsStep 1. Installing phpMyAdmin
1. sudo apt update
2. sudo apt install phpmyadmin php-mbstring php-zip php-gd php-json php-curl
3. sudo mysql
4. mysql -u root -p
5. UNINSTALL COMPONENT "file://component_validate_password";
6. exit
7. sudo apt install phpmyadmin
8. INSTALL COMPONENT "file://component_validate_password";
9. sudo phpenmod mbstring
10. sudo systemctl restart apache2;
Step 2 — Adjusting User Authentication and Privileges 1. sudo mysql
2. SELECT user,authentication_string,plugin,host FROM mysql.user;
Output +------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | | auth_socket | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | debian-sys-maint | *8486437DE5F65ADC4A4B001CA591363B64746D4C | caching_sha2_password | localhost | | phpmyadmin | *5FD2B7524254B7F81B32873B1EA6D681503A5CA9 | caching_sha2_password | localhost | +------------------+-------------------------------------------+-----------------------+-----------+ 5 rows in set (0.00 sec)
3. ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';
4. ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
5. SELECT user,authentication_string,plugin,host FROM mysql.user;
Output +------------------+-------------------------------------------+-----------------------+-----------+ | user | authentication_string | plugin | host | +------------------+-------------------------------------------+-----------------------+-----------+ | root | *DE06E242B88EFB1FE4B5083587C260BACB2A6158 | caching_sha2_password | localhost | | mysql.session | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | mysql.sys | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE | caching_sha2_password | localhost | | debian-sys-maint | *8486437DE5F65ADC4A4B001CA591363B64746D4C | caching_sha2_password | localhost | | phpmyadmin | *5FD2B7524254B7F81B32873B1EA6D681503A5CA9 | caching_sha2_password | localhost | +------------------+-------------------------------------------+-----------------------+-----------+ 5 rows in set (0.00 sec)
Configuring Password Access for a Dedicated MySQL User
1. sudo mysql
2. mysql -u root -p
3. CREATE USER 'userexample'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'password';
4. ALTER USER 'userexample'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
5. GRANT ALL PRIVILEGES ON *.* TO 'userexample'@'localhost' WITH GRANT OPTION;
6. exit
https://your_domain_or_IP/phpmyadmin
Step 3 — Securing Your phpMyAdmin Instance 1. sudo nano /etc/apache2/conf-available/phpmyadmin.conf
<Directory /usr/share/phpmyadmin>
Options SymLinksIfOwnerMatch
DirectoryIndex index.php
AllowOverride All
. . .
2. sudo systemctl restart apache2
3. sudo nano /usr/share/phpmyadmin/.htaccess
AuthType Basic AuthName "Restricted Files" AuthUserFile /etc/phpmyadmin/.htpasswd Require valid-user
4. sudo htpasswd -c /etc/phpmyadmin/.htpasswd username
5. sudo htpasswd /etc/phpmyadmin/.htpasswd additionaluser
6. sudo systemctl restart apache2
https://domain_name_or_IP/phpmyadmin
post a comment