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

This article records the mysql 8.0.18 installation and configuration tutorials for your reference, the specific contents are as follows

Step 1: download MySql

Download address: MySQL

Step 2: install MySql

Open the download file and extract it to the specified file directory.

(the directory I extracted here is G:\ MySQL\ mysql-8.0.18-winx64)

Open the extracted MySql file and create a my.ini (mysql configuration file) in the root directory

The my.ini file is as follows:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=G:\ MySQL\ mysql-8.0.18-winx64# set mysql database data storage directory datadir=G:\ MySQL\ mysql-8.0.18-winx64# maximum number of connections allowed max_connections=200 # the character set used by the server defaults to 8-bit encoding Latin1 character set character-set-server=utf8 # default storage engine default-storage-engine=INNODB to use when creating new tables

Here, you need to change the paths of basedir and datadir to the decompression path of mysql.

Locate the CMD command prompt and right-click to run as an administrator

Enter the MySQL subdirectory bin and type

Mysqld-install (installation)

Mysqld-initialize (initialization)

Net start mysql (running)

Step 3: set the MySql login password

After the mysql installation is completed, open the data folder in the mysql installation directory. There is a .err file inside. Open it with Notepad++, and you can see that there are lines inside.

A temporary password is generated for root@localhost: xxxxxxxx

Localhost: this is the default password. You can log in by copying this password.

The password must be reset after a successful login, otherwise the following line of error will be prompted all the time.

You must reset your password using ALTER USER statement before executing this statement.

Enter the following command after starting mysql, and NEW PASSWORD sets the password for itself

Mysql > ALTER USER USER () IDENTIFIED BY 'NEW PASSWORD'

The installation is complete.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

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.