Mysql8.0.11 winx64 installation and configuration tutorial

Time:2020-10-30

MySQL 8.0.11 winx64 installation tutorial records are as follows, to share with you

1. Import the database installation package, create a new folder (MySQL), and unzip the installation package into the MySQL folder

2. Configure environment variablesLike JDK, go in, select the path editor, add the MySQL directory (note that there is an English semicolon), and then confirm the three.

3. Initialization profile my.ini

[mysqld]
#3307 port settings
port=3307
#Set MySQL installation directory
Basedir = C: \ \ \ MySQL \ \ mysql-8.0.11-winx64 ා remember to use double slashes here. I will make mistakes here, but if you look at other people's tutorials, some of them are single slashes. Try it yourself
#Set the storage directory of MySQL database data
DataDir = C: \ \ MySQL \ \ mysql-8.0.11-winx64 \ \ data
#Maximum number of connections allowed
max_connections=200
#The number of times connection failures are allowed. This is to prevent someone from trying to attack the database system from the host
max_connect_errors=10
#The character set used by the server is utf8 by default
character-set-server=utf8
#The default storage engine that will be used when creating a new table
default-storage-engine=INNODB
#"MySQL" is used by default_ native_ "Password" plug-in authentication
default_authentication_plugin=mysql_native_password
[mysql]
#Setting the default character set of MySQL client
default-character-set=utf8
[client]
#Set the default port used by MySQL client when connecting to the server
port=3307
default-character-set=utf8

Put the file in the MySQL directory

MySQL installation

Enter CMD as administrator (right click)

First CD to MySQL bin directory

Wei When inputting the above command, vcruntime140.ddl will be lost due to system reasons, and then you need to go to the Internet to download a Microsoft runtime. (this step is due to the personal system, not all of them will appear)

Related links:

Solution to the loss of vcruntime140.dll in computer

Unzip the installation, double-click, and then go on to finish.

After the installation is completed, continue to enter the command just now, and the following content appears. Remember the initial password.

5. Start MySQL

6. Testing

installation is complete

Wonderful topic sharing:

Different versions of MySQL installation tutorial

Mysql5.7 installation tutorial

Mysql5.6 installation tutorial

Mysql8.0 installation tutorial

The above is the whole content of this article, I hope to help you in your study, and I hope you can support developeppaer more.

Recommended Today

PHP 12th week function learning record

sha1() effect sha1()Function to evaluate the value of a stringSHA-1Hash. usage sha1(string,raw) case <?php $str = “Hello”; echo sha1($str); ?> result f7ff9e8b7bb2e09b70935a5d785e0cc5d9d0abf0 sha1_file() effect sha1_file()Function calculation fileSHA-1Hash. usage sha1_file(file,raw) case <?php $filename = “test.txt”; $sha1file = sha1_file($filename); echo $sha1file; ?> result aaf4c61ddcc5e8a2dabede0f3b482cd9aea9434d similar_text() effect similar_text()Function to calculate the similarity between two strings. usage similar_text(string1,string2,percent) case […]