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


    4會員
    73內容數
    記錄生活與技術的小細節
    留言0
    查看全部
    發表第一個留言支持創作者!
    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
    美國總統大選只剩下三天, 我們觀察一整週民調與金融市場的變化(包含賭局), 到本週五下午3:00前為止, 誰是美國總統幾乎大概可以猜到60-70%的機率, 本篇文章就是以大選結局為主軸來討論近期甚至到未來四年美股可能的改變
    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
    美國總統大選只剩下三天, 我們觀察一整週民調與金融市場的變化(包含賭局), 到本週五下午3:00前為止, 誰是美國總統幾乎大概可以猜到60-70%的機率, 本篇文章就是以大選結局為主軸來討論近期甚至到未來四年美股可能的改變
    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