Kenya MariaDB 10.4 ho CentOS7

Tšupiso

Kenya file ea REPO

Sebelisa vi kapa vim ho hlophisa file ea /etc/yum.repos.d/MariaDB.repo faele, kopitsa litaba tse latelang faeleng, ebe u li boloka le ho tsoa.

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

Etsa ts'ebetso ea ho kenya 'me u qale tšebeletso

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

Theha mosebelisi mme u lumelle

Kamora hore ts'ebetso e phethoe, re ka kena ho MariaDB ka kotloloho mochining ona ebe rea o lumella. Ntho e le 'ngoe e hlokang tlhokomelo e khethehileng bakeng sa ts'ebetso ea tumello ke hore u ke ke ua nkela sebaka sa sebaka sa hau sebaka ha u sebelisa% ho wildcard liaterese tsohle, kahoo haeba re kena mochining ona ka localhost, re tlameha ho fana ka tumello hape. Kamora hore tumello e phetheloe, tumello e tlameha ho khatholloa, ho seng joalo e ke ke ea sebetsa. Bakeng sa lintlha, ka kopo sheba mohlala o latelang.

            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;
        

Tšebeletso ea netefatso

Kamora tumello, re sebelisa ak'haonte e ncha ho kena ho MariaDB. Haeba khokahano e atlehile, sebopeho se tla atleha. Hape re hloka ho sebelisa mechini e meng ho hokela ho lekola hore na mechini eo e seng ea lehae e ka hokahana le MariaDB. Haeba khokahano e hloleha, sheba hore na firewall e thibetsoe.

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