ERROR 1819 HY000 Your password does not satisfy the current policy requirements

0 votes

Hello everyone,

I tried to create one new user in mysql. But I am getting the below error.

$ CREATE USER 'hiveuser'@'%' IDENTIFIED BY 'hivepassword';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements 
Feb 13, 2020 in Big Data Hadoop by akhtar
• 38,230 points
450 views

1 answer to this question.

0 votes

Hi@akhtar,

Before setting password in mysql, check the policy requirement using the below command.

$ SHOW VARIABLES LIKE 'validate_password%';

+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password.check_user_name    | ON     |
| validate_password.dictionary_file    |        |
| validate_password.length             | 8      |
| validate_password.mixed_case_count   | 1      |
| validate_password.number_count       | 1      |
| validate_password.policy             | MEDIUM |
| validate_password.special_char_count | 1      |
+--------------------------------------+--------+
7 rows in set (0.00 sec)

answered Feb 13, 2020 by MD
• 95,360 points

Related Questions In Big Data Hadoop

0 votes
1 answer

Hadoop Java: org.apache.hadoop.conf.Configuration does not exist error

To solve this error, add hadoop-common to ...READ MORE

answered Nov 21, 2018 in Big Data Hadoop by Omkar
• 69,210 points
4,922 views
0 votes
2 answers

Hadoop error: Input path does not exist

I was able to fix the issue. ...READ MORE

answered Jan 13, 2019 in Big Data Hadoop by Ponezhil Ramu
9,562 views
0 votes
1 answer

Hadoop MapReduce wordcount "type job is not applicable for the arguments" error

The combiner class is not required in ...READ MORE

answered Dec 19, 2018 in Big Data Hadoop by Omkar
• 69,210 points
353 views
0 votes
1 answer

Error: input path does not exist

Hey, This error looks like your job History ...READ MORE

answered Apr 30, 2019 in Big Data Hadoop by Gitika
• 65,870 points
1,816 views
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,210 points
305 views
0 votes
1 answer

How to add mysql database for Hue Query app?

Hi. To add mysql database in the config, open ...READ MORE

answered May 27, 2019 in Big Data Hadoop by Vasu
1,312 views
0 votes
1 answer

Error: Hive show tables does not display table "sqooptest" , which was imported by SQOOP

Hi, You can follow the below-given solution. Just enter ...READ MORE

answered Aug 7, 2019 in Big Data Hadoop by Gitika
• 65,870 points

edited Aug 7, 2019 by Gitika 693 views
0 votes
1 answer

Error: Couldn't properly initialize access to HDFS internals. Please update your WAL Provider to not make use of the 'asyncfs' provider.

Hi@akhtar, I think you are trying to use AsyncFSWAL for HBase-2.x as ...READ MORE

answered Apr 30, 2020 in Big Data Hadoop by MD
• 95,360 points
867 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP