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

Source: Internet
Author: User
Tags reserved

[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)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.