E hoʻouka iā MariaDB 10.4 ma CentOS7

Kākauʻōlelo

Hoʻohui i ka faile REPO

E hoʻohana iā vi a i ʻole vim e hoʻoponopono i ka /etc/yum.repos.d/MariaDB.repo faila, kope i kēia ʻike i ka faile, a laila mālama a puka.

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

Hana i ka hana hoʻonoho a hoʻomaka i ka lawelawe

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

Hana i ka mea hoʻohana a ʻae ʻia

Ma hope o ka pau ʻana o ka hoʻouka ʻana, hiki iā mākou ke haʻalele pololei iā MariaDB ma kēia mīkini a laila ʻae iā ia. ʻO kahi kiko e pono ai ka nānā kūikawā no ka hana ʻae ʻaʻole hiki iā ʻoe ke pani i ka localhost ke hoʻohana ʻoe i% e wildcard i nā helu āpau, no laila inā mākou e hoʻohana i localhost e kiʻi i kēia mīkini, pono mākou e ʻae hou. Ma hope o ka pau ʻana o ka ʻae ʻana, pono e hōʻoluʻolu i nā ʻae, i ʻole e holo pono ia. No nā kikoʻī, e ʻoluʻolu e nānā i kēia hiʻohiʻona.

            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;
        

Lawelawe hōʻoiaʻiʻo

Ma hope o ka ʻae ʻana, hoʻohana mākou i ka moʻokāki hou e haʻalele iā MariaDB. Inā kūleʻa ka pili, e kūleʻa ka hoʻonohonoho ʻana. Pono mākou e hoʻohana i nā mīkini ʻē aʻe e hoʻopili ai e hoʻāʻo inā hiki i nā mīkini kūloko ʻole ke hoʻohui iā MariaDB. Inā kūleʻa ka pilina, e nānā inā kapu ʻia ka pale ahi.

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