Hi Guyz, The issue is Resolved, I have applied following command in database server.
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root'; FLUSH PRIVILEGES; And I have removed password from cloud-setup-database statement (--deploy-as=root:<password>). Thanks, Tejas From: Venkata Suneel Babu Mallela <sunee...@simplifydc.com> To: "users@cloudstack.apache.org" <users@cloudstack.apache.org> Date: 08/20/2014 11:50 AM Subject: RE: mysql-setup-database ERROR 1044 access denied for user root 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
