Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Installation and configuration tutorial for mysql8.0.20

2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

MySQL 8.0.20 installation tutorial

One: download the official website of mysql

Https://dev.mysql.com/downloads/file/?id=494993

No need to register, just download it.

Two: decompress

Forgive my technical scum, all the folders have been flipped through, really did not find the mysql-installer in which folder, really do not know which file should be run (there are great gods know welcome guidance)

The directory extracted by ok does not have a my.ini file, so configure it yourself. Create the my.ini added under the installation root directory and write to the basic configuration:

[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:\ Program Files\ MySQL\ Data# allow the maximum number of connections max_connections=200# allows the number of connections to fail. The character set used by the max_connect_errors=10# server defaults to the default storage engine default-storage-engine=INNODB# that utf8mb4character-set-server=utf8mb4# will use when creating new tables using the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # setting the mysql client default character set default-character-set=utf8mb4 [client] # setting the default port port=3306default-character-set=utf8mb4 when the mysql client connects to the server

Please note that the path is the same, it will not change, just like me.

Three: initialize mysql and run cmd as administrator

Go to the mysql folder bin directory

And run the instruction mysqld-initialize-console

This is the initial password, be sure to write it down, it will be used later!

If an error is reported in this step, some of the libraries needed for Microsoft to run are missing. Add them by Baidu yourself.

IV: install and start mysql services

Install mysql service execution

Mysqld-- install [Service name] Service name can be left unadded. Default is mysql.

Very good, successful, after the service is installed successfully, use the command

Net start mysql

Start the mysql service

Mysql has been installed

Five: digression

The password I just asked everyone to remember, uh-huh, yeah, that's it! If you forget, there may be a little trouble, the Internet is everywhere, Baidu mysql forgot the password.

The password is changed under the bin directory of mysql to connect to the database mysql-u root-p

The display is normal, then enter the instruction

ALTER USER 'root'@'localhost' IDENTIFIED BY' New password

The above are mysql 8.0.20 installation tutorials and notes, please pay attention to other related articles!

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report