ubuntu--mysql--hive

mysql> CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation

User() 这个函数, 是取得  当前登陆的用户.

相当于问 MySQL  我是谁 的意思。

mysql> SELECT USER();
+----------------+
| USER()         |
+----------------+
| root@localhost |

1.创建数据库表和帐户，必须执行下面命令进去mysql

 #mysql -u root -p

2.在mysql中建立一个以项目名称命名的用户密码为secret（以project为例）

 mysql>CREATE USER 'project'@'localhost' IDENTIFIED BY 'secret';
注意：可能会有这个错误的：
mysql> CREATE USER 'project'@'localhost' IDENTIFIED BY 'secret';
ERROR 1227 (42000): Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
是因为直接mysql登陆进去的，请用mysql -u root -p 登录！！！

mysql> CREATE USER 'hive'@'localhost' IDENTIFIED BY 'hive';    //创建密码为hive的hive用户

grant 权限1,权限2,...权限n on 数据库名称.表名称 to 用户名@用户地址 identified by '连接口令';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'localhost' WITH GRANT OPTION;//赋予权限

mysql> flush privileges;

刷新权限表