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

Designing a Christmas Website: Creative Ideas & Best Practices

With vibrant colors, cheerful graphics, and a sprinkle of festive magic, your website can instantly create an emotional connection and…

2 days ago

Meet Sora: The Game-Changing AI Video Model from ChatGPT

The world of artificial intelligence is evolving faster than ever — and one of the biggest breakthroughs is here. Sora,…

2 weeks ago

How to Design a Website for Black Friday 2025 (Complete Guide)

Black Friday 2025 is here — the biggest shopping moment of the year, where customers expect unbeatable prices, fast performance,…

3 weeks ago

301 Redirects for WordPress: What, Why & How (SEO Best Practices)

When you move or delete a page on your WordPress website, visitors — and search engines — can easily hit…

4 weeks ago

Meet Perplexity: AI That Thinks Like a Researcher

Introduction Artificial Intelligence has made remarkable strides — from writing poetry to generating code. Yet, most AIs still act like…

1 month ago