phpMyAdmin #1071 Specified key was too long
I'm not a db expert and tried uploading a Wordpress site from local to live server. I have phpmyadmin set up on Laragon. The error was in table wp_cli_cookie_scan_cookies. The VARCHAR was set to a high number which I forgot to write down. However I changed all the VARCHARin that table to 100 and that solved the problem. I will be making more sites in Wordpress. Is there a solution to prevent this in the future please|?