Shulou(Shulou.com)05/31 Report--

In this issue, the editor will bring you about the installation of mysql in windows. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

1. There are two kinds of installation packages for mysql. MSI and zip. My computer is a 64-bit system. There is no installation package for .msi on the official website, only the installation package for zip. Download address https://dev.mysql.com/downloads/mysql/.

2. After downloading and decompressing, the installation .exe execution program cannot be found. After Baidu (after decompression, you can rename the folder and put it in the appropriate location. It is recommended to rename the folder to MySQL Server 5.6and put it in C:\ Program Files\ MySQL\ mysql-5.7).

3. There is no .ini file in the decompressed file, Baidu (

[mysql]

# set mysql client default character set

Default-character-set=utf8

[mysqld]

# set port 3306

Bind-address = 127.0.0.1

Port = 3306

# set the installation directory of mysql

Basedir=C:\ Program Files\ MySQL\ mysql-5.7 / / A place where you need your own installation package

# set the storage directory of the data in the mysql database

Datadir=C:\ Program Files\ MySQL\ mysql-5.7\ data / / A place where you need your own installation package

There is a problem: because there is no data file in the unzipped package, if you do not create it, you will be prompted when using net start msql: "No error reported by the service".

Solution: first execute mysqld-initialize-insecure under the bin directory of mysql, and you can see that there will be an extra data folder with a pile of files in the root directory of mysql.

# maximum number of connections allowed

Max_connections=2000

# the character set used by the server defaults to the 8-bit coded latin1 character set

Character-set-server=utf8

# default storage engine to be used when creating new tables

Default-storage-engine=INNODB

)

The content here is required, my file name is my.ini, this file just needs to be placed under C:\ Program Files\ MySQL\ mysql-5.7\.

4. When installing MySQL, you cannot locate the program input point festround to the dynamic link library MSVCR120.dll?

At the beginning of the solution is to re-download MSVCR120.dll, but the application can not start 0xc000007 this error, download DirectX repair tool 3.5 (dx repair tool DirectX Repair download) enhanced version of the good (I do not know from the beginning to use this software repair will be good) download address http://www.xiazaiba.com/html/6081.html.

MSVCR120.dll is available under C:\ Windows\ SysWOW64 and this C:\ Windows\ System32

5. The solution to the emergence of Can't connect to MySQL server on 'localhost' (10061) in mysql

I should not login in the correct way, the correct way under cmd:

Mysql-h localhost-u root-p

Enter passoword: / / the MYSQL we installed does not have a password. Enter directly at this step.

6. Be sure to set the environment variable and append (not overwrite) the contents in quotation marks in the environment variable path "; C:\ Program Files\ MySQL\ mysql-5.7\ bin". If you do not make an environment variable, you have to enter C:\ Program Files\ MySQL\ mysql-5.7\ bin and then enter mysql- h localhost-u root-p under cmd.

This is what the problem of installing mysql in windows is shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.