Shulou(Shulou.com)06/01 Report--

1. Install Mysql database

Yum install mysql mysql-server mysql-devel-y

2. Start the Mysql service

Service mysqld start

3. Set the Mysql service boot to start automatically.

Chkconfig mysqld on

4. Change the password of the Mysql administrator (note: not the password of the Centos system)

Mysqladmin-u root password 'asd1benchmark'

5. Log in to Mysql using root administrator

Mysql-u root-p

6. Create a database abc (remember to end with ";" after the command)

Create database abc

7. Use the abc database, and create a table table named table1 on the database. After creating the display talbe1 structure, the requirements are as follows:

Use abc

Create table table1 (

RID int AUTO_INCREMENT

Type varchar (10)

Price Decimal (6Pol 2)

Checkln char (1)

PRIMARY KEY (RID))

8. Back up the abc database. Back up the abc database to / var/databak/abc.sql at 1: 00 a.m. every Friday.

Crontab-e opens the backup list

0 1 * * 5 mysqldump-uroot-Pasd1 dogs! Abc > / var/databak/abc.sql

9. Restart the Mysql service

Service mysqld restart

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.