How to use MariaDB on Ubuntu 24.04|22.04|20.04|18.04

閱讀時間約 1 分鐘

登入資料庫方式,請執行以下的命令:

sudo mysql -u root -p
raw-image

建立一個新資料庫,我們建立“itslinuxfoss”資料庫為例:

CREATE DATABASE itslinuxfoss;
raw-image

為新建立的資料庫設定新的使用者名稱和密碼:

GRANT ALL PRIVILEGES ON itslinuxfoss.* TO 'itslinuxfoss'@'localhost' IDENTIFIED BY "Root";
raw-image

儲存設定並離開 MariaDB:

FLUSH PRIVILEGES;
QUIT;
raw-image


    avatar-img
    5會員
    74內容數
    記錄生活與技術的小細節
    留言0
    查看全部
    avatar-img
    發表第一個留言支持創作者!
    iBonnie_愛邦尼 的其他內容
    Install Java (OpenJDK) on Ubuntu: sudo apt update && sudo apt -y install default-jdk java -version Add repository and install DBeaver CE: curl -
    Update system packages sudo apt update && sudo apt upgrade -y Install additional dependencies sudo apt-get install wget software-properties-common
    XAUTHORITY=$HOME/.Xauthority export XAUTHORITY 啟動,解決  (base) oxooxooxoo@opopopopopop:~$ firefox
    列表看看 conda env list 一開始只有base  # conda environments: # base * /home/business/anaconda3 新增一個別的環境 conda create --name py39_env p
    sudo apt-get install libgl1-mesa-glx libegl1-mesa libxrandr2 libxrandr2 libxss1 libxcursor1 libxcomposite1 libasound2 libxi6 libxtst6 安裝版本查找: http
    Install Java (OpenJDK) on Ubuntu: sudo apt update && sudo apt -y install default-jdk java -version Add repository and install DBeaver CE: curl -
    Update system packages sudo apt update && sudo apt upgrade -y Install additional dependencies sudo apt-get install wget software-properties-common
    XAUTHORITY=$HOME/.Xauthority export XAUTHORITY 啟動,解決  (base) oxooxooxoo@opopopopopop:~$ firefox
    列表看看 conda env list 一開始只有base  # conda environments: # base * /home/business/anaconda3 新增一個別的環境 conda create --name py39_env p
    sudo apt-get install libgl1-mesa-glx libegl1-mesa libxrandr2 libxrandr2 libxss1 libxcursor1 libxcomposite1 libasound2 libxi6 libxtst6 安裝版本查找: http
    你可能也想看
    Google News 追蹤
    Thumbnail
    這個秋,Chill 嗨嗨!穿搭美美去賞楓,裝備款款去露營⋯⋯你的秋天怎麼過?秋日 To Do List 等你分享! 秋季全站徵文,我們準備了五個創作主題,參賽還有機會獲得「火烤兩用鍋」,一起來看看如何參加吧~
    Thumbnail
    11/20日NVDA即將公布最新一期的財報, 今天Sell Side的分析師, 開始調高目標價, 市場的股價也開始反應, 未來一週NVDA將重新回到美股市場的焦點, 今天我們要分析NVDA Sell Side怎麼看待這次NVDA的財報預測, 以及實際上Buy Side的倉位及操作, 從
    Thumbnail
    Hi 大家好,我是Ethan😊 相近大家都知道保濕是皮膚保養中最基本,也是最重要的一步。無論是在畫室裡長時間對著畫布,還是在旅途中面對各種氣候變化,保持皮膚的水分平衡對我來說至關重要。保濕化妝水不僅能迅速為皮膚補水,還能提升後續保養品的吸收效率。 曾經,我的保養程序簡單到只包括清潔和隨意上乳液
    Thumbnail
    (c) WordPress users How to use some open source resources Come and help charity groups in your hometown This will indirectly help the kind and disa
    Glenbrook North Alum Hoch 拥抱团队合作,支持百老汇角色 克里斯·霍赫回到芝加哥,在受艾拉妮丝·莫莉塞特启发的“锯齿状小药丸”中饰演史蒂夫·希利,吸取了很久以前的经验教训。 杰夫·阿诺德的头像 杰夫阿诺德, 补丁人员 已验证补丁人员徽章 中部时间 2023 年 4 月 6 日
    Thumbnail
    This is not only to summarise what they have done and found but also to tell your readers that there is a problem or a knowledge gap in the field.
    Thumbnail
    First, you must be wondering why there is a fake investor?
    Thumbnail
    I would like to share with you some thoughts from my recent experiences, hope this will be helpful for you. Make relationship. Make friends with
    Thumbnail
    You could follow National Wages and Productivity Commission, once you click the Region, it will show which city is covered on the right. DAILY MINIMU
    Thumbnail
    Recently, I got a chance to help a client to increase the efficiency and scheduling meeting time in attending an international conference. The confer
    Thumbnail
    Jl. H. R. Rasuna Said could be one of the congested streets in Jakarta, because many government, embassy, office is here. Recently, I’m checking 20-y
    Thumbnail
    According to Wikipedia, there are 4 ethnic groups in Singapore: 1) Chinese 74.3% 2) Malay 13.3% 3) Indian 9.1% 4) Others 3.3% ex. Caucasian In those
    Thumbnail
    While managing 30+ Facebook group, I need to decide who shall I approve to get into my group. I thought it was an easy job, but I was wrong, the most
    Thumbnail
    這個秋,Chill 嗨嗨!穿搭美美去賞楓,裝備款款去露營⋯⋯你的秋天怎麼過?秋日 To Do List 等你分享! 秋季全站徵文,我們準備了五個創作主題,參賽還有機會獲得「火烤兩用鍋」,一起來看看如何參加吧~
    Thumbnail
    11/20日NVDA即將公布最新一期的財報, 今天Sell Side的分析師, 開始調高目標價, 市場的股價也開始反應, 未來一週NVDA將重新回到美股市場的焦點, 今天我們要分析NVDA Sell Side怎麼看待這次NVDA的財報預測, 以及實際上Buy Side的倉位及操作, 從
    Thumbnail
    Hi 大家好,我是Ethan😊 相近大家都知道保濕是皮膚保養中最基本,也是最重要的一步。無論是在畫室裡長時間對著畫布,還是在旅途中面對各種氣候變化,保持皮膚的水分平衡對我來說至關重要。保濕化妝水不僅能迅速為皮膚補水,還能提升後續保養品的吸收效率。 曾經,我的保養程序簡單到只包括清潔和隨意上乳液
    Thumbnail
    (c) WordPress users How to use some open source resources Come and help charity groups in your hometown This will indirectly help the kind and disa
    Glenbrook North Alum Hoch 拥抱团队合作,支持百老汇角色 克里斯·霍赫回到芝加哥,在受艾拉妮丝·莫莉塞特启发的“锯齿状小药丸”中饰演史蒂夫·希利,吸取了很久以前的经验教训。 杰夫·阿诺德的头像 杰夫阿诺德, 补丁人员 已验证补丁人员徽章 中部时间 2023 年 4 月 6 日
    Thumbnail
    This is not only to summarise what they have done and found but also to tell your readers that there is a problem or a knowledge gap in the field.
    Thumbnail
    First, you must be wondering why there is a fake investor?
    Thumbnail
    I would like to share with you some thoughts from my recent experiences, hope this will be helpful for you. Make relationship. Make friends with
    Thumbnail
    You could follow National Wages and Productivity Commission, once you click the Region, it will show which city is covered on the right. DAILY MINIMU
    Thumbnail
    Recently, I got a chance to help a client to increase the efficiency and scheduling meeting time in attending an international conference. The confer
    Thumbnail
    Jl. H. R. Rasuna Said could be one of the congested streets in Jakarta, because many government, embassy, office is here. Recently, I’m checking 20-y
    Thumbnail
    According to Wikipedia, there are 4 ethnic groups in Singapore: 1) Chinese 74.3% 2) Malay 13.3% 3) Indian 9.1% 4) Others 3.3% ex. Caucasian In those
    Thumbnail
    While managing 30+ Facebook group, I need to decide who shall I approve to get into my group. I thought it was an easy job, but I was wrong, the most