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:@localhost
--deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
Essentially are you able to login to db server from mgmt server using root via
MySQL command and speechify -h db server name?
MySQL.user is the table which controls this.
Sent from my iPhone
> On 19 Aug 2014, at 6:30 pm, tejas.sh...@frontier.in wrote:
>
> 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:@localhost
> --deploy-as=root: 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
>
Re: mysql-setup-database ERROR 1044 access denied for user root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e. cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
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:@localhost
--deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
Hi,
I can login to remote database server using "mysql -h -u
root" command but if i type "-p" option (mysql -h -u root -p)
then i am not able to connect. but i am able to connect to db server with
"-p" option if i log in to Database server and use -h localhost.
When i type show databases it show following databases in DB server.
++
| Database |
++
| information_schema |
| cloud |
| mysql |
++
3 rows in set (0.00 sec)
Thanks
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 02:11 AM
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e.
cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
> 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:@localhost
> --deploy-as=root: 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
>
>
Re: mysql-setup-database ERROR 1044 access denied for user root
Tejas,
You'll need to check if the root user has permissions to connect from any
server (%) and its permissions on cloud database.
Regards,
Sunil Pichamuthu
IT Consultant
Frontier Business Systems
Ph.: +91-9844844216
"Sure it's a big job; but I don't know anyone Who can do it better than I
can. - John F. Kennedy"
From: tejas.sh...@frontier.in
To: users@cloudstack.apache.org
Date: 20-08-2014 09:51
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Hi,
I can login to remote database server using "mysql -h -u
root" command but if i type "-p" option (mysql -h -u root -p)
then i am not able to connect. but i am able to connect to db server with
"-p" option if i log in to Database server and use -h localhost.
When i type show databases it show following databases in DB server.
++
| Database |
++
| information_schema |
| cloud |
| mysql |
++
3 rows in set (0.00 sec)
Thanks
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 02:11 AM
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e.
cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
> 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:@localhost
> --deploy-as=root: 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
>
>
Re: mysql-setup-database ERROR 1044 access denied for user root
already checked but not working!!
Thanks
Tejas
From: sunil.pichamu...@frontier.in
To: users@cloudstack.apache.org
Date: 08/20/2014 09:54 AM
Subject:Re: mysql-setup-database ERROR 1044 access denied for user
root
Tejas,
You'll need to check if the root user has permissions to connect from any
server (%) and its permissions on cloud database.
Regards,
Sunil Pichamuthu
IT Consultant
Frontier Business Systems
Ph.: +91-9844844216
"Sure it's a big job; but I don't know anyone Who can do it better than I
can. - John F. Kennedy"
From: tejas.sh...@frontier.in
To: users@cloudstack.apache.org
Date: 20-08-2014 09:51
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Hi,
I can login to remote database server using "mysql -h -u
root" command but if i type "-p" option (mysql -h -u root -p)
then i am not able to connect. but i am able to connect to db server with
"-p" option if i log in to Database server and use -h localhost.
When i type show databases it show following databases in DB server.
++
| Database |
++
| information_schema |
| cloud |
| mysql |
++
3 rows in set (0.00 sec)
Thanks
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 02:11 AM
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e.
cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
> 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:@localhost
> --deploy-as=root: 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
>
>
Re: mysql-setup-database ERROR 1044 access denied for user root
Are you running mysql on 3306?
On 8/19/14, 9:20 PM, tejas.sh...@frontier.in wrote:
Hi,
I can login to remote database server using "mysql -h -u
root" command but if i type "-p" option (mysql -h -u root -p)
then i am not able to connect. but i am able to connect to db server with
"-p" option if i log in to Database server and use -h localhost.
When i type show databases it show following databases in DB server.
++
| Database |
++
| information_schema |
| cloud |
| mysql |
++
3 rows in set (0.00 sec)
Thanks
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 02:11 AM
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e.
cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
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:@localhost
--deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
oh, looks like you dont have password setup for root user on your db host.
Fix it before you can proceed.
On 8/19/14, 9:20 PM, tejas.sh...@frontier.in wrote:
Hi,
I can login to remote database server using "mysql -h -u
root" command but if i type "-p" option (mysql -h -u root -p)
then i am not able to connect. but i am able to connect to db server with
"-p" option if i log in to Database server and use -h localhost.
When i type show databases it show following databases in DB server.
++
| Database |
++
| information_schema |
| cloud |
| mysql |
++
3 rows in set (0.00 sec)
Thanks
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 02:11 AM
Subject: Re: mysql-setup-database ERROR 1044 access denied for user
root
Can you confirm logging using mysql client?
One other thought, change password to something simple that does not
have any fancy characters for this installation. I assume this should
not be an issue, but try it anyway. One other thing you can do as work
around, install the mysql db locally, run setup script against local
host, then export all DBs and import to new server. Recreate the users
and make sure to give your user proper host access (i.e.
cloud@"10.0.1.72").
On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
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:@localhost
--deploy-as=root: 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
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:@localhost
--deploy-as=root:" 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:@localhost
--deploy-as=root: 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
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:@localhost --deploy-as=root:" 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:@localhost
--deploy-as=root: 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
RE: mysql-setup-database ERROR 1044 access denied for user root
Hi Suneel,
I have checked the same option but still no luck. Still getting the
same error.
Thanks,
Tejas
From: Venkata Suneel Babu Mallela
To: "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:@localhost
--deploy-as=root:" 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:@localhost
--deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
Yes i am using the default port for mysql. and i have set the root
password also. I am able to do login using mysql client using -p
(password) only i am not able to do the same remotely (from cloudstack
server)
Thanks,
Tejas
From: ilya musayev
To: users@cloudstack.apache.org
Date: 08/20/2014 11:16 AM
Subject:Re: mysql-setup-database ERROR 1044 access denied for user
root
Are you running mysql on 3306?
On 8/19/14, 9:20 PM, tejas.sh...@frontier.in wrote:
> Hi,
>
>I can login to remote database server using "mysql -h -u
> root" command but if i type "-p" option (mysql -h -u root
-p)
> then i am not able to connect. but i am able to connect to db server
with
> "-p" option if i log in to Database server and use -h localhost.
>
>When i type show databases it show following databases in DB server.
> ++
> | Database |
> ++
> | information_schema |
> | cloud |
> | mysql |
> ++
> 3 rows in set (0.00 sec)
>
>Thanks
>Tejas
>
>
>
> From: ilya musayev
> To: users@cloudstack.apache.org
> Date: 08/20/2014 02:11 AM
> Subject:Re: mysql-setup-database ERROR 1044 access denied for
user
> root
>
>
>
> Can you confirm logging using mysql client?
>
> One other thought, change password to something simple that does not
> have any fancy characters for this installation. I assume this should
> not be an issue, but try it anyway. One other thing you can do as work
> around, install the mysql db locally, run setup script against local
> host, then export all DBs and import to new server. Recreate the users
> and make sure to give your user proper host access (i.e.
> cloud@"10.0.1.72").
>
> On 8/19/14, 5:49 AM, tejas.sh...@frontier.in wrote:
>> 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:@localhost
>> --deploy-as=root: 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
>>
>>
>
>
Re: mysql-setup-database ERROR 1044 access denied for user root
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
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:@localhost
--deploy-as=root:" 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:@localhost
--deploy-as=root: 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
>
RE: mysql-setup-database ERROR 1044 access denied for user root
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:).
Thanks,
Tejas
From: Venkata Suneel Babu Mallela
To: "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:@localhost
--deploy-as=root:" 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:@localhost
--deploy-as=root: 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
