Windows Server2008 Installation mysql5.6 program does not start correctly (0xc000007b)

Download

Download mysql5.6 version to official website, MSI install package only 32 bit no 64 bit

Move to the specified folder, unzip the file

Adding environment variables

Variable name: mysql_home

Variable Value: C:\Program files\mysql

This is the custom unzip directory for MySQL.

Add%mysql_home%\bin in Path again

Registering as a Windows system service

1) Enter the bin directory under the MySQL decompression directory from the console (note that CMD is best run as Administrator):

2) Enter the Service installation command:

mysqld install MySQL--defaults-file= "c \ your MySQL installation directory \mysql\my-default.ini"

A successful installation will prompt the service to install successfully.

Note: The My-default.ini file is available in the root directory after MySQL decompression, if not, from somewhere else.

The Removal Service command is: mysqld remove

Start the MySQL service

net start MySQL

Alternatively, open the admin tools service, find the MySQL service, and start the service by right-clicking to start or by tapping the left-hand boot directly.

Change the password of the root account

The default password for the root account is empty when the installation is complete, and you can modify the password to the specified password. Example: 123456

Method One:

C:>mysql–uroot

Mysql>show databases;

Mysql>use MySQL;

Mysql>update user SET Password=password ("123456") WHERE user= ' root ';

Mysql>flush privileges;

Mysql>quit

Method Two:

Use third-party management tools for password modification. such as Navicat for MySQL

Focus:

When you execute mysqld install or double-click the Mysqld.exe file, the program does not start correctly (0xc000007b) because the server lacks a C + + library

Workaround: Baidu windows2008 Microsoft Visual C + +, download DirectX Repair tool

Reference: https://www.cnblogs.com/happyty/p/4131686.html

Windows Server2008 Installation mysql5.6 program does not start correctly (0xc000007b)