Mariadb [天涯的知库]

本页面只读。您可以查看源文件，但不能更改它。如果您觉得这是系统错误，请联系管理员。

====== 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

修改密码
<code | download>
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.txt · 最后更改: 2022-08-24 18:06 由 goldentianya

回到顶部