MySQL-8.0.11 and Navicat Premium installation Tutorials

1. Download MySQL

• : https:////dev.mysql.com/downloads/mysql/
• Baidu Cloud Link: Https://pan.baidu.com/s/1bxAtnvChZZVZa39PZGZrpA password: xrr8

2. Install MySQL2.1 unzip the installation package to the installation path 2.2 Create the MySQL initialization file under the installation path root directory My.ini

[MySQL] #设置mysql客户端默认字符集 ' default-character-set== 3306 # Set the installation directory for MySQL basedir=d:/mysql-8.0.11-winx64# Set the data storage directory for the MySQL database datadir=d:/mysql-8.0.11-winx64/data# allow the maximum number of connections max_connections=2000# to allow the number of failed connections. This is to prevent someone from attempting to attack the database system from the host max_connect_errors=100# Server uses a character set that defaults to a 8-bit encoded latin1 character set character-set-server=  utf8# The default storage engine that will be used when creating a new table default-storage-engine=innodb[client]# set the port that is used when the MySQL client connects to the service port port =3306Default-character-set=utf8

2.3 Open the CMD command-line tool as an administrator

• The specific operation is win + Q search cmd , right click to execute as an administrator, do not use the PowerShell administrator as the role of execution

2.4 Switch to the installed Bin directory

• For example cd D:\mysql-8.0.11-winx64\bin :
• If you add the above path to the environment variable path, you can execute the following script in any directory

2.5 Initialize the database and get the initial password

• Execute the command under the installation directory/bin:mysqld --initialize --console
• When execution is complete, the root user's initial default password is printed, such as:

d:\mysql-8.0.11-winx64\bin>mysqld--initialize-- console2018-07-18t14:48:26.396790z 0 [System] [MY-013169] [Server] D:\mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing Of server >in progress as Process 152162018-07-18t14:48:38.445099z 5 [Note] [MY-010454] [Server] A temporary >password is generated for [email protected]: 3s6rmdg,kawt2018-07-18t14:48:45.351367z 0 [System] [MY-013170] [Server] D:\ Mysql-8.0.11-winx64\bin\mysqld.exe (mysqld 8.0.11) initializing Of server has completed
            

• Attention! There is a paragraph in the execution output: [Note] [MY-010454] [Server] A temporary >password is generated for [email protected]: 3s6RMDg,kawT [email protected]: The following 3s6RMDg,kawT is the initial password (excluding the first space).

• Need to remember this password, 步骤2.7 need to use.

• If you do not remember to delete the initialized DataDir directory, execute the initialization command again.

2.5 Installing the MySQL service

mysqld --install [服务名]

• Extended SC Delete [service name] is a command to delete a service
• The installation succeeds as follows:

D:\mysql-8.0.11-winx64\bin>mysqld --install MySQLService successfully installed.

• After the service name can not be written, the default name is MySQL.
• If you need to install more than one MySQL service on your computer, you can distinguish it by different names MySQL8 , such as

2.6 Starting the MySQL service

• Wait a few seconds after installing the service
• Execution net start [服务名]
• Extension: net stop [服务名] is the command to stop the service
• Startup success is as follows

D:\mysql-8.0.11-winx64\bin>net start mysqlMySQL 服务正在启动 ..MySQL 服务已经启动成功。

2.7 Change Password

• Execution mysql -u root -p
• This time will prompt for password, fill in 步骤2.5 The record password can log in successfully, into the MySQL command mode.
• Execution in MySQL command mode
• ALTER USER ‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘新密码‘;
• Change the password, pay attention to the end of the command; must have, this is MySQL syntax
• The following changes are prompted after the success

‘root‘@‘localhost‘ IDENTIFIED WITH mysql_native_password BY ‘root‘;Query OK, 0 rows affected (0.10 sec)

3. Install navicat Premium3.1 Download

• Baidu Cloud Link: Https://pan.baidu.com/s/1vlY7ngHHjiK6hPiv95wMOA password: w09r

3.2 Installation

• Install the appropriate version according to the operating system
• Do not open after installation

3.3 Hack

• Run as AdministratorPatchNavicat.exe
• Cracked successfully opened and ready to use

MySQL-8.0.11 and Navicat Premium installation Tutorials