MySQL Zip version installation configuration

Article Source: http://www.cnblogs.com/winstic/, please keep this connection

This time in learning Python database operation knowledge, simple to organize MySQL Zip file installation method

Download

Find the corresponding zip file on the MySQL website http://dev.mysql.com/downloads/mysql/to download it

Installation

Since it is a zip file download, then the installation must not just simple decompression, but also need a certain configuration

Here I unzip the file to C drive C:\Program Files\mysql\mysql Server 5.6.22, in this folder by default there is no configuration file My.ini, but there is a My-default.ini template file for reference, here we create a configuration file ourselves My.ini

[Mysqld] # bind IPv4 and 3306 ports bind-address = 0.0.0.0= 3306#  Set the installation directory for MySQL basedir = C:\Program Files \mysql\mysql server 5.6.22#  Set data storage directory for MySQL database datadir = C:\Program files\mysql\mysql Server 5.6.22 \data # Maximum number of connections allowed max_connections = 200

The above configuration is only the basic parameters required by the MySQL environment, and of course some other parameters can be configured to refer to the official MySQL manual .

With the above configuration, you can install the MySQL service, under DOS into the MySQL bin directory, enter the command Mysqld-install until the display service installation is successful, you can see the corresponding MySQL service in the service program (DOS type Services.msc) and start it

Change root password

It is convenient to set the bin path as an environment variable, for example, I will add C:\Program files\mysql\mysql Server 5.6.22\bin to environment variable here, and then I can use command MySQL to enter MySQL interface directly after DOS.

Because Root's initial password is empty, it's not safe, here we change the password for root

Under DOS type mysqladmin-uroot-p password < New password, the new password is the root password you want to set, hit Enter, will prompt you to enter the password, in fact, to enter the original password, because the original password is empty, all here continue to enter;

Test using root to enter MySQL interface, type mysql-uroot-p under DOS

Microsoft Windows [version6.1.7601] Copyright (c) theMicrosoft Corporation. All rights reserved. C:\Users\Administrator>mysql-uroot-penter Password:******Welcome to the MySQL Monitor. Commands End With; or \g.your MySQL connectionIDIs3Server Version:5.6. AMySQL Community Server (GPL) Copyright (c) -, the, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or Itsaffiliates. Other names trademarks of their respectiveowners. Type'Help ;'Or'\h'  forHelp. Type'\c'ToClearThe current input statement.mysql>

MySQL Zip version installation configuration