📝 1일차
업무에만 쓰던 오라클이 아닌,
mysql 계열 mariaDB를 써보니까 재밌었다
MariaDB [mysql]> create database project;
MariaDB [mysql]> create user project identified by '123456(비밀번호)';
👉 이름이 'user'이고 비밀번호가 '123456'인 사용자 추가
MariaDB [mysql]> grant all privileges on project.* to project@'%';
👉 'project'란 DB의 모든 테이블에 대한 권한을 사용자 'project'에게 부여 (DB명과 사용자명을 동일하게 해놓으니 헷갈리네 ;)
MariaDB [mysql]> exit
C:\Program Files\MariaDB 10.6\bin>mysql -u project -p
👉 'project'에게 root 권한 부여
Enter password: ******
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.6.4-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use project;
Database changed
👉 사용할 데이터베이스를 'use [DATABASE명]' 해줘야 한다는 거
MariaDB [project]> create table board1 (
-> seq int not null primary key auto_increment,
-> subject varchar(150) not null,
-> writer varchar(12) not null,
-> mail varchar(50),
-> password varchar(12) not null,
-> content varchar(2000),
-> hit int not null,
-> wip varchar(15) not null,
-> wdate datetime not null
-> );
Query OK, 0 rows affected (0.108 sec)
MariaDB [project]> insert into board1 values (0, '제목', '이름', 'test@test.com', '1234', '내용', 0, '000.000.000.000', now());
Query OK, 1 row affected (0.015 sec)
MariaDB [project]> select * from board1;
+-----+---------+--------+---------------+----------+---------+-----+-----------------+--- ------------------+
| seq | subject | writer | mail | password | content | hit | wip | wd ate |
+-----+---------+--------+---------------+----------+---------+-----+-----------------+--- ------------------+
| 1 | 제목 | 이름 | test@test.com | 1234 | 내용 | 0 | 000.000.000.000 | 20 21-08-10 20:26:57 |
+-----+---------+--------+---------------+----------+---------+-----+-----------------+--- ------------------+
1 row in set (0.011 sec)