I downloaded the latest version of Wampserver v.3.2.6, which by default has phpMyAdmin v.4.9.7 and phpMyAdmin v.5.1.1. It seems that it uses phpMyAdmin v.4.9.7 by default. I want to completely remove phpMyAdmin v.4.9.7 and only use phpMyAdmin v.5.1.1.
I'm using Laravel and when I run php artisan migrate it gives me this error:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
I know how to fix this in Laravel, please don't tell me how to fix it in Laravel.
The oldest version of Wampserver v.3.2.3 has no problem as it does not have phpMyAdmin v.4.9.7.
I think this is because of phpMyAdmin v.4.9.7. If you know any solution please help.
After some digging, I found this problem. I have 2 Wamp Server folders on my system. There is one in each drive. Obviously, I installed from wampserver using the exe file and installed it in my C: (Windows). I did not notice. It doesn't allow me to override what I really want to update. It comes with
PhpMyAdmin 4.9.7 and 5.1.1
.if you are willing to
You must use phpMyAdmin v.4.9.7 to find the Wamp Server folder. Before deleting it, make sure your alias folder contains the version information you want to keep:
phpmyadmin.conf
and dump the version information you want to delete. Mine isphpmyadmin4.9.7
. After deletion,right click on
Wamp Server icon &restart from scratch
. Then you wouldPhpMyAdmin 5.1.1
(in my case).