Mysql+navicat Installation Summary

1,mysql to the official download, navicat download cracked version

2, modify the My.ini,

Note that the Data folder needs to be created manually, where C:\MySql\mysql-5.7.17-winx64 is the directory where the MySQL is unzipped [mysql]# setting the MySQL client default character set  -character-set== 3306 # Set up the installation directory for MYSQL basedir=c:\mysql\mysql-5.7.17-winx64# Set data storage directory for MYSQL database datadir=c:\mysql\mysql-5.7.17-winx64\data# allow maximum number of connections max_connections=200# The character set used by the service side defaults to the 8-bit encoded latin1 character set character-set-server=utf8# The default storage engine that will be used when creating a new table - storage-engine=innodb#sql-modesql_mode

3, run as Administrator cmd.exe

1.switch the directory to the bin file directory in your unzip file, CD C:\MySql\mysql-5.7.17-winx64\bin Enter 2, and then enter mysqld install ENTER. 3, then input mysqld--initialize-insecure--user=mysql enter 4, then enter net start MySQL start service 5, enter Mysql-uroot- p, the default is no password, direct enter into the (alarm enter password when hit Enter)6, if you want to set a password    , first exit SQL-uroot-p password Password 7, configure environment variables-- > Computer Right Button "Properties"-"Advanced system Settings"-"Environment variables"-"path"--Copy the path of the bin directory under the PATH environment variable

4, install Navicat

 for  for MySQL),    do not open the for MySQL directory at the end of the Navicat.exe to crack, OK 

5, Operation MySQL via Navicat

1, open navicat link name (random, self-fetch such as localhost)2, new database: Right-click the connection name, there are new database options    such as:            database name: MyBatis--UTF-8 Unicode            Collation: Utf8_general_ci3, run SQL file: Select database, mail--"have run SQL File Option 4, (refresh invalid, do not know why) if there is no data after running, Launch Navicat and re-enter on the OK. 5, how to execute SQL: Click Query--* * from ' user '; night can be executed again, do not know whether to write wrong did not notice. do not write a semicolon can also , this point to note that two sqlselect last_insert_id () Select UUID ()

Mysql+navicat Installation Summary