리눅스로 maria db 접속하기

mariadb 부팅시 자동 시작 되도록 하려면 

[root@localhost ~]# systemctl enable mariadb

mysql 을 root 계정으로 접속

[root@localhost ~]# mysql -u root -p
Enter password:

패스워드를 입력하면 

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.1.48-MariaDB MariaDB Server

 

이렇게 mariadb 로 들어가진다 .

---

#mariadb 

 

mariadb 에 있는 database 보기

MariaDB[(none)]> show databases;

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| orcl               |
| performance_schema |
+--------------------+
4 rows in set (0.01 sec)

orcl 데이터베이스를 사용하겠다고 지정

MariaDB [(none)]> use orcl
Database changed

데이터베이스가 orcl로 변경되고 여기서 mysql을 사용하면 된다.

MariaDB [orcl]> select * from emp;
+-------+--------+-----------+------+------------+------+------+--------+
| empno | Ename  | Job       | Mgr  | Hiredate   | Sal  | Comm | Deptno |
+-------+--------+-----------+------+------------+------+------+--------+
|  7839 | KING   | PRESIDENT | NULL | 1981-11-17 | 5000 | NULL |     10 |
|  7698 | BLAKE  | MANAGER   | 7839 | 1981-05-01 | 2850 | NULL |     30 |
|  7782 | CLARK  | MANAGER   | 7839 | 1981-05-09 | 2450 | NULL |     10 |
|  7566 | JONES  | MANAGER   | 7839 | 1981-04-01 | 2975 | NULL |     20 |
|  7654 | MARTIN | SALESMAN  | 7698 | 1981-09-10 | 1250 | 1400 |     30 |
|  7844 | TURNER | SALESMAN  | 7698 | 1981-08-21 | 1500 |    0 |     30 |
|  7900 | JAMES  | CLERK     | 7698 | 1981-12-11 |  950 | NULL |     30 |
|  7521 | WARD   | SALESMAN  | 7698 | 1981-02-23 | 1250 |  500 |     30 |
|  7902 | FORD   | ANALYST   | 7566 | 1981-12-11 | 3000 | NULL |     20 |
|  7369 | SMITH  | CLERK     | 7902 | 1980-12-09 |  800 | NULL |     20 |
|  7788 | SCOTT  | ANALYST   | 7566 | 1982-12-22 | 3000 | NULL |     20 |
|  7876 | ADAMS  | CLERK     | 7788 | 1983-01-15 | 1100 | NULL |     20 |
|  7934 | MILLER | CLERK     | 7782 | 1982-01-11 | 1300 | NULL |     10 |
+-------+--------+-----------+------+------------+------+------+--------+
13 rows in set (0.00 sec)

 

 

maria db 빠져나오기

exit 혹은 ctrl+C