Windows10 mysql 8.0.12 non-installation version configuration startup method

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

Recommend

Summary of 6 Linux log viewing methods

As a backend programmer, you deal with Linux in m...

Detailed steps for setting up host Nginx + Docker WordPress Mysql

environment Linux 3.10.0-693.el7.x86_64 Docker ve...

How to install and configure Redis in CentOS7

Introduction There is no need to introduce Redis ...

Solution to Navicat Premier remote connection to MySQL error 10038

Remote connection to MySQL fails, there may be th...

Loading animation implemented with CSS3

Achieve results Implementation Code <h1>123...

Complete steps to configure IP address in Ubuntu 18.04 LTS

Preface The method of configuring IP addresses in...

Detailed explanation of the principle and function of JavaScript closure

Table of contents Introduction Uses of closures C...

MySQL 8.0.18 uses clone plugin to rebuild MGR implementation

Assume that a node in the three-node MGR is abnor...

Summary of MySQL database usage specifications

Introduction: Regarding MySQL database specificat...

Example of how to configure cross-domain failure repair in nginx

Nginx cross-domain configuration does not take ef...