mariadb远程连接授权

sudo gedit /etc/mysql/mariadb.conf.d/50-server.cnf

或sudo vi /etc/mysql/mysql.conf.d/mysqlld.cnf

将bind-address = 127.0.0.1

修改为bind-address = 0.0.0.0

Deepin系统下配置MySQL的远程访问（小白入门）

查看当前登录用户

select user();

创建用户并授权：
CREATE USER 'enheng'@'localhost' IDENTIFIED BY '123456'; 
GRANT privileges ON databasename.tablename TO 'username'@'localhost' 
例子: GRANT SELECT, INSERT ON test.user TO 'pig'@'%'; 

GRANT ALL ON *.* TO 'pig'@'%'; 

查看用户：

use mysql;

select host,user,password from user;

查看用户权限：
show grants for user;