MySQL Service manual Installation method

2. Unzip the installation

   Download and unzip the MySQL ZIP format installation package.

   Rename the extracted file to MySQL Server 5.6.

   Create the MySQL folder under the C:\Program files directory.

   Copy the folder MySQL Server 5.6 to the directory C:\Program files\mysql. (You can also choose a different path yourself)

4. Configuring Environment variables

   environment variable, properties---------------at the end of path, add "; C:\Program files\mysql\mysql Server 5.6\bin ", here is the path to the MySQL Bin folder.

6. Modifying a configuration file

   In the default configuration, ask the price directory C:\Program files\mysql\mysql Server 5.6 To modify My-defult.ini If you do not have to manually add the file yourself.

   Modify the Place:

   [Mysqld]

   Basedir = C:\Program files\mysql\mysql Server 5.6 (MySQL directory)

   DataDir = C:\Program files\mysql\mysql Server 5.6\data (MySQL data directory)

   Description: Remove the previous # to save the INI file.

8. Start MySQL

   Run cmd as Administrator.

   Command Line input: cd C:\Program files\mysql\mysql Server 5.6\bin, enter the bin directory.

   Command line input: Mysqld-install (start MySQL service)

   Problems encountered:

   1. Modify the MySQL service execution program address

   To the registry HKEY_LOCAL_MACHINE----SYSTEM----CurrentControlSet Change the Find MySQL entry value, and then the path, modify the ImagePath value to C:\Program files\mysql\ MySQL Server 5.6\bin

   2. Starting the MySQL service, 1067 errors occurred

   This error is generally due to errors in the My.ini file, which can be mysqld--console at the command line to view the error log.

MySQL Service manual Installation method