Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install mysql 8.0.14 configuration, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The details are as follows

1. download

Find the zip zip file.

two。 Configure environment variables

Configure the decompressed path to the environment variable

3. Installation

Create a new my.ini configuration file in the extracted folder

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ MySQL\ mysql-8.0.14-winx64# set the data storage directory of mysql database datadir=C:\ Program Files\ MySQL\ mysql-8.0.14-winx64\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. The character set used by the max_connect_errors=10# server defaults to the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=UTF8MB4# will use when creating new tables using the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # setting the mysql client default character set default-character-set=UTF8MB4 [client] # setting the default port port=3306default-character-set=UTF8MB4 when the mysql client connects to the server

Note: configure the default character set to use UTF8MB4, otherwise there will be an error. UTF8MB4 a character can have up to 4 bits, because three bits will error, so added 4 bits, this version can not be installed without using mb4.

Run cmd as an administrator

Cd changes directory to mysql bin directory

Running

Mysqld-initialize-console

A password is generated after root @ localhost

Run after

Mysqld-installnet start mysql

Complete the installation.

You will be prompted to reset the password when using a navicat connection.

The above is all the contents of the article "how to install and configure mysql 8.0.14". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.