这是本文档旧的修订版!


Mariadb

Ubuntu上安装和部署 Mariadb / adminer 管理工具

安装

apt install mariadb-server

本地连接

mysql -u root -p

修改密码

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;

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

download

+------+-----------+
| user | host      |
+------+-----------+
| root | %         |
| root | localhost |
+------+-----------+
it/database/mariadb.1661316237.txt.gz · 最后更改: 2022-08-24 04:43 由 goldentianya
回到顶部
CC Attribution-Share Alike 4.0 International
Driven by DokuWiki Recent changes RSS feed Valid CSS Valid XHTML 1.0