How to view the encoding format selected during mysql database installation _ MySQL

How to view the encoding format bitsCN.com selected during mysql database installation

Enter the following in dos mode:

1. cd C:/Program Files/MySQL Server 5.5/bin

2. mysql-h127.0.0.1(The address of the host you want to access)-uRoot(User name)-pRoot(Password)

3. show variables like 'character % ';

You can view the mysql encoding format.

This completes viewing the encoding format in your mysql. if you want to modify the encoding format, continue with the following steps:

Open the mysql installation directory, which contains a my. ini file. open this file, which contains two character set settings. the default setting is Latin. we recommend that you change it, such as utf8 or gbk.

Then start the mysql service. the default character set of the database created later is OK.

(Enable Service Control of MySQLAdministrator during restart .)

BitsCN.com