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

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

$ 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 = MariaDBbaseurl = https://mirror.yongbok.net/mariadb/yum/10.5/centos7-amd64gpgkey=https://mirror.yongbok.net/mariadb/yum/RPM-GPG-KEY-MariaD..

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

. MariaDB.repo setting$ sudo vi /etc/yum.repos.d/MariaDB.repo----------------------------------------------------------------[mariadb]name = MariaDBbaseurl = https://yum.mariadb.org/10.4/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDBgpgcheck=1---------------------------------------------------------------- 2. MariaDB Install$ sudo yum install MariaDB-server MariaDB-client 3. M..

$ sudo apt install mariadb-server $ sudo mysql_secure_installation

$ curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash

CentOS7 + MariaDB 10.4 1. yum installhttps://zetawiki.com/wiki/CentOS7_MariaDB_설치 CentOS7 MariaDB 설치 - 제타위키다른 뜻에 대해서는 CentOS6 MariaDB 설치 문서를 참조하십시오. 다른 뜻에 대해서는 우분투 MariaDB 설치 문서를 참조하십시오. CentOS 7.6에서 테스트하였습니다. 리눅스 MariaDB 설치 CentOS MariaDB 설치 2 rezetawiki.comorhttps://mariadb.com/kb/en/yum/ 2. source install- MariaDB 10.4 download https://downloads.mariadb.org/mariadb/10.4.13/ > mariadb-10.4.13..

MariaDB 10.3 login error $ mariadb -u root -pEnter 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-log..

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