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 <ilya.mailing.li...@gmail.com>
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 <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
>>
>>
>
>
