MySQL5.6 Windows Compact Edition installation configuration process

MySQL installation files are divided into two types, one in MSI format and one in ZIP format. If the MSI format can be directly clicked on the installation, according to the installation prompts it to install (I believe you can read English tips), General MySQL will be installed in C:\Program files\mysql\mysql Server 5.6 Directory The ZIP format is self-extracting, and after decompression, MySQL can actually be used, but to configure.

This article describes the configuration and password settings for a compact version.

Installation process:

• After unpacking the folder can be renamed, put in the appropriate location, personal suggestions to rename the folder to MySQL Server 5.6, put into the C:\Program files\mysql path. Of course you can put it anywhere you want.

• My Computer, properties, advanced environment variables

  Select Path, after which you add: the path to your MySQL bin folder (e.g. C:\Program files\mysql\mysql Server 5.6\bin)

• After configuring the environment variables do not be busy to start MySQL, we also need to modify the configuration file (if not configured, after the start of the error will appear in the diagram Oh!). : Error 2 system cannot find file), mysql-5.6.1x default profile is C:\Program files\mysql\mysql Server 5.6\my-default.ini, or create a My.ini file yourself,

  In which the configuration is modified or added:

  [Mysqld]

  Basedir=c:\program files\mysql\mysql Server 5.6 (MySQL directory)

  Datadir=c:\program files\mysql\mysql Server 5.6\data (the directory where MySQL resides \data)

• Run cmd as an administrator (be sure to run as administrator, or not have enough permissions)

  Input: cd C:\Program files\mysql\mysql Server 5.6\bin into the bin folder of MySQL (regardless of whether the environment variable has been configured, but also to enter the Bin folder, or after the start of the service will still report error 2)

  Enter Mysqld-install(if run without administrator, there will be an error due to insufficient permissions: Install/remove of the Service denied!)

  Installation Successful

• After the installation is successful, start the service, continue to enter in CMD:net start MySQL, the service started successfully!

After successful installation, the root user of MySQL does not have a password, which is not secure and requires a password setting for root:

• First login root User:mysql-u root
• Change the root user password:mysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');
• Then quit MySQL:exit;
• Log in to MySQL with a password:mysql-u root-p
• Then let you enter the password, enter the password to see if the correct

　　

MySQL5.6 Windows Compact Edition installation configuration process