av激情亚洲男人的天堂国语,日韩欧美精品一中文字幕,无码av一区二区三区无码,国产又色又爽又刺激的a片,国产又色又爽又刺激的a片

CentOS安裝MariaDB數(shù)據(jù)庫(MySQL的分支)

由于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)]>

分享文章:CentOS安裝MariaDB數(shù)據(jù)庫(MySQL的分支)
本文地址:http://uogjgqi.cn/article/coocojo.html
掃二維碼與項目經(jīng)理溝通

我們在微信上24小時期待你的聲音

解答本文疑問/技術(shù)咨詢/運營咨詢/技術(shù)建議/互聯(lián)網(wǎng)交流