Windows10 mysql 8.0.12 non-installation version configuration startup method

This article shares the specific steps for configuring and starting the non-installed version of MySQL 8.0.12 for your reference. The specific contents are as follows

1. Official download address

Select: MySQL Community Edition -> MySQL Community Server to enter the final download page, you can see the following:

2. Unzip to a directory, create a new my.ini file under the root file (the content is as follows), and create an empty folder Data

[mysqld]
# Set port 3306 port=3306
# Set the installation directory of mysql to basedir=C:\Softwares\mysql-8.0.12-winx64
# Set the storage directory of mysql database data datadir=C:\Softwares\mysql-8.0.12-winx64\Data
# Maximum number of connections allowed max_connections=200
# The number of connection failures allowed. This is to prevent someone from trying to attack the database system from this host max_connect_errors = 10
# The default character set used by the server is UTF8
character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
# By default, the "mysql_native_password" plug-in is used for authentication. default_authentication_plugin=mysql_native_password
[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[client]
# Set the default port used by the mysql client to connect to the server port = 3306

3. Open CMD as an administrator and enter the unzipped MySQL directory bin folder

mysqld --defaults-file=C:\Softwares\mysql-8.0.12-winx64\my.ini --initialize --console

Remember the root initial password output to the screen

mysqld install MySQL-8.0.12

service.msc Open the service startup management, open the MySQL-8.0.12 service management startup (or configure it to start automatically at boot)

4. Change the initial password

mysql -u root -p initial password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new password';

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:

Causes and solutions for invalid service name when starting MySQL service under Windows 7
Windows cannot start MySQL service and reports error 1067 solution
Solution to MySQL 5.7 not starting under Windows
Using batch processing to start and shut down mysql under Windows
How to install and start MySQL under Windows
Simple solution to the Chinese garbled characters and service startup problems of MySQL in Windows
Detailed graphic tutorial on installation, startup and basic configuration of MySQL under Windows version
Solution to 1067 when Mysql starts in Windows
Solve the problem of PhPStudy MySQL startup failure under Windows system
Universal solution for MySQL failure to start under Windows system

<<: Docker installs redis 5.0.7 and mounts external configuration and data issues

>>: Detailed analysis of classic JavaScript recursion case questions