How to quickly install and deploy MySQL in Windows system (green free installation version)

First, download the green free installation version of MySQL. You can put it in any folder. This time I put it directly in the C drive.

step:

1. Copy my-default.ini (if ini has no suffix, it is my-default) and rename it to my.ini (if ini has no suffix, it is my), then copy the following content to replace the original content

[mysql]
default-character-set=utf8
[mysqld]
#Set port 3306 port=3306
#System basic directory basedir=C:/mysql-5.6
#User data directory datadir=C:/mysql-5.6/data
#The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
------------------Copy to the above *Remember to change basedir and datadir to the location of the database *The file can be opened with Notepad

2. Install MySQL Windows Service

(1) Installation

Find the bin directory in the mysql installation directory (shortcut: hold down the shift key in this directory and right-click to select Open command line here) and execute mysqld –install

Enter the command “mysqld –install” in the cmd window

C:\mysql-5.6\bin>mysqld –install

Windows service installed successfully.

*****If Install/Remove of the Service Denied! appears, it is because the current permissions are insufficient

On the start menu of the Windows 10 system, right-click your mouse. In the menu that appears, select Command Prompt (Administrator), click Open, and then execute the above command.

But you have to type "cd C:\mysql-5.6\bin" to go to this folder

(2) Start the MySQL service

Enter the command “net start MySQL” in the cmd window

C:\mysql-5.6\bin> net start MySQL

Display: MySQL service is starting.

The MySQL service has been started successfully.

(3) Change password

(Shortcut: hold down the shift key in the bin directory and right-click to select Open command line here)

bin>mysql -u root, enter mysql
Enter password: ******
set password for root@localhost = password('root');

If Query OK is displayed, the modification is successful.

Then exit

3. Mysql allows other computers to access remotely

Enter the command “mysql -u root -p” in the cmd window and enter the password

Enter mysql> and enter the command "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;"

The above is the editor's introduction to the quick installation and deployment method of MySQL in Windows system (green free installation version). I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!