| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 | 31 |
- ubuntu
- Eclipse
- Python
- 우분투
- Android
- 구글
- mysql
- javascript
- PHP
- php7
- API
- Guide
- JS
- nodejs
- ASP
- node
- Linux
- error
- CSS
- java
- protocol
- HTTP
- install
- windows
- HTML
- Godot
- HaProxy
- 리눅스
- Godot3
- Today
- 183
- Total
- 1,189,007
목록DB&NoSQL (82)
Blue Breeze
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 0xF1656F24C..
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로 인식..
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 f..
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_t..
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 pr..
Centos7 Mariadb datadir change
CentOS, Nginx + PHP7 + MariaDB 설치 How To Change a MariaDB Data Directory to a New Location on CentOS 7 MySQL Data directory 변경하기 MariaDB(Mysql) var폴더에서 home폴더로 변경 MariaDB(MySQL)：データディレクトリの変更方法 [문제해결 일지] systemctl start mariadb 실행시 Failed to issue metho..
mysql cmd query
MySQL/MariaDB: Run SQL Queries From A Shell Prompt / Command Line MySQL dump by query How to dump result of a sql query into a file mysqldump 옵션 스키마, 데이터만 백업 mysql -u user -p PASSWORD -e 'Execute sql query' database_name mysql -uUESRNAME -pPASSWORD ..