Category: MySQL

utf8mb4_unicode_520_ci

How to fix #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL query error

Hello Friends, Today we will learn how to resolve MySQL error in WordPress #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’. Actually, this is a very big problem we are facing when we are importing WordPress Database from one host to another host in PHPMyAdmin or even sometimes the same server.   So guys, below steps will help us how to fix this #1273 – Unknow collation: ‘utf8mb4_unicode_520_ci’ MySQL issue. STEP 1: Download your Database file in [.sql] format. STEP 2: Open your Database file either in Macromedia Dreamweaver or in Notepad++ software and give Search & Replace command ctrl+F STEP 3: After that put “utf8mb4” on search and

Read More »

How to add an Administrator from WordPress MySQL Database

Hello guys today we will learn how to add an Administrator from WordPress MySQL Database in this tutorial article. Actually yesterday my best friend told me that his WordPress website was hacked and her account has been deleted. He asked me what’s the solution how to add new Administrator without accessing WordPress dashboard. So, I gave her satisfying solution that you can add administrator from MySQL. NOTE: Before we start doing this, make sure that you have taken backup of your website Database. Add an Administrator from WordPress MySQL Database Below are the two ways to perform this task, not

Read More »