sudo apt install mariadb-server
sudo systemctl status mariadb
一定要sudo
sudo mysql -V
sudo sql
可选参数 -u
指定用户
SHOW DATABASES;
use 'databaseName';
show tables;
DROP DATABASE 'name';
CREATE DATABASE students;
show variables like 'port';
grant all privileges on *.* to 'root'@'192.168.248.248' identified by password';
flush privileges;
去除MariaDB默认绑定的本地IP /etc/mysql/my.cnf/mariadb.conf.d/50-server.cnf 把bind-address = 127.0.0.1这一行注释掉。