MySQL installation (Linux system &windows system) One

One, Windows system installation MySQL

　　

MySQL is a relational database management system developed by the Swedish MySQL AB company, currently owned by Oracle Corporation. MySQL is an associated database management system that keeps data in separate tables rather than putting all of the data in a large warehouse, which increases speed and increases flexibility. The SQL language used by MySQL is the most commonly used standardized language for accessing 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, low total cost of ownership, especially the open source of this feature, the general small and medium-sized web site development has chosen MySQL as the site database. Thanks to the performance of its community edition, PHP and Apache make a good development environment.

Tools/Materials

• MySQL installation package

Method/Step

2. Install: Double-click the Setup.exe file to start the MySQL installation. The following window appears

4. Click Next to start the next installation. The default is typical, choose Custom, because typical mode does not allow to change the installation path, can only be installed on the C drive

6. Here you need to select the components and change the folder location, the component can be the default, the location to choose change (

   Note: The path to the installation of MySQL cannot contain Chinese)

8. 4

   Click Install to start the installation

10. 5

    Installation is complete, see below. Of course, we chose "Skip sign-up".

12. 6

    Click Finish "Finsh"

14. 7

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

    Select Detailed Configuration and click Next.

16. The following option is to select the MySQL application type (the first is the development server, will only use as little memory, the second is a normal Web server, will use a medium amount of memory, the last is this server only run MySQL database, will occupy all the memory,) here is an example to select a development server, With as little memory as possible, users can choose other options depending on their needs.

18. Next choose the database use, (the first is multi-purpose, will optimize the database into a good INNODB storage type and efficient MyISAM storage type, the second is only for transaction type, the best optimization innodb, but also support MyISAM, the last kind of non-transaction processing , suitable for simple applications, only myisam types that do not support transactions are supported. The first type of multifunction is generally selected.

20. The following is the selection of the data storage location, default.

22. Choose the maximum number of connections allowed by MySQL, the first is the maximum number of 20 connection concurrency, the second is the maximum number of 500 concurrent connections, the last is custom, you can choose according to your own needs

24. The following is the selection of the database listening port, the general default is 3306, if you change to another port, the subsequent connection to the database to remember the modified port, otherwise you can not connect to the MySQL database, more trouble, here do not modify, with mysq default port: 3306. The default encoding is Latin1, but if you take into account the Chinese garbled problem, you can modify the encoding format to UTF-8.

26. This step is to set up the MySQL super user password, this super user is very important, for MySQL has full permissions, please set up and remember the superuser password, below is a check box is to choose whether to allow the remote machine root user to connect to your MySQL server above, if there is this need, Please also tick

28. Once you have entered the password two times, remember the password and click Next to continue. The wait is complete.

30. An easy problem: when MySQL installs to the last step, the start service is in a failed state.

32. Workaround:

    Mode 1 MySQL installation is appearing could not start the service MySQL error:0 Prompt error, workaround: First, in the management tools--services to stop MySQL service, 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 it will show ... success! OK below go to add remove program, find MySQL Select Uninstall, remember to select Remove. Finally, the MySQL directory is deleted, and the database directory is also deleted

34. Mode 2

    Check the service for any MySQL, if any, to stop the service; Installation of MySQL 5.1.33, the third entry in the Execute Configurattion step when running the Server Instance Configuration Wizard error, error prompt is could not Start the service MySQL (this situation is usually caused by the installation of MySQL, the uninstallation is not clean.) Restart and reload after uninstalling. Note the service, if not uninstall, you can use Mysqld-nt-remove uninstall)

    Run add Remove Program in Control Panel to uninstall MySQL; After uninstalling, open the registry to view

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services under the key value, if there is the relevant MySQL key value (MySQL, mysqladmin) is deleted, you can;

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

One of the MySQL installations (Linux system &windows System)