MySQL and sqlyog installation tutorial with pictures and text

1. MySQL 1.1 MySQL installation

mysql-5.5.27-winx64 download

(1) Welcome to install

(2) Acceptance of Agreement

(3) Installation mode selection

Typical: Indicates that commonly used components will be installed. By default, they are installed to C:\Program Files\MySQL\MySQL Server 5.5\.
Complete: Indicates that all components will be installed. This package will take up a lot of disk space.
Custom: Indicates that users can select the components to be installed and can change the default path. This sorting method is the most flexible and is intended for advanced users.

(4) Select installation components and path

(5) Installation

(6) Installation completed

1.2 MySQL Configuration

(1) Preparation

(2) Select configuration Select the configuration method, "Detailed Configuration" or "Standard Configuration". We choose "Detailed Configuration" to familiarize ourselves with the configuration process.

(3) MySQL application mode
Develop Machine, using the minimum amount of memory
Server Machine, medium memory usage
Dedicated MySQL Server Machine, using the maximum memory currently available.

(4) Select the database purpose selection interface to select the general purpose of the MySQL database:
"Multifunctional Database (general multifunctional, good)": This option provides fast access to both transactional storage engines (InnoDB) and non-transactional storage engines (MyISAM).
"Transactional Database Only (Server Type, Focus on Transaction Processing, General)": This option mainly optimizes the transactional storage engine (InnoDB), but the non-transactional (MyISAM) storage engine can also be used.
"Non-Transactional Database Only (simpler) is mainly used for monitoring and counting. Support for MyISAM data types is limited to non-transactional. Note that the transactional storage engine (InnoDB) cannot be used.

(5)Configure data file directory
InnoDB data files are created when the database is started for the first time, and by default are created in the MySQL installation directory. Users can choose a path based on actual space conditions.

(6) Concurrency Selection Settings Select the general MySQL traffic for your website and the number of simultaneous connections, "Decision Support (DSS)/OLAP (decision support system, about 20)", "Online Transaction Processing (OLTP) (online transaction system, about 500)", "Manual Setting (manual setting, enter a number yourself)"

(7) Network selection configuration

Whether to enable TCP/IP connection and set the port. If not, you can only access the MySQL database on your own machine. I enable it here and check the box in front of it, Port Number: 3306. There is also a firewall setting "Add firewall exception..." that needs to be selected to add the listening port of the MYSQL service as a Windows firewall exception to avoid firewall blocking.
On this page, you can also select Enable Strict Mode so that MySQL will not tolerate minor syntax errors. Use standard mode whenever possible because it reduces the likelihood of harmful data entering the database.

(8) Select character set

(9) Safe Choice

(10) Set a password

(11) Prepare the execution interface

(12) Complete

2. SQLyog installation

SQLyog is an easy-to-use, fast and concise graphical management tool for MYSQL databases. It can effectively manage your databases at any location. The installation is fool-proof.
SQLyog (MySQL graphical management tool)

Summarize

This is the end of this article about the detailed graphic tutorial of MySQL and sqlyog installation. For more relevant MySQL and sqlyog installation content, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope everyone will support 123WORDPRESS.COM in the future!