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

This article will explain in detail what MySQL database is for everyone, Xiaobian thinks it is quite practical, so share it with everyone for a reference, I hope you can gain something after reading this article.

What is MySQL?

MySQL is one of the most popular relational database management systems. MySQL is one of the best RDBMS(Relational Database Management System) application software in WEB application. MySQL is widely used in small and medium-sized websites on the Internet. MySQL software uses a dual licensing policy, divided into community version and commercial version, because of its small size, speed, low total cost of ownership, especially open source this feature, generally small and medium-sized website development choose MySQL as a website database.

Classification of databases

In actual project development, databases are divided into two categories:

relational database

Relational database refers to a database that uses a relational model to organize data. It stores data in the form of rows and columns for users to understand. This series of rows and columns of relational database is called tables. A group of tables constitutes a database. A user retrieves data from a database by querying, and a query is an execution code used to qualify certain regions of the database. Relational model can be simply understood as two-dimensional table model, and a relational database is a data organization composed of two-dimensional tables and their relationships.

Small database: Microsoft Access

Medium database:

DB2: IBM's database product, paid for. Often used in banking systems. Internet companies in China, ask to go IOE

MySQL: Open source free database, small database. MySQL 5.5 has been acquired by Oracle and is later released by Oracle.

SQL Server: Microsoft charges for a medium-sized database. Languages such as C#and. Net are often used.

Large databases:

Oracle: Large databases for a fee, Oracle Corporation products. Oracle acquires SUN Corporation, acquires MYSQL.

non-relational data

Non-relational databases include: Redis, MongoDB

mysql command line usage

1. connect to MySQL

Format: mysql-h host address-u user name-p user password

A. Connect to local MYSQL

First open a DOS window, then go to the directory mysql\bin, and then type the command mysql-uroot-p,

Enter the prompt after you enter the password. The MYSQL prompt is: mysql>. (default root user has no password)

B. Connecting to MYSQL on a remote host

Suppose the IP of the remote host is 218.105.110.116, the username is root, and the password is abcd123456.

Type the following command: mysql-h318.105.110.116-uroot-pabcd123456;

2. Start mysql service

netstartmysql

3. Stop mysql service

netstopmysql

4. Query whether ports conflict

netstat-na| findstr8080 Check the port being listened on,findstr is used to find out if the following port exists.

5. Exit mysql

Exit or exit

6. Change password:

Format: mysqladmin-u username-p old password new password

For example, change the password for root:

mysqladmin-uroot-pab12passworddjg345

About "MySQL database is what to do" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.

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.