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

In the installation of MySQL encountered several problems, online search for more or less the same answer, and not a good solution to my problem, after the completion of the record to facilitate later review.

1. Download version 8.0.16 MySQL on the official website

two。 Unzip and put the extracted files under C:\ Program Files\ MySQL

3. Configure the environment variable to add C:\ Program Files\ MySQL\ bin to the system variable path

4. Add a configuration file to create a my.ini under the MySQL root

The contents of the file are as follows. Modify the address of 'basedir=',' datadir='

[mysqld] # set port 3306 port=3306# set mysql installation directory basedir=C:\ Program Files\ MySQL# set the data storage directory of mysql database datadir=C:\ MySQL\ Database# allow maximum number of connections max_connections=200# allow the number of connection failures. 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=3306default-character-set=utf8 used by default when the mysql client connects to the server

Create a Data folder under 5.Program Files\ MySQL

6. View initial password

Mysqld-- initialize-- console (password is the string [Server] A temporary password is generated for root@localhost: Qmax 4

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.