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;

====================================================
mariadb-admin -u root -p password 'acd';

트위터 트위터 페이스북 페이스북 카카오톡 카카오톡
기사입력: 2022/12/02 [02:21]  최종편집: ⓒ iwav