반응형

db/mysql 51

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 하단에..

db/mysql 2018.07.20

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

db/mysql 2018.07.14

Access denied; SUPER privilege(s) for this operation

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 백업 원격백업이 가능하기..

db/mysql 2018.04.23

Access denied; you need (at least one of) the SUPER privilege(s) for this operation

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

db/mysql 2018.04.02

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

db/mysql 2018.03.07

centos7 mysql5.7

How to Install Latest MySQL 5.7.9 on RHEL/CentOS 7/6/5 and Fedora 23/22/21 Centos 7 - 데이타베이스(MySql) 설치 Chapter 1 Installing MySQL on Linux Using the MySQL Yum Repository setting mysql root password in CentOS 7 mysql root 비번 분실 MySQL 5.7.7 - Centos 7 el7 - Access denied MySQL 5.7.9 릴리즈 변화된 root 비밀번호 변경하기 MySQL 5.7 설치시 알아둬야 할 사항 MySQL 5.7 Reference Manual / Security / Security Plugins / The Passwo..

db/mysql 2017.02.24
반응형