How to set ut8mb4 for mysql via phpMyAdmin?

0

Please refer to the following steps to change MySQL server collation via phpMyAdmin

Login to your cPanel account.
Click on the phpMyAdmin inside the database section.
From the drop-down, select the required ut8mb4 Unicode. It will be auto-saved.

This is it. You are done with changing MySQL server collation.

Get Linux VPS Hosting

Was this answer helpful?

Related Articles

Fix - PHPMyAdmin Error You should upgrade to MySQL 5.5.0 or later Problem statement Recently we upgraded phpMyAdmin version from 4.0.10.12 to 4.5.3.1 in our... How to edit the my.cnf file of MySQL in Linux VPS? VPS Hosting and Dedicated server customers can edit MySQL configuration settings by modifying... How to enable the slow query log in MySQL? Slow MySQL queries can significantly lower down the performance of your web application and eat... How to fix InnoDB database corruption error? Check the log files. If you find InnoDB database corruption, follow the below mentioned steps:... How to Administrate MySQL Server with mysqladmin commands? By using mysqladmin commands, you can perform basic MySQL tasks very easily, such as...