mariadb 10

운영자

| 기사입력 2022/12/02 [02:21]

mariadb 10

운영자

ㅣ 기사입력

2022/12/02 [02:21]

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;

트위터

페이스북

카카오톡