Database
[MariaDB] IP/Port 이용한 접속 및 DB생성
이반&핫버드
2020. 2. 17. 16:59
IP/Port를 이용한 접속
- mysql -h [IP] -p [Port] -u [유저] -p
C:\DevCenter\MariaDB\mariadb-10.5.1-winx64\bin>mysql -h 172.16.2.6 -P 8087 -u root -p
Enter password: ******
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 46
Server version: 10.0.38-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
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)]>
Database 생성
MariaDB [(none)]> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.001 sec)
MariaDB [(none)]> create database PerfONEw;
Query OK, 1 row affected (0.001 sec)
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| PerfONEw |
| information_schema |
| mysql |
| performance_schema |
+--------------------+
4 rows in set (0.001 sec)