[mariadb]
name = MariaDB
baseurl = https://archive.mariadb.org/mariadb-10.9.8/yum/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
=============================================================
vim /etc/yum.repos.d/mariadb.repo
========================================================
Installing:
MariaDB-backup x86_64 10.9.8-1.el7.centos mariadb 7.1 M
MariaDB-client x86_64 10.9.8-1.el7.centos mariadb 15 M
MariaDB-compat x86_64 10.9.8-1.el7.centos mariadb 2.2 M
replacing mariadb-libs.x86_64 1:5.5.68-1.el7
MariaDB-server x86_64 10.9.8-1.el7.centos mariadb 26 M
Installing for dependencies:
MariaDB-common x86_64 10.9.8-1.el7.centos mariadb 82 k
boost-program-options x86_64 1.53.0-28.el7 base 156 k
galera-4 x86_64 26.4.14-1.el7.centos mariadb 9.9 M
libaio x86_64 0.3.109-13.el7 base 24 k
libpmem x86_64 1.5.1-2.1.el7 base 59 k
lsof x86_64 4.87-6.el7 base 331 k
perl-Compress-Raw-Bzip2 x86_64 2.061-3.el7 base 32 k
perl-Compress-Raw-Zlib x86_64 1:2.061-4.el7 base 57 k
perl-DBI x86_64 1.627-4.el7 base 802 k
perl-IO-Compress noarch 2.061-2.el7 base 260 k
perl-Net-Daemon noarch 0.48-5.el7 base 51 k
perl-PlRPC noarch 0.2020-14.el7 base 36 k
pv x86_64 1.4.6-1.el7 epel 47 k
socat x86_64 1.7.3.2-2.el7 base 290 k
===============================================================================
curl -LsS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
yum install MariaDB-server MariaDB-client MariaDB-backup
---> Package MariaDB-server.x86_64 0:10.10.2-1.el7.centos will be installed
--> Processing Dependency: pv for package: MariaDB-server-10.10.2-1.el7.centos.x86_64
---> Package perl-IO-Compress.noarch 0:2.061-2.el7 will be installed
--> Processing Dependency: perl(Compress::Raw::Zlib) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
--> Processing Dependency: perl(Compress::Raw::Bzip2) >= 2.061 for package: perl-IO-Compress-2.061-2.el7.noarch
---> Package perl-Net-Daemon.noarch 0:0.48-5.el7 will be installed
--> Running transaction check
---> Package MariaDB-server.x86_64 0:10.10.2-1.el7.centos will be installed
--> Processing Dependency: pv for package: MariaDB-server-10.10.2-1.el7.centos.x86_64
---> Package perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 will be installed
---> Package perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 will be installed
--> Finished Dependency Resolution
Error: Package: MariaDB-server-10.10.2-1.el7.centos.x86_64 (mariadb-main)
Requires: pv
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
yum install zlib*
Error: Package: MariaDB-server-10.10.2-1.el7.centos.x86_64 (mariadb-main)
Requires: pv
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
yum install -y epel-release
yum install MariaDB-server MariaDB-client MariaDB-backup
====================================================
유저 생성하기
CREATE USER '아이디'@'%' IDENTIFIED BY '비밀번호';
CREATE USER 'aaa'@'%' IDENTIFIED BY 'bbb';
GRANT ALL PRIVILEGES ON *.* TO 'aaa'@'%';
GRANT ALL PRIVILEGES ON 데이터베이스.* TO '아이디'@'%';
FLUSH PRIVILEGES;
====================================================
mariadb-admin -u root -p password 'acd';
여행
윈도우서버 
