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 »

Add Administrator User in WordPress Using MySQL

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

Read More »