Categories: cPanel

How to Change the Character Set Issue with WordPress Site’s ?

How to Change the Character Set Issue with WordPress Site’s ?

You should change wordpress character set by using following command.

mysql –database=jargalan_wrdp1 -B -N -e “SHOW TABLES” | awk ‘{print “ALTER TABLE”, $1, “CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;”}’ |
mysql –database=jargalan_wrdp1 &

Here make sure to replace your database name with : username_drpl1

Then restart the mysql service couple of times to make it work !


HR-ADMIN

Recent Posts

How to use Meta Business Suite: 2024 Guide

Meta Business Suite is nothing but formerly Facebook Business Manager designed to help users manage their presence across Facebook and Instagram seamlessly.…

1 day ago

The Ultimate Guide to WordPress Maintenance: Tips and Tricks

When you’re running a business that relies on website traffic and sales to succeed. Then you need to keep it…

2 weeks ago

Migrate In 2024: Our Comprehensive Website Migration Manual to the Next Level

Migration! Yes, this word is very big in the web hosting industry and it has its importance. Especially for businesses…

2 weeks ago

Unveiling the Importance of Server Maintenance Plans: A Comprehensive Guide

The server is the backbone of the web hosting industry and it acts like a HERO in the web hosting…

3 weeks ago

IP Address is Blocked? A handpicked list of Solutions to Fix it?

Imagine you are on holiday having a cup of tea and browsing your website or blog.Then, what next?You will get…

4 weeks ago