Shulou(Shulou.com)06/01 Report--

MySQL is a relational database management system developed by the Swedish company MySQL AB and belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In the aspect of WEB application, MySQL is one of the best RDBMS (Relational Database Management System) application software.

To start the mysql database server, you must have mysql installed on your computer.

Problem description:

The following error occurred when trying to install MYSQL under win7:

Solution:

1. Add the environment variable PATH (for example: C:\ Program Files\ mysql-5.7.13-winx64\ bin)

2. Go to the installation directory of MYSQL and create a new default configuration file my.ini

Write something like this in the my.ini configuration file:

(the specific content can be modified according to its own situation)

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=C:\ Program Files\ mysql-5.7.13-winx64# set mysql database data storage directory datadir=C:\ Program Files\ mysql-5.7.13-winx64\ data# maximum number of connections the character set used by the max_connections=200# server defaults to 8 bits Encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Save when finished, and the my.ini file will replace the default my-default.ini file.

After that, we need to manually create a new data folder under the MYSQL installation directory.

3. Uninstall, reinstall and initialize MYSQL, and finally start the MYSQL service

Run cmd as an administrator and enter the following commands in turn:

C:Windows\ system32 > mysqld-- remove / / delete mysql service C:Windows\ system32 > mysqld-- install / / install mysql service C:Windows\ system32 > mysqld-- initialize / / be sure to initialize C:Windows\ system32 > net start mysql

When the initialization command is executed, the empty data directory generates the following files:

Finally, start the MYSQL service and start it successfully.

These are the details of how to solve the problem that the mysql service cannot be started. Please pay attention to other related articles for more information.

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.