cloudstack-users mailing list archives

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




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