Installing the MySQL database locally on Windows

From Google for a long time, find a very good MySQL installation process, by the way to share the following, the link is: http://blog.csdn.net/chic_data/article/details/72286329

Environment: Windwos (1511) 64bit, MySQL 5.7.14 time: September 5, 2016 first, download MYSQL1. Open MySQL's official website Http://www.mysql.com/2 in the browser. Go to the "Downloads"  3 at the top of the page. Open the "Community (GPL) Downloads"  4 at the bottom of the page. Find the download page on our windows "MySQL on Windows (Installer & Tools)"  5 in the middle of the page. Select the first item "MySQL Installer"  6. At the bottom of the page find the download Portal "Windows (x86, 32-bit), MSI Installer", click the Download button to start the download, Total 381.4M Note: The MSI format refers to the installation program of Windows, which can be accessed directly by double-clicking on the Installation Wizard, which is different from the installation method of extracting the files;  7. This page tells you if you are logged in, tells you what the benefits are after login, we do not log in, click "No thanks at the bottom of the page, just start my download." button to go to the download page  8. Start the download, wait for the download to complete (due to the direct download speed is too slow, then I use Thunder download completed)  9. Download complete   Second, install MYSQL1. Double-click the downloaded MySQL installation file "Mysql-installer-community-5.7.14.0.msi" to open the installation program, you need to wait a few   2. Choose the type of installation (according to your needs)  3. I only need to install MySQL server, so choose the last "Custom", choose custom after the left of the installation process and the right of the description text will change, and then click "Next" button to continue  4. Here we need to select the MySQL server  we need from the installable products provided by the installer we expand the first "MySQL Servers" in available product, expand its sub-nodes in turn, Until its terminal node, my operation is 64-bit, so check "MySQL server 5.7.14-x64"   then click the Green Rightwards arrow, move the current product to the list that needs to be installed, and then on the right, expand "MySQL Server 5.7.14-X64 ", cancel the" Development components "check (because we only need to install MySQL server), then click" Next "button to enter the next  5. Click "Execute" to start the installation, the installation process will show the installation of the Progress (progress), waiting for the installation after the status will show the Complete,mysql icon will appear before a green tick, and then click "Next" button to enter the product configuration interface   6. Click "Next" button to enter the configuration of MySQL server  config type select "Development Machine", select this will use the smaller content to run our MySQL server, corresponding to small software, learning is fully enough. After "Next"   in root account password set the password of the database root, I fill in 123456 so the program reminds me that the password strength is weak, we need to remember this password, and then click "Next"   Here can set the name of the MySQL server and whether to boot, I changed the name to "MySQLZzz1", cancel the boot boot, the other did not change, click "Next"   Click "Next"   This interface applies the configuration previously set to our MySQL server, click "Execute", wait to complete the   configuration, click "Finish" to complete the configuration link  7. After the configuration is completed, we will go back to the installer, we click "Next" to continue   prompt us to install, click "Finish"  8. After clicking "Finish" in the previous step, the computer is so calm that people don't know what to do next! Experience of installing software in the past this time the computer should automatically start the software that has just been installed. So I looked in the process and did not find a mysql-like process, so we went to the next step. Iii. Configuring the MySQL environment variable (not necessary) Description: After configuring the environment variables for MySQL, we can run MySQL (open, stop, etc) in CMD 1. As in fact, the environment variable configuration method, we open the Environment Variable configuration window (combination key win+pause, change settings, System Properties, select "Advanced" Environment variable) 2. Select "Path" in the system variable and enter the path of the Bin folder under the MySQL installation directory at the beginning of the path value: C:\Program files\mysql\mysql ServEr 5.7\bin, save exit Note: The default path for MySQL server installation is: C:\Program files\mysql\mysql server 5.73. Test is configured successfully: Open cmd, enter "Mysql-u root-p" and enter the password for the root account set at MySQL installation (123456), if prompted "Welcome to the MySQL monitor." Description the configuration was successful. Iv. start MySQL Yes, by now we haven't started our mysql!. So how do you start it? (based on the condition of the configured environment variable) 1. Run cmd as an administrator, enter "net start Mysqlzzz1" (MySQLZzz1 is the server name that is filled in when you configure MySQL server, and CMD is not case-sensitive and can be used)  2. When the prompt starts successfully, we can see the "Mysqld.exe" process in the Task manager's process.  : If the command is executed: The service name is invalid. Please type NET helpmsg 2185 for more help. Workaround:  Execute the mysqld-install command with administrator privileges in the MySQL Bin directory with the method of uninstalling the MySQL service. 1, with administrator permissions net stop MySQL, turn off MySQL service 2, with Administrator's permission mysqld-remove, uninstall MySQL service Five, test whether the installation is successful we use the MySQL management software (Navicat for MySQL) to test the connection, Make sure that MySQL is ready to use: 1. Open Navicat for mysql 2. Create a new connection, fill in the connection information: Connection name: Used to distinguish between different connections, name the host name: localhost port: 3306 user name: root password: 123456 (previously configured when the MySQL password)  3. Clicking the "Connect Test" button pops up the Connection Success dialog box, which means that MySQL server has  4 turned on. After that is the use of navicat for MySQL software   Another: We can also in cmd, again enter "net start Mysqlzzz1", if prompted "the requested service has been started." "indicates that MySQL server has started properly;  to this point, MySQL server is installed on Windows 10 64-bit.   Reprint Environment: Windwos 10 (1511) 64bit, MySQL 5.7.14 time: September 5, 2016 first, download MYSQL1. Open MySQL's official website Http://www.mysql.com/2 in the browser. Go to "Downloads" 3 at the top of the page. Open the "Community (GPL) Downloads"  4 at the bottom of the page. Find the download page on our windows "MySQL on Windows (Installer & Tools)"  5 in the middle of the page. Select the first item "MySQL Installer"  6. At the bottom of the page find the download Portal "Windows (x86, 32-bit), MSI Installer", click the Download button to start the download, Total 381.4M Note: The MSI format refers to the installation program of Windows, which can be accessed directly by double-clicking on the Installation Wizard, which is different from the installation method of extracting the files;  7. This page tells you if you are logged in, tells you what the benefits are after login, we do not log in, click "No thanks at the bottom of the page, just start my download." button to go to the download page  8. Start the download, wait for the download to complete (due to the direct download speed is too slow, then I use Thunder download completed)  9. Download complete   Second, install MYSQL1. Double-click the downloaded MySQL installation file "Mysql-installer-community-5.7.14.0.msi" to open the installation program, you need to wait a few   2. Choose the type of installation (according to your needs)  3. I only need to install MySQL server, so choose the last "Custom", choose custom after the left of the installation process and the right of the description text will change, and then click "Next" button to continue  4. Here we need to select the MySQL server  we need from the installable products provided by the installer we expand the first "MySQL Servers" in available product, expand its sub-nodes in turn, Until its terminal node, my operation is 64-bit, so check "MySQL server 5.7.14-x64"   then click the Green Rightwards arrow, move the current product to the list that needs to be installed, and then on the right, expand "MySQL Server 5.7.14- X64 "Item, cancel" Development ComponeNTS "Check (because we only need to install MySQL server), then click on the" Next "button to enter the next  5. Click "Execute" to start the installation, the installation process will show the installation of the Progress (progress), waiting for the installation after the status will show the Complete,mysql icon will appear before a green tick, and then click "Next" button to enter the product configuration interface   6. Click "Next" button to enter the configuration of MySQL server  config type select "Development Machine", select this will use the smaller content to run our MySQL server, corresponding to small software, learning is fully enough. After "Next"   in root account password set the password of the database root, I fill in 123456 so the program reminds me that the password strength is weak, we need to remember this password, and then click "Next"   Here can set the name of the MySQL server and whether to boot, I changed the name to "MySQLZzz1", cancel the boot boot, the other did not change, click "Next"   Click "Next"   This interface applies the configuration previously set to our MySQL server, click "Execute", wait to complete the   configuration, click "Finish" to complete the configuration link  7. After the configuration is completed, we will go back to the installer, we click "Next" to continue   prompt us to install, click "Finish"  8. After clicking "Finish" in the previous step, the computer is so calm that people don't know what to do next! Experience of installing software in the past this time the computer should automatically start the software that has just been installed. So I looked in the process and did not find a mysql-like process, so we went to the next step. Iii. Configuring the MySQL environment variable (not necessary) Description: After configuring the environment variables for MySQL, we can run MySQL (open, stop, etc) in CMD 1. As in fact, the environment variable configuration method, we open the Environment Variable configuration window (combination key win+pause, change settings, System Properties, select "Advanced" Environment variable) 2. Select "Path" in the system variable, enter the path of the Bin folder in the MySQL installation directory at the beginning of the path value: C:\Program files\mysql\mysql Server 5.7\bin, save exit Note: MySQL servThe default path for ER installation is: C:\Program files\mysql\mysql Server 5.73. Test is configured successfully: Open cmd, enter "Mysql-u root-p" and enter the password for the root account set at MySQL installation (123456), if prompted "Welcome to the MySQL monitor." Description the configuration was successful. Iv. start MySQL Yes, by now we haven't started our mysql!. So how do you start it? (based on the condition of the configured environment variable) 1. Run cmd as an administrator, enter "net start Mysqlzzz1" (MySQLZzz1 is the server name that is filled in when you configure MySQL server, and CMD is not case-sensitive and can be used)  2. When the prompt starts successfully, we can see the "Mysqld.exe" process in the Task manager's process.  : If the command is executed: The service name is invalid. Please type NET helpmsg 2185 for more help. Workaround:  Execute the mysqld-install command with administrator privileges in the MySQL Bin directory with the method of uninstalling the MySQL service. 1, with administrator permissions net stop MySQL, turn off MySQL service 2, with Administrator's permission mysqld-remove, uninstall MySQL service Five, test whether the installation is successful we use the MySQL management software (Navicat for MySQL) to test the connection, Make sure that MySQL is ready to use: 1. Open Navicat for mysql 2. Create a new connection, fill in the connection information: Connection name: Used to distinguish between different connections, name the host name: localhost port: 3306 user name: root password: 123456 (previously configured when the MySQL password)  3. Clicking the "Connect Test" button pops up the Connection Success dialog box, which means that MySQL server has  4 turned on. After that is the use of navicat for MySQL software   Another: We can also in cmd, again enter "net start Mysqlzzz1", if prompted "the requested service has been started." "indicates that MySQL server has started properly;  to this point, MySQL server is installed on Windows 10 64-bit.

Install the MySQL database locally on Windows