cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tejas.sh...@frontier.in
Subject Re: mysql-setup-database ERROR 1044 access denied for user root
Date Wed, 20 Aug 2014 07:36:24 GMT
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.lists@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.sheth@frontier.in [mailto:tejas.sheth@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
>



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message