差别

这里会显示出您选择的修订版和当前版本之间的差别。

--- it:database:mariadb [2022-08-24 04:21] – goldentianya
+++ it:database:mariadb [2022-08-24 18:06] (当前版本) – goldentianya
@@ 行 1: / 行 1: @@
 ====== Mariadb ======
 [[https://www.jianshu.com/p/d7e292e96694|Ubuntu上安装和部署 Mariadb ]] / [[https://www.adminer.org/|adminer 管理工具]]
+[[https://adminer.simperator.com/adminer|我的数据库]]
 安装
   apt install mariadb-server
+  vim /etc/mysql/mariadb.conf.d/50-server.cnf
+本地连接
+  mysql -u root -p
 修改密码
-  GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
+<code | download>
-  flush privileges;
+GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'admin123' WITH GRANT OPTION;
+flush privileges;
+// 或者
+update mysql.user set password=password('admin123') where user='root';
+flush privileges;
+</code>
+查看用户 <color #ff7f27>''%%SELECT user,host FROM mysql.user;%%''</color>
+<code | download>
++------+-----------+
+| user | host      |
++------+-----------+
+| root | %         |
+| root | localhost |
++------+-----------+
+</code>
+<code>
+DROP USER 'nextcloud'@'%';
+DROP DATABASE nextcloud;
+flush privileges;
+</code>

it/database/mariadb.1661314877.txt.gz · 最后更改: 2022-08-24 04:21 由 goldentianya

回到顶部