I. Database services
1. What is a database
Db,database
Databases: Data collections that are organized and placed into memory according to a data model
Dbms,database Management System
Database management System: Large-scale service software for manipulating and managing databases
Dbs,database System
Database system: Db+dbms, which refers to a computer system with database and integrated database management software.
It is dedicated to the storage of data, commonly used in the production environment including: Banking financial shopping sites, forums and so on.
2. Build the data server: hardware, OS, application software
3. Common data Service vendors and software:
Oracle:oracle Database, MYSQL
Microsoft:sql Server, Access
Ibm:db2
Sybase:sybase
University of California, Berkeley: PostgreSQL
Among them, the following categories are categorized as follows:
Commercial software: Oracle SQL SERVER DB2 Sybase access
Open source software: PostgreSQL MySQL
Cross-platform: Oracle DB2 Sybase PostgreSQL MySQL
No cross-platform: SQL SERVER Access
Open source and cross platform: PostgreSQL MySQL
4. About MySQL
MySQL has become one of the most popular database management systems in the world. Whether it's for small-scale development projects or for building claims-critical sites, MySQL proves itself to be a stable, reliable, fast, and trustworthy system capable of any data storage business.
--------------------------------------------------------------------------------------------------------------- --
Second, install and use MySQL
1. Installation
Yum-y install mysql-server MySQL
Service mysqld Start
Or
Rpm-q mysql-server MySQL Mysql-devel
Rpm-e--nodeps mysql-server MySQL mysql-devel
Mv/etc/my.cnf/etc/my.cnf.bak
TAR-XVF Mysql-5.6.15-1.el6.x86_64.rpm-bundle.tar
RPM-UVH mysql-*.rpm
Rpm-qa | Grep-i--color MySQL
Service MySQL Start|stop|status
Find/-name "MY.CNF"
Cp/usr/share/mysql/my-default.cnf/etc/my.cnf
2. Service knowledge
Port number: 3306
Process Name: mysqld
Process owner: MySQL
Data Transfer Protocol: TCP
Master configuration file/etc/my.cnf
Database Directory/var/lib/mysql/
SQL Structured Query Language each SQL statement is to be; End command does not distinguish between uppercase and lowercase letters
\c terminating execution of SQL statements
\G display data in a line break
Srvice MySQL Start
------------------------------------------------------------
This article is from the "Zhengerniu" blog, make sure to keep this source http://liufu1103.blog.51cto.com/9120722/1656825
Ii. What is a database