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:
|
<<: Docker installs redis 5.0.7 and mounts external configuration and data issues
>>: Detailed analysis of classic JavaScript recursion case questions
As a backend programmer, you deal with Linux in m...
environment Linux 3.10.0-693.el7.x86_64 Docker ve...
error message: ERROR 2002 (HY000): Can't conn...
As a front-end monkey, whether it is during an in...
Introduction There is no need to introduce Redis ...
Remote connection to MySQL fails, there may be th...
Background - Online Alert An online server issued...
Achieve results Implementation Code <h1>123...
Preface The method of configuring IP addresses in...
MySQL's CAST() and CONVERT() functions can be...
Table of contents Introduction Uses of closures C...
Assume that a node in the three-node MGR is abnor...
Introduction: Regarding MySQL database specificat...
Nginx cross-domain configuration does not take ef...
This article shares the installation and configur...