Shulou(Shulou.com)06/01 Report--

This article mainly explains "windows how to install mysql and configure environment variables". The explanation in this article is simple and clear and easy to learn and understand. Please follow the editor's train of thought to study and learn "windows how to install mysql and configure environment variables".

1. Download mysql server

two。 Release my place directory locally: d:\ mysql-5.6.24-win32

3. Configure environment variables (many programming languages and server basically involve configuring your own environment variables)

My computer-> Properties-> Advanced-> Environment variables

Select PATH and add after it: the path to your mysql bin folder

(for example, my local path is: d:\ mysql-5.6.24-win32\ bin)

PATH=.;D:\ mysql-5.6.24-win32\ bin (note that it is appended, not overwritten)

4. Repair basedir; datadir in the my-default.ini configuration file

The specific file path or your mysql installation directory

After modification, it is as follows:

5. The installation service administrator runs CMD to enter the bin folder of mysql (required)

Execute mysqld-install

6. Starting the service also requires the administrator to run CMD to enter the bin folder of mysql

Execute net start mysql

You may encounter error 2 and error 1067 at this time

"error 2 system can not find the file", check whether the configuration file has been modified or entered the operation in the bin directory, if the configuration file has been modified correctly and entered the bin folder, you need to delete mysql (enter mysqld-remove) and then reinstall (enter mysqld-install).

Error 1067, which is the configuration file modification error. Make sure the configuration file is correct.

7.mysql login

Enter mysql-u root-p (there is no password for the first login, press enter directly), the login is successful

Other note: close the mysql service and kill it directly in the process.

Thank you for reading, the above is the content of "windows how to install mysql and configure environment variables". After the study of this article, I believe you have a deeper understanding of how windows installs mysql and configure environment variables, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.