Ku rakib MariaDB 10.4 CentOS7

Tixraac

Kudar feylka REPO

Isticmaal vi ama vim si aad wax uga beddesho feylka /etc/yum.repos.d/MariaDB.repo, nuqul ka samee waxyaabaha soo socda feylka, ka dibna kaydso oo ka bax.

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

Samee hawlgalka rakibidda oo bilow adeegga

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

Abuur isticmaale oo rukhsad

Ka dib marka rakibidu dhammaato, waxaan u geli karnaa MariaDB si toos ah mashiinkan ka dibna waanu u oggolaan karnaa. Hal dhibic oo u baahan fiiro gaar ah hawlgalka oggolaanshaha ayaa ah inaadan beddeli karin localhost markaad isticmaaleysid% si aad cinwaan uga dhigto cinwaanada oo dhan, sidaa darteed haddii aan u isticmaalno maxalliga ah helitaanka mashiinkan, waa inaan mar kale u oggolaano. Kadib marka oggolaanshaha la dhammeeyo, rukhsadaha waa in la cusbooneysiiyaa, haddii kale saameyn ma yeelanayso. Faahfaahinta, fadlan tixraac tusaalaha soo socda.

            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;
        

Adeegga Xaqiijinta

Ogolaashaha kadib, waxaan isticmaalnaa koontada cusub si aan ugu galno MariaDB.Haddii isku xirku guuleysto, qaabeynta ayaa guuleysata. Waxaan sidoo kale u baahanahay inaan isticmaalno mashiinno kale si aan ugu xirno si aan u tijaabino in mashiinada aan deegaanka ahayn ay ku xirmi karaan MariaDB. Haddii isku xirku xumaado, hubi in gidaarka gidaarku xadidan yahay.

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