:::: gangserver's blog ::::

1. Install MariaDB server $ sudo apt install mariadb-server user@raspberrypi:~ $ sudo apt install mariadb-server 패키지 목록을 읽는 중입니다... 완료 의존성 트리를 만드는 중입니다... 완료 상태 정보를 읽는 중입니다... 완료 다음 새 패키지를 설치할 것입니다: mariadb-server 0개 업그레이드, 1개 새로 설치, 0개 제거 및 0개 업그레이드 안 함. 35.5 k바이트 아카이브를 받아야 합니다. 이 작업 후 73.7 k바이트의 디스크 공간을 더 사용하게 됩니다. 받기:1 http://raspbian.raspberrypi.org/raspbian bullseye/main armhf mariadb-serve..

1. 방법1 GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%' IDENTIFIED BY '비밀번호'; FLUSH PRIVILEGES; 2. 방법2 INSERT INTO mysql.user (host,user,authentication_string,ssl_cipher, x509_issuer, x509_subject) VALUES ('%','아이디',password('패스워드'),'','',''); GRANT ALL PRIVILEGES ON *.* TO '아이디'@'%'; FLUSH PRIVILEGES;

$ sudo mariadb -u root 로 비번없이 root 로그인 가능 $ sudo mysql_secure_installation 명령으로 root 비번 변경 후 사용 ---------------------------------------------------------------------------------------------------------------------- user@localhost:~$ sudo mysql_secure_installation [sudo] user의 암호: NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STE..

$ sudo apt-get install software-properties-common dirmngr apt-transport-https $ sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' $ sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] https://mirror.yongbok.net/mariadb/repo/10.5/ubuntu focal main' $ sudo apt update $ sudo apt install mariadb-server

1. /etc/yum.repos.d/MariaDB.repo file create ----------------------------------------------------------------------------------------------------- # MariaDB 10.5 CentOS repository list - created 2021-04-15 02:51 UTC # https://mariadb.org/download/ [mariadb] name = MariaDB baseurl = https://mirror.yongbok.net/mariadb/yum/10.5/centos7-amd64 gpgkey=https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY..

1. Config server.cnf add $ sudo vi /etc/my.cnf.d/server.cnf ---------------------------------------------------- [mariadb] lower_case_table_names=1 ---------------------------------------------------- 2. MariaDB service restart $ sudo systemctl restart mariadb

$ sudo apt install mariadb-server $ sudo mysql_secure_installation

MariaDB 10.3 login error $ mariadb -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' $ sudo mariadb -u root -p (or sudo mysql -u root -p) after login MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PassW0rd'; Query OK, 0 rows affected (0.001 sec) MariaDB [(none)]> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.001 sec) re-..

$ 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] http://mirror.nodesdirect.com/mariadb/repo/10.4/ubuntu bionic main' $ sudo apt update $ sudo apt install mariadb-server $ sudo vi /etc/apt/sources.list.d/MariaDB.list # MariaDB 10.4 repository list ..

MariaDB 10.4 yum repository $ sudo vi /etc/yum.repos.d/MariaDB.repo ---------------------------------------------------------------------------------------- # MariaDB 10.4 CentOS repository list - created 2019-11-20 13:09 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.4/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY..