weizhouapache commented on issue #6873:
URL: https://github.com/apache/cloudstack/issues/6873#issuecomment-1322625181

   > We tested all with a fresh installation. By the way, using mysql 8, we 
must disable mysql's validate_password :
   > 
   > ```sql
   > set global validate_password.policy=0;
   > set global validate_password.length=1;
   > ```
   > 
   > otherwise cloudstack-setup-database printed error : We apologize for below 
error:
   > 
   > ```
   > cloudstack-setup-database  cloud:[email protected] --deploy-as=root:xxxxxx
   > ***************************************************************
   > Encountering an error when executing mysql script
   > ----------------------------------------------------------------------
   > table:
   > /usr/share/cloudstack-management/setup/create-database.sql
   > 
   > Error:
   > b"mysql: [Warning] Using a password on the command line interface can be 
insecure.\nERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: YES)\n"
   > 
   > Sql parameters:
   > {'user': 'root', 'passwd': 'xxxxxx', 'port': 3306, 'host': '127.0.0.1'}
   > ----------------------------------------------------------------------
   >             
   > ***************************************************************
   > Please run:
   > 
   >     cloudstack-setup-databases -h
   > 
   > for full help
   > ```
   
   @hooklee2000 
   can you file a new github issue for this ?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to