MySQL 5.6.24 installation configuration method graphics and text tutorial _mysql

The MySQL database has been used for a long time because of work needs. Basically have forgotten almost. Today reinstall configuration for a while, write an essay record, lest oneself later when need to look over, if there is incorrect or need to add, I hope you leave a message.

First download MySQL, I directly through the Baidu software download "mysql-5.6.24-win32.1432006610" version

After the download is complete. I'm going to extract the C tray first. Then, modify the folder name "MySQL", the directory structure is as follows

In the root directory, there is a file named "My-default.ini", which is modified to. ' My.ini ', this is also convenient after the configuration, less play a little word. Steal a Lazy ~

Open this configuration file, originally

Will draw the red box place, the front "#" removes, must remove, otherwise the MySQL cannot read this configuration, then, will Basedir and DataDir, writes in your installation directory, otherwise after the service does not have the way to start

When you have finished modifying, close the file and start setting the environment variable.

Right-click My Computer-> Properties-> advanced system settings, click the New button under the system variable

Click New, Pop-up confirmation box

Input variable name: mysql_home

Input variable value: MySQL installation directory, this is C:\mysql.

OK, save

Then find path in the environment variable, select, click the Edit button

Add at the end;%mysql_home%\bin;

Note: The variable value is followed by the variable, which is separated and cannot delete the original variable value.

---------------------------------------------------------------------------------------------------------

After the change, the preparation is done, and then you can start the installation.

Into the familiar black box, cmd

CD MySQL installation directory, then enter mysqld--install mysql--defaults-file= "C:\mysql\my.ini" carriage return

Prompt Service Installation success

MySQL is still not available at this time, because after the installation is over, you will start the service

Enter net start MySQL

Here to post, stop and unload the command

Start, stop, and uninstall of MySQL services

Start: net start MySQL

Stop: net stop MySQL

Uninstall: SC Delete MySQL

Note: error 2 and error 1067 are often present at this time.

If the error 2 system does not find a file, check to see if the profile has been modified or if the configuration file has been modified and entered the Bin folder, you need to remove MySQL (input mysqld-remove) before reinstalling (enter Mysqld- Install);

If error 1067 occurs, the profile modification error confirms that the configuration file is correct.

PS: After the service started successfully, you can log in, enter Mysql-u root-p (first login without password, press ENTER directly)

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.