Super detailed Mysql graphics and text installation tutorial _mysql

MySQL is a relational database management system, developed by the MySQL AB Company in Sweden and currently belongs to Oracle Company. MySQL is a relational database management system in which the associated database keeps data in different tables rather than putting all the data in a large warehouse, which increases speed and improves flexibility. The SQL language used by MySQL is the most common standardized language used to access databases. MySQL software uses a dual licensing policy (this term "authorization policy"), it is divided into community and commercial version, because of its small size, speed, the overall cost of ownership, especially the characteristics of open source, the general development of small and medium-sized Web site to choose MySQL as a website database. Thanks to the performance of its community edition, the combination of PHP and Apache can make a good development environment.

Method/Step:

Installation: Double-click the Setup.exe file to begin the MySQL installation. The following window appears

Click Next to start the next installation. Default is typical, select Custom, because typical mode does not allow changes to the installation path, can only be installed in the C disk

Here you need to select components and change the folder location, the component can be default, the location to choose changes to change ( Note: install MySQL path, can not contain Chinese)

Click Install to start the installation

Installation complete, see below. Of course, we choose "skipsign-up".

Click to complete "Finsh"

Now it's time to start configuring the work. Click Next to continue.

Select Detailedconfiguration, click Next.

The following option is to choose the MySQL application type (the first is the development server, will only use as little memory, the second is the ordinary Web server, will use a medium amount of memory, the last one is the server running only MySQL database, will occupy all the memory, the example here to select the development server, Using as little memory as possible, users can choose other options according to their own needs.

Next, choose the database Purpose, (the first is a multi-purpose use, will optimize the database to a good InnoDB storage type and efficient MyISAM storage type, the second is only for the transaction type, the best optimization innodb, but also support MyISAM, the last kind of non-transaction processing type , suitable for simple applications, only myisam types that do not support transactions are supported. ) General selection of the first multi-functional.

The following is the choice of data storage location, default.

Choose the maximum number of connections that MySQL allows, the first is the maximum 20 connection concurrent number, the second is the maximum 500 concurrent connections, the last one is custom, you can choose according to your own needs

The following is the choice of database listening port, the general default is 3306, if you change to other ports, when you connect the database to remember the modified port, otherwise can not connect MySQL database, more trouble, here do not make changes, with mysq default port: 3306. Next, the default latin1.

This step is to set MySQL's superuser password, this super user is very important and has all the rights to MySQL, please set and keep in mind the superuser password, there is a check box is to choose whether to allow remote machine with root user to connect to your MySQL server, if this need, Please also tick

When you have entered the password two times, remember the password and click Next to continue. The wait is done.

Issues that are easy to see:when MySQL is installed to the final step, the start service is a failed state .

Workaround:

Mode 1

MySQL installation is appearing could not start the service MySQL error:0 Hint error, workaround: First of all, in the management tool-> service to the MySQL service to stop, and then open cmd into your MySQL bin directory, such as C:\Program files\mysql\mysql Server 5.0\bin Then use the following command Mysqld-nt-remove and then show ... success! Okay, let's go to the Add removal program, find the MySQL option Uninstall, and remember to select Remove. Finally the MySQL directory is deleted, and the directory of the database is also deleted

Mode 2

Check that there is no MySQL in the service, if there is to stop the service; Installing MySQL 5.1.33 the third start service in the Execute configurattion step of the Run Server Instance Configuration Wizard error, error prompted by could not Start the service MySQL (this situation is generally due to the installation of MySQL, uninstall is not clean caused.) Reboot and reload after unloading. Note that if the service is not uninstalled, you can uninstall it with Mysqld-nt-remove.

Run the Add Remove Program in Control Panel, uninstall MySQL; After uninstall, open the registry, view the key values under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services , if there is a related MySQL key value (MySQL, mysqladmin) is deleted To

Restart, the MySQL installation of the residual directory deleted (view services, at this time there is no MySQL service); Reinstall MySQL. Do not run the Server Instance Configuration Wizard after the installation, and then run the wizard in the Start menu after the reboot.

The above is the MySQL graphics and text installation tutorial Detailed introduction, I hope to install MySQL to help you.