中文 
liwl
deepin
2022-05-13 00:17 deepin 这不是2条命令的事情？
Reply Like 0 View the author
All Replies
#1
YellowRabbit
deepin
2022-05-13 00:23 deepin docker run -d \
--name=mariadb \
-e PUID=1000 \
-e PGID=1000 \
-e MYSQL_ROOT_PASSWORD=yourpassword \
-e TZ=Asia/Shanghai \
-p 3306:3306 \
-v db_config:/config \
--restart unless-stopped \
linuxserver/mariadb:10.5
用docker就好啦，方便快捷
Reply Like 0 View the author
learces
deepin
2022-05-13 00:57 deepin YellowRabbit：
docker run -d \
--name=mariadb \
-e PUID=1000 \
-e PGID=1000 \
-e MYSQL_ROOT_PASSWORD=yourpassword \
-e TZ=Asia/Shanghai \
-p 3306:3306 \
-v db_config:/config \
--restart unless-stopped \
linuxserver/mariadb:10.5
用docker就好啦，方便快捷
能不能使用spring连啊？
Reply Like 0 View the author
learces deepin
2022-05-13 00:57 deepin liwl：
这不是2条命令的事情？
老板，求你了，快告诉了😭
Reply Like 0 View the author
YellowRabbit deepin
2022-05-13 01:03 deepin learces：
能不能使用spring连啊？
可以呀，端口3306
Reply Like 0 View the author
learces deepin
2022-05-13 01:16 deepin YellowRabbit：
可以呀，端口3306
哥，不敢装啊，docker感觉安装更复杂，我也没学过docker啊，我只是一个前端，临时要用一下数据库，以前在Windows上面挺方便的，到了Linux上面完全就傻了，没有图形化安装界面，也没有安装教程，完全一脸懵逼。
Reply Like 0 View the author
deepinuser17
deepin
2022-05-13 06:57 deepin 安装mariadb:
sudo apt update
sudo apt install mariadb-server mariadb-clientmariadb安装后即自动完成初始化，并开始运行。
$ systemctl status mariadb
● mariadb.service - MariaDB 10.3.29 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: active (running) since Thu 2022-05-12 07:48:59 PDT; 7min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 3091297 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3091299 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3091301 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environmen
Process: 3091379 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3091381 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 3091348 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 31 (limit: 9334)
Memory: 69.2M
CGroup: /system.slice/mariadb.service
└─3091348 /usr/sbin/mysqld
默认可以用root账户在本地连接:
$ sudo mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 52
Server version: 10.3.29-MariaDB-0+deb10u1 Debian 20.2.2
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
手动开启和关闭mariadb的命令:
sudo systemctl start mariadb
sudo systemctl stop mariadb
在mariadb初始运行之后，需要设定口令，创建新用户(非root), 设定权限。
Reply Like 1 View the author
learces deepin
2022-05-13 07:01 deepin 写完了心态保证，居然有敏感词，只有穿图上来了，链接只能自己敲了
Reply Like 5 View the author
learces deepin
2022-05-13 07:03 deepin learces：
写完了心态保证，居然有敏感词，只有穿图上来了，链接只能自己敲了
另外对于初次使用linux的deepiner，推荐使用DBeaver，社区版完全够了
Reply Like 0 View the author
Please sign in first
Popular Ranking
Change
Linyaps stop working after update Popular Events
More
被mariadb整破防了，安装了初始化配置搞不来，安装网上的教程也进不去，数据库服务也启动不起来，开在activating阶段，停也停不掉
Mariadb有没有标准的安装流程啊，要可以用密码登录的。
破防了😭😭😭
求救！！！