Faatu MariaDB 10.4 i le CentOS7

Tusitusiga

Faʻaopopo le faila REPO

Faʻaoga vi pe vim e faʻasaʻo ai le /etc/yum.repos.d/MariaDB.repo faila, kopi le mea lea o loʻo mulimuli mai i le faila, ona sefe lea ma ulufafo.

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

Faʻatino le faʻagaioiga ma amata le tautua

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

Fausia le tagata faʻaaoga ma faʻatagaina

A maeʻa le faʻapipiʻiina, e mafai ona tatou ulufale saʻo i le MariaDB i luga o lenei masini ona faʻatagaina lea. Tasi le mea e manaʻomia faʻapitoa mo le faʻatagaina o le faʻagaioia o le le mafai ona e suia le localhost pe a e faʻaaogaina le% e faʻailoga ai tuatusi uma, o lea afai tatou te faʻaaogaina localhost e ulufale ai i lenei masini, e tatau ona tatou faʻatagaina le toe faʻatagaina. A maeʻa le faʻatagaga, e tatau ona faʻafouina faʻatagaga, a leai e le aoga. Mo auiliiliga, faʻamolemole tagaʻi i le faʻataʻitaʻiga lea.

            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;
        

Tautua Faʻamaonia

A maeʻa le faʻatagaina, matou te faʻaaogaina le teuga tupe fou e ulufale ai i MariaDB. Afai e manuia le fesoʻotaʻiga, e manuia le faʻatulagaina. E manaʻomia foi ona tatou faʻaaogaina isi masini e fesoʻotaʻi ai e faʻataʻitaʻia pe mafai e masini e leʻo nonofo i totonu ona fesoʻotaʻi ia MariaDB. Afai ua le aoga le fesoʻotaʻiga, siaki pe faʻatapulaʻa le firewall.

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