일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 |
Tags
- mssql
- sqldeveloper
- 스프링부트 #springboot #project #Intellij
- install
- SpringInitializer
- oracle
- undefined
- mysql
- tcping
- Maven
- 스프링부트
- apache
- IntelliJ
- Developer
- ojdbc
- development
- postman
- HATEOAS
- springboot #controller #jsp
- restapi
- Database
- Web
- 스프링시큐리티
- springboot
- 환경변수
- 웹개발
- Oracle11g
- SpringSecurity
- RESTful
- Tomcat #SpringFramework
Archives
- Today
- Total
여백에 도장 찍기
MySQL Install on Mac OS X 본문
1. MySQL 다운로드
> https://www.mysql.com/downloads/ 접속
> MySQL Community Edition 다운로드
> MySQL Community Server 클릭
2. MySQL Client tool인 Workbench 도 추가로 설치하자,
> https://dev.mysql.com/downloads/workbench/
MySQL :: Download MySQL Workbench
Download MySQL Workbench Please report any bugs or inconsistencies you observe to our Bugs Database. Thank you for your support!
dev.mysql.com
3. 환경 변수 설정
$ echo 'export PATH=/usr/local/mysql/bin:$PATH' >> ~/.bash_profile
$ source ~/.bash_profile
4. 접속 확인
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 8.0.16 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
5. Database 생성
mysql> create database testdb;
Query OK, 1 row affected (0.01 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
| testdb |
+--------------------+
6. User 생성 및 testdb 권한 부여
mysql> create user testuser@localhost identified by 'password';
mysql> grant all privileges on testdb.* to testuser@localhost;
$ mysql -u testuser -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 8.0.16 MySQL Community Server - GPL
Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| testdb |
+--------------------+
2 rows in set (0.01 sec)
Comments