Install the decompression version of Mysql on Windows10
mysql win10 decompression
Download and unzip
Mysql: Version 5.7.13 download link (you can download directly through the official website zip link, no need to register for an Oracle account)
Unzip mysql-5.7.13-winx64.zip to any directory, I unzip it to " D:/Program Files/mysql/mysql-5.7.13-winx64"
Configure system variables
Add a "D:\Program Files\mysql\mysql-5.7.13-winx64\bin
" in the system variable PATH.
Modify the default configuration file
There is a configuration file my-default.ini in the directory "mysql-5.7.13-winx64", copy a copy as my.ini.
Modify basedir and datadir in my.ini
basedir = "D:/Program Files/mysql/mysql-5.7.13-winx64" # This directory will be initialized after executing the mysqld --initialize command datadir = "D:/Program Files/mysql/mysql-5.7.13-winx64/data" # server_id must also be set, otherwise an error will be reported [ERROR] You have enabled the binary log, but you haven't provided the mandatory server-id.Please refer to the proper server start-up parameters documentation # 2016-07-18T15:29:23.097024Z 0 [ERROR] Aborting server_id = 1
Install
Execute mysqld --initialize --console in the mysql-5.7.13-winx64\bin directory, it must be the bin directory, and it must have --console.You can see the generated password in the last line, but you can't see the password Can you not log in anymore?
PS D:\Program Files\mysql\mysql-5.7.13-winx64\bin> mysqld --initialize --console 2016-07-18T15:56:17.820761Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.Please use --explicit_defau lts_for_timestamp server option (see documentation for more details). ... ... ... 2016-07-18T15:56:18.449148Z 1 [Note] A temporary password is generated for root@localhost: :esIkHCaG2,d
This command will initially generate many files in the datadir directory set by my.ini.As shown in the picture
Startup
Then install mysql mysqld install
to uninstall mysql when reinstalling mysql, command mysqld remove
Then start mysql
PS D:\Program Files\mysql\mysql-5.7.13-winx64\bin> net start mysql The MySQL service is starting. The MySQL service has been started successfully.
Run the command bin\mysql_secure_installation.exe
for security settings, such as resetting the password and whether to allow remote access.
After starting mysql, run mysql -u root -p
to perform database operations, for example, use the following command to see.
# Show which databases are there show databases; # Enter the database use test; # Display table show tables;
The above is the introduction of the editor to install the decompressed version of MySql on Windows 10 (recommended), I hope it will be helpful to you, if you have any questions, please leave me a message, and the editor will reply to you in time.Thank you very much for your support to the website!
buy lipitor 20mg & lt;a href="https://lipiws.top/"& gt;lipitor 20mg cheap& lt;/a& gt; atorvastatin 80mg without preion
Azminf
2024-03-07