Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to install mysql on windows". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Mysql_on_windows

1. Download and install software

Download address

Https://dev.mysql.com/downloads/installer/

Downloaded installation package:

Mysql-installer-community-5.7.17.0.msi

2. Installation environment

For learning, operating system win7 x64

Scheduled user password setting: root/password

3. Installation process

Type of installation: developer default

Default all the way

Type: Development Machine

TCP port:3306

Root/password

Window service name: mysql57

Setting: do not start randomly

Default installation location of the software: C:\ Program Files (x86)\ MySQL

4. Start and shut down the database

After mysql starts, you can see the mysqld.exe process in the task manager

Start

Run cmd as an administrator and enter: net start mysql57

Close

Run cmd as an administrator and enter: net stop mysql57

5. Add uninstall service

If prompted when executing the command: the service name is not valid. Please type NET HELPMSG 2185 for more help.

Solution: execute the mysqld-install command under the mysql bin directory with administrator privileges

Attached method to uninstall the mysql service.

1. Shut down the mysql service with the administrator's authority net stop mysql

2. Uninstall the mysql service with the administrator's authority mysqld-remove

6. Connect to the database

Use the MySQL management software (Navicat for MySQL) for connection testing to ensure that mysql is ready to use:

Create a new connection and fill in the connection information:

Connection name: it is used to distinguish different connections. You can name it yourself.

Hostname: localhost

Port: 3306

User name: root

Password: password (password entered when configuring mysql)

The software activation description

NAVL-77J5-3BLF-YDFN

That's all for "how to install mysql on windows". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.