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

This article shares the mysql 8.0.13 installation configuration tutorial for your reference, the specific contents are as follows

First go to the official website to download the MySQL download.

Unzip after download

After decompression, it looks like this

Configure system environment variables

Copy the decompressed mysql to disk C or other disk

We add a mysql configuration to the path of the system environment variable, pointing to the mysql bin directory.

Configure initialized my.ini file files

The decompressed directory does not have a my.ini file. It does not matter that you can create my.ini added under the installation root directory (create a new text file, change the file type to.ini) and write the basic configuration:

[mysqld]#Set port 3306 port=3306#Set mysql installation directory basedir=C:\Program Files\MySQL#Set mysql database data storage directory datadir=C:\Program Files\MySQL\Data#Max connections allowed max_connections=200#Number of connections allowed to fail. max_connect_errors=10#Character set used by server defaults to UTF8character-set-server=utf8#Default storage engine used when creating new tables default-storage-engine=INNODB#Default uses "mysql_native_password" plug-in authentication #mysql_native_passworddefault_authentication_plugin=mysql_native_password[mysql]#Set mysql client default character set default-character-set=utf8[client]#Set mysql client default port used when connecting to server port= character 3306default-character-set=utf8

Install MySQL

During installation, try to run CMD as an administrator, otherwise an error will be reported during installation, which will lead to installation failure.

Enter CMD directly into the mysql directory

Execute the command under the bin directory of MySQL installation directory:

mysqld --initialize --console

Attention! [Note] [MY-010454] [Server] generates temporary password for root @ localhost: 9P0gYk-? 0, kT where root @ localhost: followed by 9P0gYk-? 0, kT is the initial password (without the first space). Before you change your password, you need to remember this password. You need to use it for subsequent logins. Save the copy password first!!!

installation services

Go to C: \ Windows \ System32 directory and find cmd.exe right-click to run as administrator (be sure to do so!)

CD entry MySQL warehouse directory

Execute the command:

mysqld --install [service name](service name can be omitted by default mysql)

It worked!

If this happens,

It means MySQL's service is still deleting it.

with this command

SC Deleted MySQL

Install services above execution

After the service installation is successful, start MySQL service by command net start mysql

Okay, you can close the CMD window! We don't need it.

I believe everyone has Navicat, Dolphin and other database graphical tools

I also share a free Navicat Premium 12, link address: https://pan.baidu.com/s/1n1q53hzNKd1OhIcdIDl2jg extraction code: cdk2, and share the official address

Our MySQL service has been turned on, so open Navicat directly to connect

New MySQL connection

Remember the initial password after root @ localhost: I just asked you to copy? Now we're going to use it. Copy and paste!

Test it!

MySQL is successfully installed can also log in, now is the time to change the password, write SQL to change the password?

Too much trouble. Too low.

Here's an easy way to do that. Navicat clicks on the link and prompts us for a new password.

OK, the tutorial ends here.

Excellent topic sharing:

mysql different versions installation tutorial

mysql5.7 installation tutorial

mysql5.6 installation tutorial

mysql8.0 installation tutorial

The above is all the content of this article, I hope to help everyone's study, but also hope that everyone a lot of support.

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.