--- 1067 system error when installing MySQL in win732-Bit mode --- Problem and Solution

--- 1067 system error when installing MySQL in win732-Bit mode --- Problem and Solution

Every time you install a database, such a problem always occurs. Now record it for future reference ....

Download the decompressed-zip version. For installation configuration tutorial, refer to hongge notes article-MySQL-5.6.13 unzip version (zip version) Installation configuration tutorial

After decompression, create a my. ini file as the MySQL configuration file.

Enter the command mysqld-install in cmd.exe to prompt that the service is successfully installed!

However, if you enter net start mysql in cmd.exe, the following error always occurs: [mysql service cannot be started; System Error 1067] [This system error 1067 indicates that the system cannot find the file, the process cannot obtain the required files. The problem is my. ini], after reading a lot of information and trying the method, I finally solved the problem and MySQL service started successfully.

My. ini content is:

[Mysqld]

# Binding IPv4 and 3306 ports
Bind-address = 127.0.0.1
Port = 3306

# Set the installation directory of mysql

Basedir = D:/MySQL/mysql-5.6.21-win32/mysql-5.6.21-win32

# Set the directory for storing mysql database data
Datadir = D:/MySQL/mysql-5.6.21-win32/mysql-5.6.21-win32/Data [it must be the data folder in the decompressed folder. I initially set a custom folder, so it cannot be started successfully ...]

# Maximum number of connections allowed
Max_connections = 200

Related commands:

1) Enter net start mysql ---- check whether the MySQL service is started

2) Input mysqlshow --- to display the table in the database or database, or information about the column or index in the table.

3) Enter mysql-uroot-p --- to Enter MySQL. Because the default password for MySQL installation is empty, press Enter when "Enter password:" appears, "mysql>" indicates that MySQL has been successfully entered as the root user.

4) Enter mysqladmin-uroot-p password, replace <new password> with your custom password, and press Enter.The system will prompt you to enter the password, which actually refers to the original password. Because the original password is empty, you can press enter to complete the settings.

The installation process has been completed, and you will be able to complete the subsequent study experience ~~