Install phpMyAdmin On Ubuntu 20.04

Install Ubuntu 20.04 LTS on Virtual Machine:
• Install Ubuntu 20.04 L...
***************************** Steps and command **********************
1. To install apache2
sudo apt-get install apache2
2. For moving to the root directory type the command :
Sudo su
3. Now to install the lamp server type the command:
apt-get install lamp-server^
4.To install phpmyadmin type the command as :-
apt-get install phpmyadmin -y
5. One dialog box will appear and select the ‘apache2’ by pressing spacebar.
6. Now configuring phpmyadmin dialog box will appear and select ‘yes’ after that give the password in my case it’s ‘admin’ 🡪 This password is of ‘root password’
7. Now, goto the php directory as:-
cd /var/www/html/
8. If you hit the command as:-
ls
you can see the index.html file over that directory.
9. To see the php version you are using create info.php using command as:-
nano info.php
after that type the code as:-
phpinfo();
And press ctrl + o to save and ctrl + x to exit.
10. Now goto the browser and type ‘localhost/info.php’ you will get the php version.
11. Then in browser go to the ‘localhost/phpmyadmin’ you will have to login now so to create user name and password at first go to
sudo mysql -p -u root
12. Create User using command as:-
CREATE USER 'admin'@'%' IDENTIFIED BY 'admin';
It means that the user name is ‘admin’ and password is also ‘admin’
13. Grant Permission using the command as:-
GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;

[@javierrobes7394]

Clear, brief, easy to follow... Perfect tutorial. Thanks a lot!

[@bisheshworkhadka8684]

Its a easy to understand command and clear specification. so this is useful thank you sir

[@thummasinpiyarattanatrai2321]

Very useful, many thanks for step-by-step, I can set it up in one time. Thanks thanks again. God bless you. Cheers!!

[@TrueStandard]

What’s the difference between the Apache web server and the lamp server?

[@TheFatHampster]

Very useful guide. Works on latest unbuntu as of Nov 2022

[@user-wn9tx4hk3s]

Very help! Thank you! The best manual!

[@RamonChiNangWong078]

Nice, it also came with written instruction! fast and easy

[@mehedeehassan5705]

Omg! Thanks, man,! you're very helpful

[@Abdulshafi92]

That was useful, thank you!

[@amirmohammadqaffari9084]

thanks a lot It was very useful and practical

[@ashutoshmishra8118]

It was really healpfull sir,Thank you

[@julienblanc4610]

very helpful! Thank you

[@ninsiimawilber]

Thanks for the tutorial, this saved me. But there is something you skipped in your explanation Enabling phpmyadmin in Apache2 server. sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin sudo service apache2 reload

[@victormwaura3517]

Thanks a lot bro. This was the missing final step in my set up.

[@omnablecreativelabs]

Lifesaver!! I've been trying to install this for days and now it finally works! Thank you!

[@braineaterzombie3981]

Thanks bro. What a lifesaver..

[@javeriana05]

ty man, really useful :D

[@sdkkds2362]

Very helpful video, you made my day

[@SYEDSHEERAZZAIDI]

thanks bro. very helpful

[@amitpawar7548]

Very very helpful bro thanks

[@PraveenMax]

Thanks alot....It worked!

[@BOSBESAR77721]

Wou, thanks for you bro.......⚡⚡⚡

[@tux4059]

Hello I get an error when I set the password : │ mysql said: ERROR 1819 (HY000) at line 1: Your password does not satisfy │ the current policy requirements even though my password is strong, it does it everytime, what should I do ?

[@ABID-ik3mw]

Greate, after long search i found this, Thanks a lot,

[@kelvin4782]

This is the best explanation and assistant with commands below

[@jackinatox9265]

nice tutorial, it was verry helpfull

[@melissaammour5270]

Thank you very much !

[@anthonyheard1395]

Thank you very much sir

[@edwarddavis3870]

Very helpful

[@cinemaexplore1228]

thank you... it very helpfull

[@nikushachavchavadze7425]

Thank you !!!

[@ismailsaleh3536]

Thanks for that tutorial

[@achyutneupane4580]

Nice to see this video

[@roypolinder8158]

legend!

[@mohamedettadrarty7404]

thank you so much you are geniesse

[@abhimanyuanand4173]

Thanks a lot Bro ,

[@Meowflow]

Ty bro!!!!

[@igspm]

Thank very much!!!!!

[@jalil_kartal]

Thank you.

[@antoniodellifiori8817]

Hi man. I sow yr video, but i got a problem: how i finish to set the "info.php" file, and retry to start "localhost/phpmyadmin/" my browser allert me with "404 Not found:The requested URL was not found on this server. Apache/2.4.41 (Ubuntu) Server at localhost Port 80". I've followed all yr steps watching video

[@ninsiimawilber]

I had the same issue, but you need to enable the phpMyadmin module in Apache2 and then restart your apache server Just use the following commands sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf sudo a2enconf phpmyadmin sudo service apache2 reload

[@melvinivandelgadilloarredo3705]

@@ninsiimawilber Thank u, bro!!!

[@PrAsHaNtHdUke1093]

thanks a lot bro..

[@adambrosko9434]

Very useful, but I have one question if I have installed phpmyadmin on server, how can I transfer data to php? I can connect to database remotely but I can't use data from database in php project. Can somebody help me? Thanks

[@achrafaherroq9405]

the same quetion

[@robertmassotti4177]

How do you enter the last character in apt-get install lamp-server^

[@robertmassotti4177]

Found it. The browser does not run any *.php files and only displays the source code. Was there some other configuration missing? Thank you

[@dipenshrestha1105]

@@robertmassotti4177 No any configuration have been missed. Thank you!

[@dushsam]

Thanks alot

[@azaniatutoria]

Your video was very helpful thanks I sub u same time

[@moch.nashehannafii2416]

thanks

[@SharifulIslam-om5rq]

Still show not found

[@michajaron6236]

E: Unable to locate package -y while -- apt-get install phpmyadmin -y

[@MohamedHelmys]

use it without -y: apt-get install phpmyadmin

[@Jeridi]

i add my projet in www/html/ after localhost/myprojet/ but the phpmyadmin not connected with my database

[@oldgames7960]

Thankssssssss

[@SnakZ]

this doesnt work unable to see phpmyadmin

[@SharifulIslam-om5rq]

Can't understand 5:25 to 5:30 minute..Please help

[@gayeisaac4744]

think you

[@aoipalmtravelsagain]

web interface. not show

[@shaneschwalger2482]

i was stuck at the log in stage, I had not created a user. - ty

[@dipenshrestha1105]

you need to create a user at first

[@maddalarajesh1688]

What is the password for ubuntu

[@robertmassotti4177]

This did not work for me.

[@dipenshrestha1105]

what's the error you are getting?

[@asalentstech1767]

@@dipenshrestha1105 phpmyadmin isnt showing login page and i did this correctly

[@manish__g]

when i am try this command it is throwing an error. permision denied

[@roypolinder8158]

thats because you edit your /var/www/html folder, thats by default 'permission denied'. try run the following command in the terminal: sudo chmod 777 /var/www/html/

[@SHADOW6_STRIKE7]

@@roypolinder8158 thanks bro u saved me

[@braineaterzombie3981]

Thanks bro.

[@ReligionAndMaterialismDebunked]

69 comments to 70. (; 69. (;.

[@iAnuragJha]

scripted!

[@pankajkumarbiswas6368]

GRANT ALL PRIVILEGES ON*.* TO 'admin'@'%' WITH GRANT OPTION; update the privilege's code otherwise it will give error, Thanks

[@rhanzel3320]

Latest grant permission: GRANT ALL PRIVILEGES ON *.* TO 'user'@'%';

[@mohamedahmed-vw6ee]

thanks the last command in the comment needs to be updated the below one works for me GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;

[@howawwe3291]

Thank you sir

[@tinnawatmamuang6526]

Thank you.