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!

[@TheFatHampster]

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

[@kelvin4782]

This is the best explanation and assistant with commands below

[@bisheshworkhadka8684]

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

[@connecthubthailand]

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

[@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..

[@TrueStandard]

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

[@ABID-ik3mw]

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

[@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!!!

[@ClutchVault]

@@ninsiimawilber worked like a charm. thanks!

[@МаксимДудников-х2е]

Very help! Thank you! The best manual!

[@Jeridi]

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

[@RamonChiNangWong078]

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

[@BOSBESAR77721]

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

[@mehedeehassan5705]

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

[@michajaron6236]

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

[@MohamedHelmys]

use it without -y: apt-get install phpmyadmin

[@javeriana05]

ty man, really useful :D

[@SharifulIslam-om5rq]

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

[@PraveenMax]

Thanks alot....It worked!

[@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 ?

[@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

[@aherroqachraf]

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!

[@anthonyheard1395]

Thank you very much sir

[@ashutoshmishra8118]

It was really healpfull sir,Thank you

[@cinemaexplore1228]

thank you... it very helpfull

[@SnakZ]

this doesnt work unable to see phpmyadmin

[@amirmohammadqaffari9084]

thanks a lot
It was very useful and practical

[@ismailsaleh3536]

Thanks for that tutorial

[@amitpawar7548]

Very very helpful bro thanks

[@sdkkds2362]

Very helpful video, you made my day

[@SYEDSHEERAZZAIDI]

thanks bro. very helpful

[@julienblanc4610]

very helpful! Thank you

[@edwarddavis3870]

Very helpful

[@abhimanyuanand4173]

Thanks a lot Bro ,

[@igspm]

Thank very much!!!!!

[@aoipalmtravelsagain]

web interface. not show

[@melissaammour5270]

Thank you very much !

[@SharifulIslam-om5rq]

Still show not found

[@jackinatox9265]

nice tutorial, it was verry helpfull

[@howawwe3291]

Thank you sir

[@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

[@mohamedettadrarty7404]

thank you so much you are geniesse

[@roypolinder8158]

legend!

[@PrAsHaNtHdUke1093]

thanks a lot bro..

[@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.

[@jalil_kartal]

Thank you.

[@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

[@oldgames7960]

Thankssssssss

[@achyutneupane4580]

Nice to see this video

[@azaniatutoria]

Your video was very helpful thanks I sub u same time

[@gayeisaac4744]

think you

[@moch.nashehannafii2416]

thanks

[@iAnuragJha]

scripted!

[@ReligionAndMaterialismDebunked]

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

[@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;

[@Meowflow]

Ty bro!!!!

[@nikushachavchavadze7425]

Thank you !!!

[@dussamcode]

Thanks alot

[@tinnawatmamuang6526]

Thank you.