mysql5.7版本开始创建用户需要create user
mysql5.7版本开始创建用户需要create user
5.7版本之后,直接使用:grant select on MySQL.test01 to hug@localhost; 是不行的,会报错:
Error Code: 1133. Can't find any matching row in the user table
5.7版本创建用户需要这样:
CREATE USER hug@localhost IDENTIFIED BY '123456';
grant all on mysql.* to hug@localhost;
官方文档是这样给的:
The preferred method is to use account-management statements because they are more concise and less
error-prone than manipulating the grant tables directly. All such statements are described in Section 13.7.1,
“Account Management Statements”. Direct grant table manipulation is discouraged, and is not described
here. The server is free to ignore rows that become malformed as a result of such modifications.
Another option for creating accounts is to use the GUI tool MySQL Workbench. Also, several third-party
programs offer capabilities for MySQL account administration. phpMyAdmin is one such program.
The following examples show how to use the mysql client program to set up new accounts. These
examples assume that privileges have been set up according to the defaults described in Section 2.10.4,
“Securing the Initial MySQL Accounts”. This means that to make changes, you must connect to the MySQL
server as the MySQL root user, which has the CREATE USER privilege.
First, use the mysql program to connect to the server as the MySQL root user:
shell> mysql --user=root mysql
If you have assigned a password to the root account, you must also supply a --password or -p option.
After connecting to the server as root, you can add new accounts. The following example uses CREATE
USER and GRANT statements to set up four accounts:
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
最新文章
- hash简单介绍
- FAILED java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI:hdfs:192.*
- BootStrap网格布局
- JBOSS尝鲜
- [C++] WinAES问题
- javaWeb超链接(href)请求-特殊字符处理
- javascript使用闭包模拟私有属性和方法
- 高下相倾,前后相随——iterator 与 for ... of 循环
- ES7的async/await
- Centos7.5 安装VirtualBox增强工具
- HYSBZ 2743 (树状数组) 采花
- 20155320 2016-2017-2《Java程序设计》第八周学习总结
- LeetCode[Linked List]: Remove Duplicates from Sorted List II
- 《Robot Framework自动化测试修炼宝典》道长
- 移动端地区选择mobile-select-area插件的使用方法
- android自定义Activity窗口大小(theme运用)
- I.MX6 Linux U-boot 环境变量解析
- Js操作DOM及获取浏览器高度以及宽度
- Git的使用规范(一)
- Tomcat 5常用优化和配置