Ultra-detailed mysql graphic installation tutorial and mysql graphic tutorial

Ultra-detailed mysql graphic installation tutorial and mysql graphic tutorial

MySQL is a relational database management system developed by MySQL AB in Sweden and currently belongs to Oracle. MySQL is an associated database management system that stores data in different tables rather than in a large warehouse. This increases the speed and flexibility. The SQL language used by MySQL is the most common standard language for accessing databases. MySQL adopts the dual Authorization Policy (this term "Authorization Policy"). It is divided into community edition and commercial edition. because of its small size, fast speed, and low total cost of ownership, especially open source code, MySQL is generally used as the website database for the development of small and medium-sized websites. Due to its superior performance, the Community edition works with PHP and Apache to form a good development environment.

Method/step:

Installation:Double-click the setup.exe file to start mysql installation. The following window appears.

Click Next to start the Next installation. The default value is Typical. Custom is selected. Because the installation path cannot be changed in Typical mode, it can only be installed on disk C.

Select a component and Change the folder location. The component can be changed by default (Note:The path for installing mysql cannot contain Chinese characters)

Click Install to start installation.

The installation is complete. See the following figure. Of course, we select "SkipSign-Up ".

Click "Finsh"

Now the configuration is ready. Click Next to continue.

Select DetailedConfiguration and click Next.

The following option selects the mysql application type (the first is the development server, which will only use as little memory as possible, and the second is the normal WEB server, which will use a moderate amount of memory, the last one is that this server only runs the mysql database and takes up all the memory.) In this example, the Development Server is used to consume as little memory as possible. You can choose to use it as needed, select other options.

Next, select the database usage. (the first is the multi-function usage, which will optimize the database into a good innodb Storage type and an efficient myisam storage type, and the second is only used for transaction processing, it is best to optimize innodb, but it also supports myisam. The last one is a non-transaction processing type and is suitable for simple applications. Only the myisam type that does not support transactions is supported .) Select the first function.

The following figure shows the data storage location, which is the default value.

Select the maximum number of connections allowed by mysql. The first is the maximum number of 20 connections, the second is the maximum number of 500 concurrent connections, and the last is custom. You can choose

The following is the port for database listening. The default port is 3306. If it is changed to another port, remember the modified port when connecting to the database. Otherwise, you cannot connect to the mysql database, which is troublesome, the default port of mysq is 3306. Latin1 by default.

This step is to set the mysql Super User Password. This super user is very important and has all permissions for mysql. Please set and remember the Super User Password, the following check box is used to select whether to allow remote machines to connect to your mysql server as the root user. If you want to use this check box, select

When the two passwords are the same, remember the password and click Next to continue. Wait.

Easy to troubleshoot: when mysql is installed to the last step, start service is in the failed State.

Solution:

Method 1

When installing MySQL, the following error occurs: cocould not start the service mysql error: 0. Solution: First, stop MySQL services in the management tools> service, open cmd and enter your MySQL bin directory, such as C: \ Program Files \ MySQL Server 5.0 \ bin and then use the following command mysqld-nt-remove to display ...... success! Now go to add and delete programs, find MySQL and select Uninstall. Remember to select remove. Finally, delete the MySQL directory and the database directory.

Method 2

Check whether there is any mysql in the Service. If yes, stop the Service. If mysql 5.1.33 is installed, an error occurs in the third Start Service in the Execute restart attion step when the Server Instance Configuration wizard is running, the error message "cocould not start the service MySQL" is displayed. (This is generally because mysql is installed and cannot be uninstalled. Uninstall and restart before reinstalling. Note that you can use mysqld-nt-remove to uninstall the service if it is not uninstalled)

In the control panel, run the Add/delete program and uninstall mysql. Open the registry and viewHKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ ServicesIf there is a mysql key value (mysql, mysqladmin), delete it;

Restart and delete the residual directory of mysql installation (check that mysql is not available in the service); reinstall mysql. after installation, do not run Server Instance Configuration wizard. After restart, run the wizard in the Start Menu.

The above is a detailed introduction to the mysql graphic installation tutorial. I hope it will help you install mysql.