Mysql(MariaDB)数据库常用语句

创建数据库：

create database db_xxxxxx;

新建用户：

create user 'username_xxxxxx'@'%' identified by 'xxxxxx';

授权用户到数据库：

grant all privileges on `database_xxxxxx`.* to 'username_xxxxxx'@'%';

开启远程权限：
1.修改配置文件
打开文件/etc/mysql/mariadb.conf.d/50-server.cnf，修改

#bind-address 127.0.0.1

前面加 # 注视掉这行

2.修改数据库：
登录数据库
输入命令：

# 允许所有IP连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
# 只允许指定IP连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.%' IDENTIFIED BY 'password_xxxxxx' WITH GRANT OPTION;
# 刷新生效
FLUSH PRIVILEGES;