How to change the charset of MySQL server

How to change the charset of MySQL server

To change the MySQL charset, follow the steps below:
  

1. Access the phpMyAdmin option in the Database section of your cPanel


2. Check the current server charset 

3. Go to Settings, select Features and then Database tab, change the server charset
  in Server connection collation and click Apply

    • Related Articles

    • How to change the password of a email account

      If you want to change password of your email account then you can do this by the following steps: 1. Log into your cPanel account.  2. In the "Mail" section click on "Email Account" Icon.  3. Scroll down to the "Email Accounts" section and you should ...

    • How to change the DNS to Scriptcase Host

      To access a site by the address, example: scriptcase.host, this address must respond to a IP of the server that your account is hosted, for this purpose DNS servers are used. If you acquire or want to use a domain that you already own, you must ...

    • How to use the emails of hosting account with a external SMTP server

      You can use an extern SMTP service like G suite to relay emails. 1. Log into your cPanel account.2. In the "Domains" section, click on "Zone Editor" Icon.  3. In the domains list, select the domain appropriate domain and click in "MX Record" 4. In ...

    • Creating a MySQL Database

      The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "DATABASES" ...

    • How to change language of your cPanel

      CPanel supports a lot of languages, and if you want to change your cPanel language to your native language, you should follow this tutorial. 1. Log into your cPanel account. 2. In the "Preferences" section, click on "Change Language" Icon.  3. From ...