Sanya MariaDB 10.4 akan CentOS7

Magana

Fileara fayil ɗin REPO

Yi amfani da vi ko vim don gyara fayil ɗin /etc/yum.repos.d/MariaDB.repo, kwafa abubuwan da ke gaba zuwa fayil ɗin, sannan adanawa da fita.

            [mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
        

Yi aikin shigarwa kuma fara sabis ɗin

            yum -y install MariaDB-server MariaDB-client
systemctl enable mariadb
systemctl start mariadb
        

Createirƙiri mai amfani da ba da izini

Bayan an gama girkawa, za mu iya shiga MariaDB kai tsaye a kan wannan na'urar sannan mu ba da izini. Pointaya daga cikin ma'anar da ke buƙatar kulawa ta musamman don aikin ba da izini shi ne cewa ba za ku iya maye gurbin localhost ba lokacin da kuka yi amfani da% don satar duk adiresoshin, don haka idan muka yi amfani da localhost don samun damar wannan injin ɗin, dole ne mu sake yin izini. Bayan an kammala izini, dole ne a sabunta izini, in ba haka ba ba zai yi tasiri ba. Don cikakkun bayanai, don Allah koma zuwa misali mai zuwa.

            grant all privileges on *.* to 'username'@'%' identified by 'password' with grant option;
grant all privileges on *.* to 'username'@'localhost' identified by 'password' with grant option;
flush privileges;
        

Sabis na Tabbatarwa

Bayan izini, muna amfani da sabon asusu don shiga zuwa MariaDB. Idan haɗin haɗin ya yi nasara, daidaitawar ta yi nasara. Hakanan muna buƙatar amfani da wasu inji don haɗawa don gwada ko injinan da ba na gari ba zasu iya haɗuwa da MariaDB. Idan haɗin ya gaza, bincika ko an taƙaita Firewall.

            mysql -u username -p password
mysql -h x.x.x.x -u username -p password