Various utf-8 settings for installing Navicat+mysql under Ubuntu

First, install Navicat: official website

1. Download the installation package

wget https://www.navicat.com.cn/download/direct-download?product=navicat_premium_cs_x64.tar.gz&location=1

2. Decompression

Tar-zxvf/home/wilbur/download/navicat112_premium_cs_x64.tar.gz

3, enter the Navicat directory, using VIM will be start_navicat in the

Export lang= "en_US. UTF-8 "changed to export lang=" ZH_CN. UTF-8 "

4, use./start_navicat execution Navicat

5, crack

When Start_navicat is executed for the first time, a hidden folder named. Navicat is generated under the user's home directory.

cd/home/rain/.navicat/

There is a System.reg file under this folder

RM System.reg

After you delete this file, the next time you start navicat This file will be regenerated, and the 15-day trial will start at the new date.

Ii. MySQL's various utf-8 settings

1. Open the MySQL configuration file

sudo vim/etc/mysql/mysql.conf.d/mysqld.cnf # Ubuntu under

VIM/ETC/MY.CNF # CentOS7

2. Add the following two lines under [mysqld]

Character-set-server=utf8

Collation-server=utf8_general_ci

3. Restart MySQL

/etc/init.d/mysql restart

4. Log in to MySQL

Myql-uroot-p

5. View database Character Set settings

Show variables like ' character_set_% ';

6. View character Set sorting settings

Show variables like ' collation_% ';

That's OK.

Various utf-8 settings for installing Navicat+mysql under Ubuntu