centos+mariadb练习1

centos+mariadb练习1

《mriadb crash course》

• 安装mariadb

[root@localhost ~]# yum -y install MariaDB-server MariaDB-client

• 检查安装rpm包

[root@localhost ~]# rpm -qa| grep mariadb
mariadb-libs-5.5.41-2.el7_0.x86_64
mariadb-5.5.41-2.el7_0.x86_64
mariadb-server-5.5.41-2.el7_0.x86_64

• 启动数据库

[root@localhost my.cnf.d]# systemctl start mariadb
[root@localhost my.cnf.d]# systemctl status mariadb
[root@localhost my.cnf.d]# systemctl enable mariadb

• 创建根用户密码

[root@localhost my.cnf.d]# mysqladmin -u root password ‘123qwe’

• 登陆数据库管理系统（mariadb）

[root@localhost my.cnf.d]# mysql -u root -p123qwe

• 查看有些什么数据库

MariaDB [(none)]> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| test |
+——————–+
4 rows in set (0.00 sec)

• 创建数据库crashcourse
• -

MariaDB [(none)]> create database crashcourse;
Query OK, 1 row affected (0.00 sec)

• 进入crashcourse数据库
• -

MariaDB [(none)]> use crashcourse
Database changed
MariaDB [crashcourse]>

• 使用数据库脚本为crashcourse创建6张表

MariaDB [crashcourse]> . /root/create.sql
Query OK, 0 rows affected (0.11 sec)
Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.11 sec)

Query OK, 0 rows affected (0.10 sec)

Query OK, 0 rows affected (0.26 sec) Records: 0
Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.33 sec) Records: 0
Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.36 sec) Records: 0
Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.37 sec) Records: 0
Duplicates: 0 Warnings: 0

MariaDB [crashcourse]>

• 显示创建的表

MariaDB [crashcourse]> show tables;
+———————–+
| Tables_in_crashcourse |
+———————–+
| customers |
| orderitems |
| orders |
| productnotes |
| products |
| vendors |
+———————–+
6 rows in set (0.00 sec)

• 使用脚本为6张表填写数据

MariaDB [crashcourse]> . /root/populate.sql Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.01 sec)
Query OK, 1 row affected (0.00 sec)
Query OK, 1 row affected (0.03 sec）
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec）
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.02 sec)
Query OK, 1 row affected (0.04 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
Query OK, 1 row affected (0.03 sec)
MariaDB [crashcourse]>