Mariadb

Ubuntu上安装和部署 Mariadb / 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;
flush privileges;
// 或者
update mysql.user set password=password('admin123') where user='root';
flush privileges;

查看用户 SELECT user,host FROM mysql.user;

+------+-----------+
| user | host      |
+------+-----------+
| root | %         |
| root | localhost |
+------+-----------+

DROP USER 'nextcloud'@'%';
DROP DATABASE [IF EXISTS] nextcloud;