* mariaDB 설치
- site : https://downloads.mariadb.org/
localhost 접속 시 mysql 1045 오류 발생! root에 권한을 주지 않았기 때문이다.
* mariaDB client
- HeidiSQL
* root 권한 주기
C:\Program Files\MariaDB 5.5\bin>mysqld
C:\Program Files\MariaDB 5.5\bin>mysql -uroot -p mysql
Enter password: ********
Welcome to the MariaDB monitor.
...
MariaDB [mysql]>
MariaDB [mysql]> GRANT ALL ON *.* TO 'root'@'localhost' IDENTIFIED BY '[비밀번호]' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> exit
Bye
C:\Program Files\MariaDB 5.5\bin>net stop mysql
MySQL 서비스를 멈춥니다...
MySQL 서비스를 잘 멈추었습니다.
C:\Program Files\MariaDB 5.5\bin>net start mysql
MySQL 서비스를 시작합니다...
MySQL 서비스가 잘 시작되었습니다.
* database 추가
MariaDB [mysql]> create database [DB명];
Query OK, 1 row affected (0.06 sec)
MariaDB [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
[DB명]
...
MariaDB [mysql]> use [DB명];
Database changed
MariaDB [[DB명];]> show tables;
Empty set (0.00 sec)
* table 추가
MariaDB [[DB명]]> CREATE TABLE t_user
-> (
-> id VARCHAR(20) NULL,
-> name VARCHAR(50) NOT NULL,
-> email VARCHAR(100) NULL,
-> reg_date DATETIME NULL,
-> PRIMARY KEY (id)
-> )
-> ;
Query OK, 0 rows affected (0.61 sec)
MariaDB [[DB명]]> show tables;