Modify the mysql character set in Ubuntu

/Etc/init. d/mysql start (stop) is used to start and stop the server.
/Etc/mysql/main configuration file location my. cnf
/Var/lib/mysql/stores the database table folder. Here, mysql is equivalent to the date folder of mysql in windows.

After mysql is started, log on to mysql as the root user
Isher @ isher-ubuntu :~ $ Mysql-u root
> Show variables like 'character % '; # display the code
+ -------------------------- + ---------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------- +
| Character_set_client | latin1 |
| Character_set_connection | latin1 |
| Character_set_database | latin1 |
| Character_set_filesystem | binary |
| Character_set_results | latin1 |
| Character_set_server | latin1 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +

In some cases, we need to modify the encoding of the default mysql database to ensure that some migrated programs can be properly displayed. edit my. modify the cnf file encoding. For windows, you can directly use Mysql Server Instance Config Wizard to set

Modify one of the three my. cnf files in linux:/etc/mysql/my. cnf

Find the client configuration [client] and add it below
Default-character-set = utf8 default character set: utf8
Add in [mysqld]
Default-character-set = utf8 default character set: utf8
Init_connect = 'set NAMES utf8' (utf8 encoding is used to SET the connection to the mysql database to run utf8)

After modification, restart mysql and query show variables like 'character % ';
+ -------------------------- + ---------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------- +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +

This method is also valid for the standard mysql version, for the/etc/my. cnf file, you need to copy from the mysql/support-files Folder cp my-large.cnf to/etc/my. cnf

Note: When modifying the mysql configuration file mycnf, because the file attribute of this file is a read-only file, you must first modify the file attribute. first, log on to the terminal as the root user and enter the command: chmod a + w my. cnf. after modification, you need to re-Modify the attributes of the file, because mysql requires the file to be read-only during loading.