Install and use Ubuntu navicat for MySQL

I remember using navicat as the mysql client in windows and remotely connecting to MySQL on the server. in Linux, I checked it, navicat also has a Linux version, so I'm so happy ....

Installation:
1. Official download:

Http://www.navicat.com/en/download/download.html

2. decompress the tar file after the download.
Tar-zxvf navicat8_mysql_en.tar.gz

3. decompress the package and run it in the decompressed directory.

./Start_navicat

You can run it successfully.

However, after connecting to the database, the Chinese data is garbled. After finding the cause, change the Ubuntu character set to zh_cn.utf8. The modification method is as follows:

1. view supported character sets.
Locale-
Result:
Feng @ FENG :~ $ Locale-
C
En_au.utf8
En_b1_utf8
En_ca.utf8
En_dk.utf8
En_gb.utf8
En_hk.utf8
En_ie.utf8
En_in
En_nz.utf8
En_ph.utf8
En_sg.utf8
En_us.utf8
En_za.utf8
En_z1_utf8
POSIX
Zh_cn.utf8
Zh_hk.utf8
Zh_sg.utf8
Zh_tw.utf8

2. Modify Character Set
Export lang = zh_cn.utf8

After modification, you can view the current character set through locale

Ref:

Http://junmail.javaeye.com/blog/247892

Http://wiki.navicat.com/wiki/index.php/How_can_ I _install_Navicat_in_Linux%3F