RE: mysql-setup-database ERROR 1044 access denied for user root

2014-08-20 Thread tejas . sheth
oot:). Thanks, Tejas From: Venkata Suneel Babu Mallela To: "users@cloudstack.apache.org" Date: 08/20/2014 11:50 AM Subject: RE: mysql-setup-database ERROR 1044 access denied for user root Hi Tejas, Execute the below mysql command on DB server before executing &quo

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-20 Thread tejas . sheth
as From: ilya musayev To: users@cloudstack.apache.org Date: 08/20/2014 12:13 PM Subject: Re: mysql-setup-database ERROR 1044 access denied for user root my 2 cents Bad practice to do "%". Add identified by clause. "GRANT ALL PRIVILEGES ON *.* TO 'ro

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-20 Thread tejas . sheth
: 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 -u > root" command but

RE: mysql-setup-database ERROR 1044 access denied for user root

2014-08-20 Thread tejas . sheth
Hi Suneel, I have checked the same option but still no luck. Still getting the same error. Thanks, Tejas From: Venkata Suneel Babu Mallela To: "users@cloudstack.apache.org" Date: 08/20/2014 11:50 AM Subject: RE: mysql-setup-database ERROR 1044 access denie

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread ilya musayev
my 2 cents Bad practice to do "%". Add identified by clause. "GRANT ALL PRIVILEGES ON *.* TO 'root'@'30.34.12.12' WITH GRANT OPTION identified by "mypassword";" On 8/19/14, 11:31 PM, Venkata Suneel Babu Mallela wrote: Hi Tejas, Execute the below mysql command on DB server before executing

RE: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread Venkata Suneel Babu Mallela
Hi Tejas, Execute the below mysql command on DB server before executing "cloudstack-setup-databases cloud:@localhost --deploy-as=root:" on management server, "GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;" Thank you, Suneel Mallela -Original Message- From: tejas.sh...@

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread ilya musayev
+ | information_schema | | cloud | | mysql | ++ 3 rows in set (0.00 sec) Thanks Tejas From: ilya musayev To: users@cloudstack.apache.org Date: 08/20/2014 02:11 AM Subject: Re: mysql-setup-database ERROR 1044 access d

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread ilya musayev
++ 3 rows in set (0.00 sec) Thanks Tejas From: ilya musayev 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 oth

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread tejas . sheth
already checked but not working!! Thanks Tejas From: sunil.pichamu...@frontier.in To: users@cloudstack.apache.org Date: 08/20/2014 09:54 AM Subject:Re: mysql-setup-database ERROR 1044 access denied for user root Tejas, You'll need to check if the root user has permis

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread sunil . pichamuthu
t better than I can. - John F. Kennedy" From: tejas.sh...@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 -u r

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread tejas . sheth
ilya musayev 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 f

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread ilya musayev
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, ru

Re: mysql-setup-database ERROR 1044 access denied for user root

2014-08-19 Thread abhisek basu
Essentially are you able to login to db server from mgmt server using root via MySQL command and speechify -h db server name? MySQL.user is the table which controls this. Sent from my iPhone > On 19 Aug 2014, at 6:30 pm, tejas.sh...@frontier.in wrote: > > Hi, > I have installed database in se