MariaDB 新建用户,mariadb新建用户
新建用户:
identified by 后面是有户密码
MariaDB [(none)]> create user jack identified by 'jackdb';
Query OK, 0 rows affected (0.00 sec)
查看用户权限:
MariaDB [(none)]> show grants for jack;
+-----------------------------------------------------------------------------------------------------+
| Grants for jack@% |
+-----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'jack'@'%' IDENTIFIED BY PASSWORD '*0A7E2C93A6ADFE3F4894F4DB8D67D41B0CF995DE' |
+-----------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
用户授权
MariaDB [(none)]> grant select,insert,update,alter,delete on mysql.* to jack;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> grant all privileges on *.* to jack@localhost identified by 'jackdb';
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。