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.
Now for the installation process:
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
return to the
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
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.
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.
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.
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
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
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
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
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.
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.
Finally: [A tutorial that may help you]
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!