1

create user [username];

1

drop user if exists [username];

1

CREATE USER foo2@test IDENTIFIED BY 'mariadb';

1
2
3
4
5

GRANT ALL PRIVILEGES ON [databaseName].* TO '[username]'@'%' ;



flush privileges;  # 刷新

1
2

# 查询端口
show global variables like 'port';