How To Fix PHPMyAdmin MySql Error -
Fixing MySQL Error #1273 – Unknown collation: utf8mb4_unicode_520_ci’ in PHPMyAdmin.
When you see MySQL Error #1273 "Unknown Connection: utf8mb4_unicode_520_ci" in phpMyAdmin, it can be frustrating. In the following sections of this tutorial, we will try with few solutions that are available to fix the problem. There are a number of alternatives to fix this problem by altering the MySQL server configurations and even modifying the compilation settings for your database tables. The error code 1273 indicates that your database is using a collation that the MySQL server cannot recognize. This situation can occur if you try to use a database that was created for the latest and more advanced version of MySQL with an older version of the MySQL server. This problem can be resolved by replacing incorrect collations from utf8mb4_unicode_ci to utf8_general_ci.
I believe this error is caused because the local server and live server are running different versions of MySQL. To solve this:
Follow the below steps to resolve this :
1. Open the SQL file in your text editor Like Edit Notepad ++, You can download it from the below link :
https://notepad-plus-plus.org/downloa...
2. Find and replace all utf8mb4_unicode_520_ci with utf8mb4_unicode_ci
3 Remove all the previous tables you uploaded before
4 Now upload the database file you saved after making the changes.
5 Bingo! Now data is uploaded completely without any error
● Leave A comment if you face any issue with your website or any technical issue. We will be glad to help you.
● Stay Connected With Us by Subscribing to our channel & don't forget to ring the bell icon for regular updates.
● Like and Share our videos so that others will also get help from our videos.
Thanks For Watching Please Like Subscribe and Comment.
#phpmyadminerror #mysqlerror #unicodeerrorphpmyadmin #fixphpmyadminerror #error1273unknowncollation #mysqlphpmyadmin #mysqlerror #phpmyadmin #databasefix #errorresolution #collationissue #databasetroubleshooting #mysqlfix #databasemanagement #phpmyadmintips #errorhandling #mysqlerror #phpmyadminerror #databaseerror #collationerror #utf8error #databasetroubleshooting #databasemanagement #mysqlfix #phpmyadminfix #errorresolution #databaseissues #databaseerrors #mysqlproblems #phpmyadminproblems #databasesupport #errorhandling #technicalsupport #mysqlhelp #phpmyadminhelp #databasemaintenance