ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)

[Email protected] native]# mysql-uhive-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)
[Email protected] native]# mysql-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 4
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> use MySQL
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed
Mysql> select Host,user from user;
+-----------+------+
| Host | user |
+-----------+------+
| %         | Hive |
| %         | Root |
| 127.0.0.1 | Root |
|      localhost | |
| localhost | Root |
|      Master | |
| Master | Root |
+-----------+------+
7 Rows in Set (0.00 sec)

mysql> Delete from user where user= ';
Query OK, 2 rows Affected (0.00 sec)

Mysql> commit;
Query OK, 0 rows Affected (0.00 sec)

Mysql> select Host,user from user;
+-----------+------+
| Host | user |
+-----------+------+
| %         | Hive |
| %         | Root |
| 127.0.0.1 | Root |
| localhost | Root |
| Master | Root |
+-----------+------+
5 rows in Set (0.00 sec)

mysql> Delete from user where host= ' 127.0.0.1 ';
Query OK, 1 row Affected (0.00 sec)

mysql> Delete from user where host= ' localhost ';
Query OK, 1 row Affected (0.00 sec)

Mysql> commit;
Query OK, 0 rows Affected (0.00 sec)

Mysql> select Host,user from user;
+--------+------+
| Host | user |
+--------+------+
| %      | Hive |
| %      | Root |
| Master | Root |
+--------+------+
3 Rows in Set (0.00 sec)

Mysql> exit
Bye
[Email protected] native]# mysql-uhive-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)
[Email protected] native]# mysql-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 6
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> use MySQL
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed
mysql> Delete from user where user= ' hive ';
Query OK, 1 row Affected (0.00 sec)

Mysql> Commmit;
Error 1064 (42000): You have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' commmit ' on line 1
Mysql> commit;
Query OK, 0 rows Affected (0.00 sec)

Mysql> select Host,user from user;
+--------+------+
| Host | user |
+--------+------+
| %      | Root |
| Master | Root |
+--------+------+
2 rows in Set (0.00 sec)

Mysql> grant all privileges in hive.* to [email protected] '% ' identified by ' hive ' with GRANT option;
Query OK, 0 rows Affected (0.00 sec)

Mysql> select Host,user from user;
+--------+------+
| host   | user |
+--------+------+
|%      | hive |
|%      | root |
| master | root |
+--------+------+
3 rows in Set (0.00 sec)

Mysql> exit
Bye
[Email protected] native]# mysql-uhive-phive
ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)
[Email protected] native]# Mysql-uhive-phive-h Master
ERROR 1045 (28000): Access denied for user ' hive ' @ ' master ' (using Password:yes)
[Email protected] native]# mysql-uhive-h master-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' hive ' @ ' master ' (using Password:yes)
[Email protected] native]# mysql-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 10
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| Hive |
| MySQL |
| Test |
+--------------------+
4 rows in Set (0.00 sec)

Mysql> user Hive
;
Error 1064 (42000): You have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use near ' user Hive ' at line 1
Mysql> Show tables;
ERROR 1046 (3d000): No Database selected
Mysql> use hive;
Database changed
Mysql> Show tables;
Empty Set (0.00 sec)

mysql> use MySQL;
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed
Mysql> grant all privileges in hive.* to [email protected] ' master ' identified by ' hive ' with GRANT option;
Query OK, 0 rows Affected (0.00 sec)

Mysql> select Host,user from user;
+--------+------+
| Host | user |
+--------+------+
| %      | Hive |
| %      | Root |
| Master | Hive |
| Master | Root |
+--------+------+
4 rows in Set (0.00 sec)

Mysql> exit
Bye
[Email protected] native]# mysql-uhive-h master-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 11
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

Mysql> Show Database;
Error 1064 (42000): You have a error in your SQL syntax; check the manual, corresponds to your MySQL server Versi On for the right syntax to use near ' database ' at line 1
mysql> show databases;
+--------------------+
| database           |
+--------------------+
| information_schema |
| hive                |
| test               |
+--------------------+
3 rows in Set (0.00 sec)

Mysql> exit
Bye
[Email protected] native]# mysql-uhive-p
Enter Password:
ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)
[Email protected] native]# mysql-uroot-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 13
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> use MySQL;
Reading table information for completion of table and column names
Can turn off this feature to get a quicker startup with-a

Database changed
Mysql> grant all privileges in hive.* to [email protected] ' localhost ' identified by ' hive ' with GRANT option;
Query OK, 0 rows Affected (0.00 sec)

Mysql> exit
Bye
[Email protected] native]# mysql-uhive-p
Enter Password:
Welcome to the MySQL Monitor. Commands End With; or \g.
Your MySQL Connection ID is 14
Server version:5.1.61 Source Distribution

Copyright (c), +, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of the Oracle Corporation and/or its
Affiliates. Other names trademarks of their respective
Owners.

Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| Information_schema |
| Hive |
| Test |
+--------------------+
3 Rows in Set (0.00 sec)

Mysql> use hive;
Database changed
Mysql> Show tables;
Empty Set (0.00 sec)

Mysql>

ERROR 1045 (28000): Access denied for user ' hive ' @ ' localhost ' (using Password:yes)