Mysql installation,

Mysql installation,

I. rankings of various databases

Use the following URL to query the rankings of various databases: https://db-engines.com/en/

Ii. Mysql download, install, start/stop, and uninstall services

: Https://www.mysql.com/

Mysql has two versions: community (community) is a free version and Enterprise (enterpise) is a paid version.

1. Install Mysql

A. decompress the downloaded package, change it to "mysql", and cut it to the appropriate location.

B. Switch the current directory to the bin directory under the doscommand line and execute the following command:

Mysqld -- install # install mysql database software
# Return result: Service successfully installed. The installation is successful.

2. Start the Mysql service.

Net start mysql # start the mysql database software service # result: # the MySQL service is being started. # The MySQL service has been started successfully.

3. Stop Mysql services

Net stop mysql

4. Uninstall the Mysql Service

Mysqld -- remove

5. Customize the Mysql service name

Sometimes we need to customize the Mysql service name, without the default "MySQL" name.

You can specify the service name when installing the Mysql software.

mysqld --install cmysql

6. log on to the mysql server.

Mysql-h host name-u user name-p password # host name can be omitted on the local machine

Mysql-uroot

7. mysql Connection Tool

• Phpmysadmin
• This tool is recommended for sqlyog.
• Navicat for mysql is a tool officially developed.