How to change database charset - MySQL

To change the MySQL charset, follow these steps:

1. Access the cPanel:

1. Log in to your cPanel account.

2. Access phpMyAdmin:

1. In cPanel, find the "Databases" section and click on "phpMyAdmin".

3. Select the Database:

1. In phpMyAdmin, on the left panel, click on the name of the database whose charset you want to change.

4. Change the Database Charset:

1. Click on the "Operations" tab.

2. In "Collation", select the desired charset from the dropdown list (e.g., utf8_general_ci for UTF-8).

3. Click on "Go" to apply the change.

5. Change the Table Charset:

1. Return to the left panel and click on the name of each table for which you want to change the charset.

2. Click on the "Operations" tab for each table.

3. In "Table options", select the desired charset from the "Collation" dropdown list.

4. Click on "Go" to apply the change for each table.

6. Change the Column Charset:

1. To change the charset of specific columns, click on the "Structure" tab of the table.

2. Next to the desired column, click on "Change".

3. In the collation field, select the desired charset.

4. Click on "Save" to apply the change.

By following these steps, you can effectively change the charset of your MySQL database through phpMyAdmin.