[Tutorial] How to add phpMyAdmin
@leokhoa 2 questions:
- how can I configure this to autologin?
- For some reason, the databases I imported from Xampp arent showing up in phpMyAdmin, even though they appear fine in HeidiSQL. What am i doing wrong?
The installed version of phpMyAdmin is 4.8.2. There is a notification at the bottom which says:
A newer version of phpMyAdmin is available and you should consider upgrading. The newest version is 4.8.5, released on 2019-01-26.
Please assist in upgrading.
@KoolPal : Upgrading is easy.
- Click Menu > Tools > Quick add > phpMyAdmin
Thanks I tried that but it is downloading 4.8.2 version NOT 4.8.5
@KoolPal : You need to update the link in Menu > Tools > Quick add > Configuration to 4.8.5 version:
Oh. Needed a bit of searching on Laragon 4.0.14
It's in Menu > Tools > Quick Add > Configuration
@KoolPal : You're right. I've updated the link.
@leokhoa Now it asks me for user name and password. How do I get it from the older folder?
@KoolPal escribes root y dejas la contraseña en blanco
Using https, I was still getting: "Login without a password is forbidden by configuration (see AllowNoPassword)"
Fixed it by stopping services, Menu>Mysql>change root password, then I had to go add that password in my config files as well.
Nice one man.
I have an error message when I'm trying to login into phpMyAdmin.
What I supposed to do to fix it?
@fredalbert37 I put the same password in heidiSQL and then I log in.
But this didn't happend with phpMyAdmin. I don't know why
I just made a copy of config.sample.inc.php found in the newly extracted phpMyAdmin folder and called it config.inc.php. In that new file I changed the following line from false to true:
$cfg['Servers'][$i]['AllowNoPassword'] = false;
Now I can login without a password (better than having to go back into all my .env files and change the password to something just to be able to use phpMyAdmin)
@leokhoa Thank you very much for the information
If you are adding phpMyAdmin for the first time, please rename 'config.sample.inc.php' to config.inc.php and make
$cfg['Servers'][$i]['AllowNoPassword'] = TRUE;
@yrnprogrammer same problem, how to solve?
@druspandi I ended up using the quick tools to install PHPMyAdmin and then I had to stop service (I did it from the GUI that comes up when I turn on my computer) then go to Menu>MySql>change root password.
laragon is the best and easiest tools ever, by adding phpmyadmin or even adding sublime for code editor (if possible adding vscode too, hahahha....)
for me, the one that just learn programming, laragon is the best
@yrnprogrammer try making sure the folder name is just "phpMyAdmin" not "phpMyAdmin-5.0.2-english" or whatever it extracts too.
After updating PHP to v7.4.8 I got a bunch of deprecation notices when installing phpMyAdmin via Laragon "Tools -> Quick Add" and visiting localhost/phpmyadmin . Apparently that version of PHP is "too new" compared to phpMyAdmin 4.8.5 currently referenced by Laragon config. Manually adding phpMyAdmin 5.0.2 (as discussed in this thread) seems to have fixed it for me.
@leokhoa would you please consider changing Laragon default configuration file to pull the latest stable version of phpMyAdmin from https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-english.zip ?