MYSQL for Windows uncompressed version configuration

#配置步骤

1. Download the unzip first. (Here I extracted to my computer's "E:\SOFTWARE\MYSQL" this location, the following table for example);

2. My Computer right-click Properties, find the environment variable configuration, configure the environment variables, the Mysql.exe directory (usually the bin directory after extracting directory, where my directory is E:\software\MySql\bin) added to the original path variable;

3. Modify the My-default.ini file in the directory after the extract is finished

One of the key two sentences

Basedir=e:\software\mysql (MYSQL directory)

Datadir=e:\software\mysql\data (MySql directory \data, this data folder is my own after the decompression of the newly created)

4. Run cmd as Administrator (required), then enter the bin directory of MySQL and input mysqld-install

5. Start the service in the previous step, immediately following the net start MySQL

6. Enter Mysql-u root-p (first login without password, press ENTER directly), Login success!

#自己遇到的一些问题

Do not know why, enter the time prompt password error, and then Baidu to find the password reset policy. The resulting process is as follows

1. In the bin directory of MySQL, open cmd in this directory (tip: Press the shift right mouse button to open the Command Line window here)

2. Open Task Manager to see if the Mysqld.exe process exists, and if so, end the process

3. Execute mysqld--skip-grant-tables.

4. Use tip 1 to open a window again at the current location, execute MySQL to enter the database

5. Then execute command line set PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ').

#一些小技巧

1. Open a command-line window at the current location, then execute Mysql-u root-p, enter the password, and enter the MySQL admin interface to execute the SQL script using source ' Path/xx/xx.sql '

2. To facilitate understanding of the data, it is recommended to use NAVICAT to manage the data.

MYSQL for Windows uncompressed version configuration