| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 | 29 | 30 |
- nodejs
- node.js
- mysql
- java
- error
- Mac
- Eclipse
- windows
- ASP
- CSS
- Android
- node
- API
- protocol
- php7
- ubuntu
- HaProxy
- Godot
- Linux
- Python
- PHP
- 리눅스
- HTML
- install
- 우분투
- Godot3
- HTTP
- 구글
- javascript
- Today
- 4
- Total
- 1,207,168
목록DB&NoSQL (84)
Blue Breeze
Install Mongodb for windows scoop
Install MongoDB MongoDB Download Center Native and cross-platform MongoDB manager Studio3T, Robo3T scoop/bucket/mongodb.json Install MongoDB for widnows scoop scoop install mongodb Setup Path # MONGOPATH MONGOPATH = C:\Users\username\scoop\apps\mongodb\current PATH = %PATH%;%MONGOPATH%\bin; # bin 만 설정 PATH = %PATH%;C:\Users\username\scoop\apps\mongodb\current\bin; config C:\Users\username\scoop\..
Install Postgresql for windows scoop
https://www.postgresql.org/ Install Postgresql for windows scoop scoop install postgresql Path PGPATH = C:\Users\username\scoop\apps\postgresql\current PGDATA = %PGPATH%\bin PATH = %PATH%;%PGPATH%\bin; Start / Stop pg_ctl start pg_ctl stop pg_ctl --help PG Admin [Window+s] pgadmin user / database psql -U postgres psql (11.1) 도움말을 보려면 help를 입력하십시오. # 사용자 생성 postgres=# create user username with pa..
MariaDB 10.0.3 Install For Ubuntu 18.04
Downloads Setting up MariaDB Repositories 우분투 저장소에 10.0.1 이 기본으로 제공되므로 10.0.1을 사용하는게 좋다는 안내문구. MariaDB 10.3 저장소 키 등록 sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://ftp.harukasan.org/mariadb/repo/10.3/ubuntu bionic main' 저장소 등록 sources.list 하단에..
MySQL, MariaDB 10.2.x Upgrade After /home Restart Error
MariaDB does not start after upgrade when installation directory is inside /home Upgraded to 10.2.8 on Centos 7.4 ibdata error MariaDB /home Restart Error Upgraded to 10.2.x 이상 업그레이드시 ibdata1 권한이 mysql유저 권한이 있는데도 불구하고 Read-only file로 인식 journalctl -xe ... 7월 10 15:39:18 dev mysqld[18378]: 2018-07-10 15:39:18 140486036174976 [ERROR] InnoDB: Operating system error number 30 in a file operation. 7월..
Access denied; SUPER privilege(s) for this operation
How to grant super privilege to the user? gunzip < back.20180423.data.gz | mysql -uusername -p -f datbasename Enter Password: ERROR 1227 (42000) at line 279: Access denied; you need (at least one of) the SUPER privilege(s) for this operation failure cause 원인 파악? working server에서 mysqldump를 이용 원격지 db 백업 원격백업이 가능하기 위해서는 username@% 권한이 필요함. 백업된 log 파일에는 DEFINER=`username`@`%` 형태로 사용자@호스트 정보가 적용됨 이를..
slow-query select in table
HIGH SPEED PHP : 03-05 The MySQL Slow Query Log Slow Query Log - Percona MySQL 5.7 update after my.conf https://zetawiki.com/wiki/MySQL_슬로우_쿼리_로그_설정 vi /etc/my.conf log_output = 'TABLE' slow_query_log = 1 # 슬로우쿼리 활성화 slow_query_log_always_write_time = 1 long_query_time = 1 log_slow_verbosity = 'full' slow_query_log_use_global_control='log_slow_verbosity,long_query_time' log_slow_admin_statements..
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Access denied; you need (at least one of) the SUPER privilege(s) for this operation First attempt to migrate EC2 MySQL to Amazon RDS no going well - SUPER privileges 방금 aws MySQL rds 인스턴스를 만들고 나서, 로컬에 있는 DB… #1227 - Access denied; you need the SUPER privilege for this operation RDS 인스턴스를 생성시 Master Username 을 개별 사용자(root 가 아닌)로 생성하면 백업파일중 SET DEIFNER=`root`부분에서 에러가 발생한다. gunzip < backup.sql.gz |..