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

Will AI Replace Developers in the Future?

Artificial intelligence is changing the tech world at lightning speed. From automated chatbots to AI-generated applications, many people are now…

2 days ago

What is Bot Traffic? Easy Ways to Detect and Block It

Introduction to Bot Traffic Bot traffic refers to visits to a website that come from automated software programs rather than…

2 weeks ago

100+ Essential Windows Commands You Can’t Ignore

Windows may look like a point-and-click operating system, but under the hood, commands still do a lot of the heavy…

3 weeks ago

YouTube Shorts for Beginners: Step-by-Step Guide (2026)

YouTube Shorts are short-form vertical videos designed for quick consumption, typically lasting up to 60 seconds. In 2026, they’ve become…

3 weeks ago

YouTube SEO Secrets That Actually Work in 2026

YouTube SEO Secrets That Actually Work in 2026 YouTube SEO 2026 YouTube SEO Secrets That Actually Work in 2026 If…

4 weeks ago