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

mysql unzipped version download address: dev.mysql.com/downloads/mysql/

initialize MySQL

After decompression, open the command line (cmd) and enter the bin directory of mysql. Enter the command to initialize mysql:

mysqld --initialize-insecure

2. Add environment variables

Copy bin directory such as: D:\mysql-5.7.21-winx64\bin

Computer--> Properties--> Advanced System Settings--> Environment Variables--> System Variables--> Variable (Path)

Double-click to open, add a ' ; ' semicolon at the end of the variable value, and then paste the bin directory in. OK

3. Start mysql service

net start mysql

running MySQL

On the command line type (password blank):

mysql -u root -p

5. Installation error resolution

Sometimes after installing mysql, use mysql command to report error Can't connect to MySQL server on localhost (10061), or use net start mysql to report invalid service name, usually because mysql service is not started. Then add mysql to Windows services.

At this point you can run cmd.exe as an administrator (note that it must be run as an administrator), otherwise it will report Install/Remove of the Service Denied!

The command line switches to the bin folder in the mysql installation directory and runs "mysqld --install".

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.