Personally, I think the decompressed version is easier to install than the installation version. Without further ado, let's take a look at the installation of the decompressed version~ First, go to the MySQL official website to download the latest MySQL 8.0.17 URL: Download the unzipped directory: By default, there is no data directory and my.ini file. Create the my.ini file in the directory above (some tutorials also require creating a data directory. I tried creating a data directory and mysql failed to start) ini file: [mysql] #Set the default character set of MySQL client default-character-set=utf8 [mysqld] #Set port 3306 port=3306 #Set the installation directory of mysql basedir=D:\Program Files\mysql-8.0.17-winx64 #Set the storage directory of mysql database data datadir=D:\Program Files\mysql-8.0.17-winx64\data #Maximum number of connections allowed max_connections=50 #The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8 #Change the default authentication in 8.0 default_authentication_plugin=mysql_native_password #The default storage engine that will be used when creating a new table default-storage-engine=INNODB wait_timeout=31536000 interactive_timeout=31536000 The data directory will be automatically generated Configure MySQL environment variables (this step can be omitted if you open it directly in the MySQL bin directory) The above picture shows the path environment variable Start a command line as an administrator and enter: Then open mysql in the command line: You can change your password after logging in: The latest unzipped version of MySQL has been installed. Tip: Since it is version 8.0.1x, the jar used must also be correct (I used the 8.0.9 jar before and couldn't find the driver, so I changed to 8.0.17) 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:
|
<<: Steps to install RocketMQ instance on Linux
>>: Docker uses nextcloud to build a private Baidu cloud disk
Using CI to build docker images for release has g...
Sometimes the page is very long and needs an arro...
We all know that the underlying data structure of...
I believe everyone has had this feeling: watching ...
I just happened to encounter this small requireme...
Root directory and index file The root directive ...
HTML img produces an ugly blue border after addin...
The first step is to unzip the compressed package...
Page directory structure Note that you need to mo...
This article example shares the specific code of ...
CSS media query has a very convenient aspect rati...
Problem/failure/scenario/requirement The hard dis...
1. Software Download MySQL download and installat...
<!--[if lte IE 6]> <![endif]--> Visibl...
Table of contents 1. js statement Second, js arra...