1. XAMPP 설치
https://www.apachefriends.org/download.html
Download XAMPP
Includes: Apache 2.4.58, MariaDB 10.4.32, PHP 8.0.30 & PEAR + SQLite 2.8.17/3.38.5 + multibyte (mbstring) support, Perl 5.34.1, ProFTPD 1.3.6, phpMyAdmin 5.2.1, OpenSSL 1.1.1w, GD 2.2.5, Freetype2 2.4.8, libpng 1.6.37, gdbm 1.8.3, zlib 1.2.11, expat 2.0.1,
www.apachefriends.org
2. MySQL 샘플 다운로드
https://dev.mysql.com/doc/index-other.html
MySQL :: Other MySQL Documentation
Other MySQL Documentation This page provides additional documentation. There's even more available on these extra pages: MySQL Server Doxygen Documentation Title HTML Online MySQL Server (latest version) View Expert Guides Example Databases Title DB Downlo
dev.mysql.com
3. 압축 풀기
- 예) c:\sample_db
4. XAMPP Control Panel로 mariaDB 실행
5. 만약 employees 샘플 DB를 설치한다면( 샘풀로 employee db를 설치하는 경우)
1) employees 샘플 DB 압축푼 폴더로 이동
2) mysql -u root -p -P3306 로 mariaDB접속
3) source employees.sql 실행 ( XAMPP for Windows 8.2.12 & MySQL 10.4 기준)
XAMPP for Windows 8.2.12
7. XAMPP Control Panel로 아파치 실행 후 phpMyAmin 실행 후 테이블 생성된 것을 확인할수 있다.
8. Open Source DB Tools
- DBeaver
DBeaver Community | Free Open-Source Database Management Tool
DBeaver Universal Database Tool DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
dbeaver.io
- HeidiSQL
HeidiSQL - MariaDB/MySQL, MSSQL, PostgreSQL, SQLite and Interbase/Firebird made easy
What is HeidiSQL? HeidiSQL is free software for people who work with databases, and aims to be intuitive to use. "Heidi" lets you connect to a variety of databases, like MariaDB, MySQL, Microsoft SQL, PostgreSQL, SQLite, Interbase and Firebird. Once you ar
www.heidisql.com
'SQL' 카테고리의 다른 글
| SQL : Sakila 데이타베이스 (0) | 2026.04.29 |
|---|
