MySQL5.7中怎么创建用户并授权
这期内容当中小编将会给大家带来有关MySQL 5.7中怎么创建用户并授权,文章内容丰富且以专业的角度为大家分析和叙述,阅读完这篇文章希望大家可以有所收获。
罗甸网站建设公司成都创新互联,罗甸网站设计制作,有大型网站制作公司丰富经验。已为罗甸1000多家提供企业网站建设服务。企业网站搭建\外贸网站建设要多少钱,请找那个售后服务好的罗甸做网站的公司定做!
--创建用户
mysql> create user 'test'@'%' identified by 'System#2013';
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from mysql.user;
+-----------+-----------+
| host | user |
+-----------+-----------+
| % | test |
| localhost | jeffrey |
| localhost | mysql.sys |
| localhost | root |
+-----------+-----------+
4 rows in set (0.00 sec)
--授予对TEST数据库的操作权限
mysql> GRANT ALL ON test.* TO 'test'@'%';
Query OK, 0 rows affected (0.01 sec)
--测试新创建的用户
[root@T400-kelong ~]# mysql -utest -pSystem#2013
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.7.10-log MySQL Community Server (GPL)
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> CREATE TABLE client_firms (
-> id INT,
-> name VARCHAR(35)
-> )
-> PARTITION BY LIST (id) (
-> PARTITION r0 VALUES IN (1, 5, 9, 13, 17, 21),
-> PARTITION r1 VALUES IN (2, 6, 10, 14, 18, 22),
-> PARTITION r2 VALUES IN (3, 7, 11, 15, 19, 23),
-> PARTITION r3 VALUES IN (4, 8, 12, 16, 20, 24)
-> );
Query OK, 0 rows affected (0.15 sec)
上述就是小编为大家分享的MySQL 5.7中怎么创建用户并授权了,如果刚好有类似的疑惑,不妨参照上述分析进行理解。如果想知道更多相关知识,欢迎关注创新互联行业资讯频道。
新闻标题:MySQL5.7中怎么创建用户并授权
网站网址:http://myzitong.com/article/jcchhj.html