unable to setup ambari-server using mysql server

[#1]

Hi All,

using MySql server to setup ambari server, followed below link to create a username, password, and database for ambari https://docs.hortonworks.com/HDPDocuments/Ambari-2.7.1.0/administering-ambari/content/amb_using_amba...

while ambari-setup, i got below issue: Enter Database Password (bigdata): Invalid characters in password. Use only alphanumeric or _ or - characters

i tried to change the password of mysql database, but got below issue: CREATE USER 'ambari'@'%' IDENTIFIED BY 'bigdata123456'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

I find that there is conflict in accepting the password.

Please suggest.

Thanks in Advance.

[#2 · Accepted solution]

@Amit Mishra

Are you using MySQL 8.x?

In MySQL 8.0.4, thevalidate_password plugin was re-implemented as the validate_password component.

https://dev.mysql.com/doc/refman/8.0/en/validate-password.html

So please try using the password something like "Bigdata@123456"

It depends on what kind of policy is added to your MySQL:

The policies implement increasingly strict password tests. The following descriptions refer to default parameter values, which can be modified by changing the appropriate system variables.

• LOWpolicy tests password length only. Passwords must be at least 8 characters long. To change this length, modifyvalidate_password.length.
• MEDIUMpolicy adds the conditions that passwords must contain at least 1 numeric character, 1 lowercase character, 1 uppercase character, and 1 special (nonalphanumeric) character. To change these values, modifyvalidate_password.number_count,validate_password.mixed_case_count, andvalidate_password.special_char_count.
• STRONGpolicy adds the condition that password substrings of length 4 or longer must not match words in the dictionary file, if one has been specified. To specify the dictionary file, modifyvalidate_password.dictionary_file.

.

[#3]

@Amit Mishra

Additionally the following blog will give some idea in setting the password restriction policies:

https://gsuartana.wordpress.com/2016/08/18/mysql-error-1819-hy000-your-password-does-not-satisfy-the...

Please check what is the policy set on your DB:

# mysql -u root -p
Enter Password: <DB_ROOT_PASSWORD><br>

mysql> use mysql;
mysql> SHOW VARIABLES LIKE 'validate_password%';
+--------------------------------------+--------+
| Variable_name                        | Value  |
+--------------------------------------+--------+
| validate_password_check_user_name    | OFF    |
| 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      |
+--------------------------------------+--------+<br>

.

You can release the restrictions on passwords by setting some global varialbles like:

# SET GLOBAL validate_password_length = 5;
# SET GLOBAL validate_password_number_count = 0;
# SET GLOBAL validate_password_mixed_case_count = 0;
# SET GLOBAL validate_password_special_char_count = 0;

[#4]

@Amit Mishra

Are you able to login to the DB now?

I see your new thread: https://community.hortonworks.com/questions/225768/issue-while-executing-sql-script-ambari-ddl-mysql...

So if this issue is resolved then please mark it as Closed by clicking on "Accept" button.