cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ian Duffy <...@ianduffy.ie>
Subject Re: Error Importing Sql Dumpfile
Date Wed, 17 Sep 2014 08:21:52 GMT
Hi Suneel,

You will need to grant your cloud user access to the databases accordingly.

e.g.

grant all privileges on cloud.* to cloud@'%'

Hope this helps,
Ian

On 16 September 2014 17:11, Venkata Suneel Babu Mallela <
suneel.m@simplifydc.com> wrote:

> Hi Ian Duffy,
>
> Thank you for your reply. I'm able to login with 'cloud' user without
> password, but with this user I'm unable to see the "cloud" and
> "cloud_usage" databases. I'm able to see these databases with root user.
> Is there anything I missed? Please suggest.
>
> Thank you,
> Suneel Mallela
>
> -----Original Message-----
> From: Ian Duffy [mailto:ian@ianduffy.ie]
> Sent: Tuesday, September 16, 2014 6:56 PM
> To: users@cloudstack.apache.org
> Subject: Re: Error Importing Sql Dumpfile
>
> Hi Suneel,
>
> The error suggests a cloud user doesn't exist within your mysql database.
>
> Please create a new user and it should solve the error.
>
> e.g.
>
> CREATE USER 'cloud'@'%' IDENTIFIED BY 'password';
>
> On 16 September 2014 14:20, Venkata Suneel Babu Mallela <
> suneel.m@simplifydc.com> wrote:
>
> > HI All,
> >
> > I'm trying to configure DataBase replication for ACS 4.4.0, and
> > followed the below steps.
> >
> >
> > 1.       I've exported the existing data of master  using the command
> > "mysqldump -u root -p --all-databases --master-data > dbdump.db".
> >
> > 2.       When I tried to import dumpfile into the slave using the command
> > "mysql -u root -p < /root/dbdump.db", I'm getting the below error,
> >
> > [root@pocdb02 ~]# mysql -u root < dbdump.db ERROR 1449 (HY000) at line
> > 11293: The user specified as a definer ('cloud'@'%') does not exist
> >
> > Can anyone please advise how to resolve this problem?
> >
> > Thank you,
> > Suneel Mallela
> >
>

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