Unable to login to phpMyAdmin in XAMPP: Access denied for user 'root'@'localhost' (using password: NO)

 

Unable to login to XAMPP's phpMyAdmin page : Error #1045 - Access denied for user 'root'@'localhost' (using password: NO).
In this post we shall see how to set root password for phpMyAdmin to resolve the access denied error while accessing phpMyAdmin. This may usually happen if XAMPP is reinstalled on the same computer.

Read more »

Issue importing WordPress database from development to live server: 1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

So I was trying to import a MySQL database exported from local development machine to a live server and I got the error thrown by phpMyAdmin:

#1273 - Unknown collation: 'utf8mb4_unicode_520_ci'

On some systems, the error could be: Unknown collation: 'utf8mb4_unicode_ci'

Read more »