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 < sunee...@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:i...@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 < > sunee...@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 > > >
