Hi,
I can login to remote database server using "mysql -h <ip address> -u
root" command but if i type "-p" option (mysql -h <ip address> -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 <ilya.mailing.li...@gmail.com>
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:<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
>
>
