掃二維碼與項目經(jīng)理溝通
我們在微信上24小時期待你的聲音
解答本文疑問/技術(shù)咨詢/運營咨詢/技術(shù)建議/互聯(lián)網(wǎng)交流
由于mysql已經(jīng)有閉源的趨勢,所以大部分系統(tǒng)已經(jīng)不建議使用MySQL,Mariadb是MySQL之父創(chuàng)建的一個MySQL分支項目,使用起來幾乎一模一樣。

1.centos安裝MariaDB
# yum install mariadb-server mariadb-client
2.運行數(shù)據(jù)庫
# systemctl start mariadb
3.進(jìn)入數(shù)據(jù)庫并創(chuàng)建一個production數(shù)據(jù)庫
# mysql
# MariaDB [(none)]> create database production;
# MariaDB [(none)]> use production;
# MariaDB [(none)]> flush privileges;
4.為production數(shù)據(jù)庫創(chuàng)建一個遠(yuǎn)程登陸的用戶
# MariaDB [(none)]> create user 'test1'@'%' identified by 'test1';
# MariaDB [(none)]> grant all privileges on production.* to test1 identified by 'test1';
# MariaDB [(none)]> flush privileges;
5.使用test1用戶連接數(shù)據(jù)庫
# mysql -u test1 -p
Enter password: test1
6.登陸成功!
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 214
Server version: 5.5.52-MariaDB MariaDB Server
Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> 
我們在微信上24小時期待你的聲音
解答本文疑問/技術(shù)咨詢/運營咨詢/技術(shù)建議/互聯(lián)網(wǎng)交流