Blue Breeze

Access denied; you need (at least one of) the 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 백업 원격백업이 가능하기..

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..

Performance of non-blocking writes to files via PHP What is Apache log4php? - Apache log4php $fp = fopen($file, 'a+'); while($count > $loop) { fwrite($fp, $text); } fclose($fp); ... ... ... 전체 요청이 진행되는 동안 파일을 열어두고 다음 로그 이벤트가 발생할 때 flock으로 풀고 다시 묶는다. $fp = fopen($file, 'a+'); flock($fp, LOCK_UN); while($count > $loop) { if (flock($fp, LOCK_EX)) { fwrite($fp, $text); } flock($fp, LOCK_UN); } fclos..

iPhone 5 CSS media query CSS Media Queries for iPads & iPhones /* iPhone < 5: */ @media screen and (device-aspect-ratio: 2/3) { } /* iPhone 5: */ @media screen and (device-aspect-ratio: 40/71) { } /* iPhone 6: */ @media screen and (device-aspect-ratio: 375/667) { } /* iPhone 6 Plus: */ @media screen and (device-aspect-ratio: 16/9) { } /* iPad: */ @media screen and (device-aspect-ratio: 3/4) { }

리눅스의 시작 프로그램 개념 정리 시작프로그램 설정 - 우분투 한국 커뮤니티 포럼 우분투 리눅스에서 직접 시작메뉴에 프로그램 추가하기 How to Change An Application Icon in Ubuntu Unity [Tips] 어플리케이션 프로그램 위치 : /usr/share/applications 로컬 여플리케이션 프로그램 위치 : .local/share/applications Android Studio [Desktop Entry] Type=Application Name=Android Studio Exec=/opt/android-studio/bin/studio.sh Icon=/opt/android-studoi/bin/studio.png Categories=Application;

Access denied; 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 ..

Ctrl-s hang terminal emulator? # Ctrl + s : 스크롤락 설정 # Ctrl + q : 해제 # ~/.bash_profile or ~/.bashrc stty -ixon

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 method call: No such file or directory. 에러 MariaDB 설치 yum install mariadb-server mariadb -y systemctl status mariadb systemctl enable mariadb PHP db 관련..

How to Switch between Multiple PHP Version on Ubuntu 저장소 등록 apt-get install -y python-software-properties add-apt-repository -y ppa:ondrej/php apt-get update -y 7.2 설치 sudo apt-cache search php7.2 sudo apt-get install php7.2 php7.2 libapache2-mod-php7.2 libphp7.2-embed php7.2-bcmath php7.2-bz2 php7.2-cgi php7.2-cli php7.2-common php7.2-curl php7.2-dba php7.2-dev php7.2-enchant php7.2-fpm php7.2-..

Importing code from an existing project Command Line Git Import # Local 설정 git init git add --all git commit -m "Initial Commit" # 원격저장소에 Push git remote add origin https://username@your.bitbucket.domain:7999/yourproject/repo.git git push -u origin master