MySQL zip installation configuration and mysqlzip installation Configuration

MySQL zip installation configuration and mysqlzip installation Configuration

Source: http://www.cnblogs.com/winstic/, reserve this connection

During this time, I learned how to operate Python databases and simply sorted out the MySQL zip file installation method.

 

Download

Go to the MySQL official website http://dev.mysql.com/downloads/mysql/and find the corresponding ZIP file to download.

 

Install

Since it is a zip file download, the installation must not only be simple decompression, but also requires some configuration.

Here, I decompress the file to drive C: \ Program Files \ MySQL Server 5.6.22. By default, no configuration file is found in this folder. ini, but there is a template file for my-default.ini for reference, here we create a configuration file myself my. ini

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

The above configuration is only the basic parameter required by the MySQL environment. Of course, you can refer to the MySQL official manual for other parameter configurations.

 

With the above configuration, you can install the MySQL service, enter the bin directory of MySQL under dos, and enter the command mysqld-install until the service is successfully installed, you can see the corresponding MySQL service in the Service Program (type services under dos. msc) and start it.

 

Change root Password

For ease of operation, set the bin path as an environment variable. For example, here I add C: \ Program Files \ MySQL Server 5.6.22 \ bin to the environment variable, after dos, you can directly use the mysql command to enter the MySQL interaction interface,

The initial password of root is empty, which is very insecure. Here we change the password for root.

In dos, type mysqladmin-uroot-p password <new password>. The new password is the root password you want to set. Press enter and you will be prompted to enter the password, in fact, you need to enter the original password. Because the original password is empty, you can press enter here;

Use root to enter the MySQL interaction interface. In dos, type mysql-uroot-p.

Microsoft Windows [version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved. C: \ Users \ Administrator> mysql-uroot-pEnter password: ****** Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 3 Server version: 5.6.22 MySQL Community Server (GPL) Copyright (c) 2000,201 4, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. other names may be trademarks of their respectiveowners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql>