Recently some partners, often because of mysql installation problems, hit the confidence of learning. To this end, I have summarized a super detailed mysql installation tutorial to meet all the needs of beginners to learn mysql.
MySQL is used more in database software, whether for enterprise or individual developers, or students, is a good choice, the following start MySQL installation tutorial, let you quickly learn to install and configure MySQL, master the basic knowledge of MySQL, and easy to use MySQL database.
Novice recommended video to watch, more accessible, the main content of the video covers:
MySQL management tools: How to install MySQL and new features of MySQL
Watch online:
www.bilibili.com/video/BV1fx…
Information download:
www.bjpowernode.com/javavideo/1…
MySQL Installation procedure
Open the downloaded mysql installation file
Mysql -essential-5.0.22-win32.msi, double click on mysql-essential-5.0.22-win32.msi, double click on mysql-essential-5.0.22-win32.msi
Click “Next” to continue
Select the installation type. There are three options: Typical, Complete, and Custom. Select Custom to get familiar with the installation process.
Select the Custom installation step and set the MySQL component package and installation path. After setting, click Next to continue the installation.
Click “Configure the Mysql Server Now” and click “Finish” to complete the installation and start the Mysql configuration wizard. The mysql configuration wizard starts the page. Press Next to continue.
Select Detailed Configuration (manual and precise Configuration) and Standard Configuration. Select Detailed Configuration to get familiar with the Configuration process.
Select the Server type, “Developer Machine (development test class, mysql consumes few resources)”, “Server Machine (Server type, Dedicated mysql Server Machine (Dedicated mysql Server Machine), Dedicated mysql Server Machine (Dedicated mysql Server Machine), Dedicated mysql Server Machine (Dedicated mysql Server Machine), Dedicated mysql Server Machine (Dedicated mysql Server Machine), Dedicated mysql Server (Dedicated mysql Server Machine), Dedicated mysql Server (Dedicated mysql Server), Dedicated mysql Server
Select a mysql Database that supports InnoDB and MyISAM as a Transactional Database and use it as a Transactional Database. Non-transactional Database Only (MyISAM supports Only non-transactional data types); Here I select “Multifunctional Database” and press “Next” to continue.
Mysql > alter Tablespace InnoDB; alter Tablespace InnoDB; alter Tablespace InnoDB; alter Tablespace InnoDB; I didn’t change it here, so I’ll use the default position and press “Next” to continue.
Select the average number of mysql visits to your site, the number of simultaneous connections, “Decision Support(DSS)/OLAP (20 or so)”, “Online Transaction Processing(OLTP) (500 or so)”, “Manual Setting (Manual Setting, input a number by yourself)”, Here, I select Decision Support(DSS)/OLAP and press Next to continue.
If TCP/IP is enabled and Port Number is set, then you can only access the mysql database on your own machine. 3306, on this page, you can also select “Enable Strict Mode” and press “Next” to continue.
Mysql > select utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8, utF8
Mysql > install mysql as a Windows Service, you can also specify Service Name (Service id Name), whether to add mysql to the bin directory of Windows PATH, you can directly use the file under bin without specifying the directory Name, such as connection. “Mysql. Exe – uusername – ppassword;” Mysql > select mysql.exe from mysql.exe. Mysql > select mysql.exe from mysql.exe. Press “Next” to continue.
After setting, press “Next” to continue.
Confirm that the Settings are correct. If not, press Back to check. Press Execute for the setting to take effect.
MYSQL services can be managed through the service manager.
Invoke the service manager by command :services.msc;
Stop the MYSQL service.
Start the MYSQL service.
Stop the MYSQL service.
Start the MYSQL service.
