Shulou(Shulou.com)06/01 Report--

This article shares the specific steps of mysql 8.0.12 non-installation configuration startup for your reference. The details are as follows.

1. Official download address

Select: MySQL Community Edition-> MySQL Community Server to enter the final download page, and you can see the following below:

two。 Extract to a directory, create a new my.ini under the root file (the contents are as follows), and create a new empty folder Data

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Softwares\ mysql-8.0.12-winx64# set the data storage directory of mysql database datadir=C:\ Softwares\ mysql-8.0.12-winx64\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB# that UTF8character-set-server=utf8# will use when creating a new table uses the "mysql_native_password" plug-in authentication default_authentication_plugin=mysql_native_ password [MySQL] # to set the mysql client default character set default-character-set=utf8 [client] # setting. Set the port port=3306 used by default when the mysql client connects to the server

3. Open CMD as an administrator and go to the extracted MySQL directory bin folder

Mysqld-defaults-file=C:\ Softwares\ mysql-8.0.12-winx64\ my.ini-initialize-console

Remember the initial root password output to the screen

Mysqld install MySQL-8.0.12

Service.msc opens service startup management, opens MySQL-8.0.12 service management startup (or can be configured to boot automatically)

4. Change the initial password

Mysql-u root-p initial password ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' new password

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.