Mysql 5.6.24 installation and configuration method graphic tutorial, mysql5.6.24

Mysql 5.6.24 installation and configuration method graphic tutorial, mysql5.6.24

It has been a long time since I started using the mysql database because of my work needs. I forgot about it. I re-installed and configured it today, and wrote an essay record to avoid reading it as needed. If there is any incorrect or need to be supplemented, I hope you can leave a message.

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

After the download is complete. I will uncompress it to drive C first. Then, change the folder name to "mysql". The directory structure is as follows:

Under the root directory, there is a file named my-default.ini, modified. 'My. ini ', which is also easier to configure later, with less words. Stealing laziness ~

Open the configuration file.

Remove "#" in front of the place in the red box. Otherwise, mysql cannot read this configuration. Then, write basedir and datadir to your installation directory, otherwise, the service cannot be started.

After the modification, close the file and set the environment variables.

Right-click my computer-> properties-> advanced system settings, and click New under System Variables

Click Create. The confirmation box is displayed.

Input variable name: MYSQL_HOME

Input variable value: mysql installation directory, which is C: \ mysql

OK, save

Find the Path in the environment variable, select it, and click Edit.

Add % MYSQL_HOME % \ bin at the end;

Note: This variable is added after the variable value and separated by;. The original variable value cannot be deleted.

Bytes ---------------------------------------------------------------------------------------------------------

After the change, the preparation is complete. Next, you can start the installation.

Enter the familiar black box, cmd

Cd mysql installation directory, then enter mysqld -- install MySQL -- defaults-file = "c: \ mysql \ my. ini" and press ENTER

Prompt that the service is successfully installed

Mysql cannot be used at this time, because after the installation is complete, the service must be started.

Enter net start MySQL

The command for stopping and uninstalling is posted here.

Start, stop, and uninstall the MySQL Service

Start: net start MySQL

Stop: net stop MySQL

Uninstall: SC delete MySQL

Note:At this time, errors 2 and 1067 often occur.

If "Error 2: The system cannot find the file" is displayed, check whether the configuration file has been modified or whether the file is in the bin directory. If the configuration file is modified correctly and the bin folder is displayed, you must first Delete mysql (input mysqld-remove) and then reinstall (input mysqld-install );

If error 1067 is displayed, the configuration file is modified incorrectly. Check whether the configuration file is correct.

PS: after the service is successfully started, you can log on and enter mysql-u root-p (no password for the first login, press Enter)

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.