For 4 years in university, I made the first money by selling this MySQL database installation tutorial

The installation of MySQL database is very important. Once the installation fails, uninstallation will be very troublesome. So let me introduce the installation of MySQL database.

1. How to uninstall the MySQL database.

If the MySQL database installation fails on the computer and it is not uninstalled cleanly, it will bring a lot of trouble to the subsequent installation. MySQL will be difficult to install, so let's talk about uninstalling first.

Uninstall method:

=

Now for the installation process:

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Fill in the installation directory. The directory must have only English letters, no spaces or Chinese characters! It is also recommended not to put it in the same partition as the operating system, so as to prevent the data from being emptied when the system is backed up and restored. Due to teaching needs, my installation directory is "C:lamplMySQL" and press "OK" to continue to

Insert picture description here


return to the

Insert picture description here


previous interface, press "Next" to continue to confirm the previous settings, if there is a mistake, press "BAck" to return and redo. Press "linstall" to start the installation

Insert picture description here
Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


At this point, the software installation is complete, and the mysq|configuration wizard appears. Check the box in front of "Configure the Mysql Server now" and click "Finish" to end the software installation and start the mysq|configuration wizard.

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


Select the server type,

"Developer Machine (development and testing, mysql occupies very little resources)

"Server Machine (server type, mysql takes up more resources)"

"Dedicated MySQL Server Machine (dedicated database server, mysq| occupies all available resources)", you choose according to your own type, generally choose "Server Machine", it will not be too small or full.

Insert picture description here


Insert picture description here


Insert picture description here


To configure InnoDB Tablespace is to select a storage space for InnoDB database files. There is no modification here, use the default location, and directly press "Next" to continue.

Insert picture description here


Choose your website's general mysq| visits and the number of simultaneous connections, "Decision Support (DSS)/OLAP (about 20)
" Online Transaction Processing (OLTP) ) (About 500) "Manual Stting (manual setting, input a number)", here select "Online Transaction Processing (OLTP)", your own server should be enough, press "Next" to continue

Insert picture description here


whether to enable TCP/IP Connect, set the port, if you don’t enable it, you can only access mysq|database on your own machine, enable it here, and put Port Number: 3306 on the front tick (used by default). The port here is important, remember that it will be used when accessing. Press "Next" to continue

Insert picture description here

Set the mysq|default database language encoding, the first is Western encoding, the second is multi-byte universal utt8 encoding, which is not our universal encoding, the third universal, select or fill in CharacterSet Enter "gbk", of course you can also use "gb2312". Since you can create a table and set the code during the teaching, choose the first default one here. Ann "Next" to continue

Insert picture description here


Choose whether to install mysql as a windows service, you can also specify the Service Name (service identification name, this name is important, and you need to use it when you visit), whether to add the bin directory of mysq| to the Windows PATH, I have all ticked here, The Service Name remains unchanged. Ann "Next" to continue

Insert picture description here

Ask if you want to modify the password of the default root user (super management) (the default is empty last), "Create An Anonymous Account (create an anonymous user, anonymous users can connect to the database, can not operate data, including queries)", generally do not need to check After setting, press "Next" to continue. If you set a new password here, you must remember it, if you forget it, you won’t find it.

Insert picture description here


Confirm that the settings are correct, if they are wrong, press "Back" to return to check. Press "Execute" to make the setting effective. This process needs to wait a while. Until the installation is complete.

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here

Finally: [A tutorial that may help you]

Insert picture description here


This information should be the most comprehensive and complete preparation warehouse for friends who are doing [software testing]. This warehouse has also accompanied me through the most difficult journey, and I hope it can help you too! Everything has to be done as early as possible, especially in the technology industry, we must improve our technical skills.

Follow my WeChat public account: [Programmer two black】Get it for free~

My learning exchange group:642830685 There are technical experts in the group to communicate and share together~

If my blog is helpful to you, if you like the content of my blog, please "Like", "Comment" and "Favorite" with one click and three links!

High-paid programmers can't hide from the 35-year-old... When ability and age are out of touch, how can we save ourselves?

After graduating from university, it began to sell... Not to be reconciled to the status quo, the road to self-help by switching to testing

From sales to unemployment, finally choose software testing, looking back at this path, I am very lucky!