my 2 cents Bad practice to do "%". Add identified by clause.
"GRANT ALL PRIVILEGES ON *.* TO 'root'@'30.34.12.12' WITH GRANT OPTION identified by "mypassword";" On 8/19/14, 11:31 PM, Venkata Suneel Babu Mallela wrote:
Hi Tejas, Execute the below mysql command on DB server before executing "cloudstack-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password>" on management server, "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;" Thank you, Suneel Mallela -----Original Message----- From: tejas.sh...@frontier.in [mailto:tejas.sh...@frontier.in] Sent: Tuesday, August 19, 2014 6:19 PM To: CloudStack-Users Subject: mysql-setup-database ERROR 1044 access denied for user root Hi, I have installed database in septate node (RHEL 6.3) and all the configuration steps have been performed as per installation guide. I have also installed cloudstack management server (RHEL 6.3) and all the configuration. I have disabled firewall in RHEL. When i execute cloudstack-setup-databases cloud:<dbpassword>@localhost --deploy-as=root:<password> it gives error. Kindly suggest the fix. appreciate your help in advance. Mysql user name:cloud [ OK ] Mysql user password:****** [ OK ] Mysql server ip:10.0.1.70 [ OK ] Mysql server port:3306 [ OK ] Mysql root user name:root [ OK ] Mysql root user password:****** [ OK ] Checking Cloud database files ... [ OK ] Checking local machine hostname ... [ OK ] Checking SELinux setup ... [ OK ] Detected local IP address as 10.0.1.72, will use as cluster management server node IP[ OK ] Preparing /etc/cloudstack/management/db.properties [ OK ] Applying /usr/share/cloudstack-management/setup/create-database.sql We apologize for below error: *************************************************************** Encountering an error when executing mysql script ---------------------------------------------------------------------- table: /usr/share/cloudstack-management/setup/create-database.sql Error: ERROR 1045 (28000): Access denied for user 'root'@'cssrv2.cloudfront.com' (using password: YES) Sql parameters: {'passwd': 'P@ssw0rd', 'host': '10.0.1.70', 'user': 'root', 'port': 3306} ---------------------------------------------------------------------- *************************************************************** Thanks Tejas
