Create wp user via mysql or phpmyadmin
Create wp user via mysql or phpmyadmin Sometimes you need to create additional wp users for your developers or co-authoers,...
Category: MySQL
SQL Server Error User Group or Role Already Exists in the Current Database
The issue mainly occurred due to user privilege exist on the associated DB. So we need to remove this and...
How to take Full Databases backup using script
How to take Full Databases backup using script Hello This is a simple script to take DB backups. Step1. Login...
[Solved] Unknown collation “utf8mb4_unicode_ci”
Oh my god it’s some time very pain while restoring the DB. It shows the collation mismatch ERROR 1273 (HY000)...
Myism vs InnoDB
Myism vs InnoDB Here we are going to the see the difference between myism and innodb storage engines. MYISAM: 1....
ERROR 1273 (HY000) at line 193: Unknown collation: ‘utf8_general_ci’
ERROR 1273 (HY000) at line 193: Unknown collation: ‘utf8_general_ci’ Oh my god it’s some time very pain while restoring the...
How to change wordpress password using MySQL / PHPMyAdmin
How to change WordPress password using MySQL / PHPMyAdmin Imagine someone somehow manages to break into your WordPress dashboard, and...
How to change the definer for views
Hi Guys, In this article I am gonna tell you how to change the definer for Views. This commonly occurs...