[Turn]ubuntu Navicat for MySQL installation and hack solution
First Officer online download Linux version: Https://www.navicat.com.cn/download/navicat-premium
1. Download the navicat112_premium_cs_x64.tar.gz file
2. Unzip the tar file after downloading
Tar-zxvf/home/wilbur/download/navicat112_premium_cs_x64.tar.gz
3. After decompression, enter the extracted directory to run the command:
./start_navicat
OK, that's it.
Connected to the database after the Chinese data is garbled, if it is used in Chinese version, the interface will be garbled, need to modify the character set, modify the method:
1. Open the Start_navicat file and you will see the export lang= "en_US. UTF-8 "To change this sentence to export lang=" ZH_CN. UTF-8 "
2. View the system supported character set: Locale-a
3. Modifying the character set: Export Lang=zh_cn.utf8
Note: Start_navicat file and terminal locale command return information This sentence: Export Lang=zh_cn.utf8 must be consistent
4. You also need to modify the database character set. Vim opens the Mysqld.cnf file under the/etc/mysql/mysql.conf.d path, sudo vim/etc/mysql/mysql.conf.d/mysqld.cnf,
Add the following two lines to the [mysqld] paragraph :
Character-set-server=utf8
Collation-server=utf8_general_ci
Then view the database character set settings:
[Email protected]:~$ mysql-u root-p
Mysql> Show variables like ' character_set_% ';
To view character set sorting settings:
Mysql> Show variables like ' collation_% ';
Return the results and you're done.
Hack Solution:
When Start_navicat is executed for the first time, a hidden folder named. Navicat is generated under the user's home directory.
cd/home/wilbur/.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.
Reprint Address: http://blog.csdn.net/loadrunn/article/details/50886772
Ubuntu Navicat for MySQL installation and hack solution