Basic MySQL database tutorial

Source: Internet
Author: User
From the initial gathering of data files to today's large-scale database management system, databases have become an indispensable part of our daily life. Without the help of the database, a lot of simple work will become tedious, even from the initial gathering of data files, databases have become an indispensable part of our daily life. Without the help of the database, a lot of simple work will become tedious and even difficult to achieve. Especially large organizations such as banks, schools, and libraries are more reliant on database systems to achieve normal operation. Looking at the Internet, from search engines to online malls, from online chat to email lists, all of them are inseparable from databases.

Currently, database products on the market are diverse. from solutions for large enterprises to small-sized utilization systems for small and medium-sized enterprises or individual users, these products can meet diversified user needs. Here, we want to introduce you to the MySQL database, which is one of the many relational database products. compared with other systems, MySQL database can be called the fastest-running SQL language database. In addition to the functions and choices that many other databases do not have, MySQL database is a complete and free product that allows users to directly load databases from the internet for personal or trade purposes, without having to pay for any cost (download site http://www.mysql.com is recommended ).

In general, MySQL databases have the following important features:

1. the number of users visiting the database at the same time is not limited;

2. more than 50,000,000 records can be retained;

3. it is the fastest-running database system in existing products on the market;

4. the user permission settings are simple and valid.

Today, international famous companies including Siemens and Silicon Graphics have begun to use MySQL as their database management system, which further confirms the superior performance of MySQL database and broad market development prospects.

This article will focus on the reader's basic control of the MySQL database, including how to establish a connection with the database, how to set the database, and how to execute basic commands. Hope to help readers learn and grasp the MySQL database.

Entry

Generally, when visiting the MySQL database, we need to use telnet to remotely log on to the server where the database system is installed, and then enter the MySQL database. The MySQL database connection command is as follows:

Mysql-h hostname-u username-p [password]

Or:

Mysql-h hostname-u username -- password = password

The hostname is the name of the server containing the MySQL database. the username and password are distinguished by the user's logon name and password.

If the MySQL database is correctly installed and configured, you will receive the following system feedback after entering the preceding command:

Welcome to the MySQL monitor. Commands end with; or \ g.

Your MySQL connection id is 49 to server version: 3.2 3-beta-log

Type help for help.

Mysql $ # @ 62;

In this way, the user successfully enters the MySQL database system and can enter various commands after the mysql command prompt. Below, we will list some important MySQL database governance commands for your reference. you can also enter help, \ h or? Get a brief explanation of the following commands.

Mysql $ # @ 62; help

Help (\ h) display command help

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.