It is giving following error with identified by clause. "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by "password'' at line 1"
Thanks Tejas From: ilya musayev <ilya.mailing.li...@gmail.com> To: users@cloudstack.apache.org Date: 08/20/2014 12:13 PM Subject: Re: mysql-setup-database ERROR 1044 access denied for user root 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 >
