Category: MySQL


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

Continue Reading

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

Continue Reading

Looking for fresh content?

Access free WordPress resources such as videos, plugins, and other helpful tools and offers.