mariadb数据库使用

安装

pacman -S mariadb
- mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
- systemctl enable mariadb --now

配置

mysql

- create database type;
- create user 'type'@'%' identified by 'type';
- grant all privileges on type.* to 'type'@'%';
- flush privileges;

测试

use mysql;
show tables;
select * from user;
查看maria系统信息
systemctl status mariadb
检查对应的连接记录，
drop user 'type'@'%'
create user 'type'@'%' identified by 'localhost';
grant all privileges on type.* to 'type'@'localhost';
flush privileges;