Install MySQL by compressing package

Before I installed MySQL, I always installed it with a compressed package. If you have previously installed MySQL, you must delete the registration file to completely delete MySQL.

Download the MySQL version on the website first. Download the package version, which is the. zip version. After the download is complete, it is the following directory

There used to be a My-default.ini file. The downloaded MySQL compression package is the default configuration, such as the default character set or Latan Latin.

Just change the file name to My.ini and add the following information

Then use CMD to enter the bin directory of the MySQL installation directory (cmd must be open as an administrator)

then enter the following

Mysqld-install

This will successfully install the

Then enter net start, or open the MySQL service in Service Manager.

This time is not found to set the password, to set their own password to use the following way

Log in to MySQL first

Enter as follows, prompt password, without password, press ENTER directly. Enter the following command after entering

Use MySQL; Press ENTER

Update user set Password=password ("Own password")

where user= "root"; press Enter

Enter the flush privileges after the carriage return is complete;

It's done. At this time to install a visual interface can be completed, such as SQL Yog

Install MySQL by compressing package