mysql-setup-database ERROR 1044 access denied for user root
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:@localhost --deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
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 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:@localhost > --deploy-as=root: 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 >
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:@localhost --deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
Hi, I can login to remote database server using "mysql -h -u root" command but if i type "-p" option (mysql -h -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 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:@localhost > --deploy-as=root: 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 > >
Re: mysql-setup-database ERROR 1044 access denied for user root
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.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 root" command but if i type "-p" option (mysql -h -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 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:@localhost > --deploy-as=root: 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 > >
Re: mysql-setup-database ERROR 1044 access denied for user root
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 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.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 root" command but if i type "-p" option (mysql -h -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 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:@localhost > --deploy-as=root: 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 > >
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 if i type "-p" option (mysql -h -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 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:@localhost --deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
oh, looks like you dont have password setup for root user on your db host. Fix it before you can proceed. 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 if i type "-p" option (mysql -h -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 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:@localhost --deploy-as=root: 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
RE: mysql-setup-database ERROR 1044 access denied for user root
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...@frontier.in [mailto:tejas.sh...@frontier.in] Sent: Tuesday, August 19, 2014 6:19 PM To: CloudStack-Users Subject: mysql-setup-database ERROR 1044 access denied for user root 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:@localhost --deploy-as=root: 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
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 '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 "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...@frontier.in [mailto:tejas.sh...@frontier.in] Sent: Tuesday, August 19, 2014 6:19 PM To: CloudStack-Users Subject: mysql-setup-database ERROR 1044 access denied for user root 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:@localhost --deploy-as=root: 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
RE: mysql-setup-database ERROR 1044 access denied for user root
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 denied for user root 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...@frontier.in [mailto:tejas.sh...@frontier.in] Sent: Tuesday, August 19, 2014 6:19 PM To: CloudStack-Users Subject: mysql-setup-database ERROR 1044 access denied for user root 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:@localhost --deploy-as=root: 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
Re: mysql-setup-database ERROR 1044 access denied for user root
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 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 -u > root" command but if i type "-p" option (mysql -h -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 > 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:@localhost >> --deploy-as=root: 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 >> >> > >
Re: mysql-setup-database ERROR 1044 access denied for user root
It is giving following error with identified by clause. "ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by "password'' at line 1" Thanks Tejas 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 '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 "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...@frontier.in [mailto:tejas.sh...@frontier.in] > Sent: Tuesday, August 19, 2014 6:19 PM > To: CloudStack-Users > Subject: mysql-setup-database ERROR 1044 access denied for user root > > 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:@localhost --deploy-as=root: 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 >
RE: mysql-setup-database ERROR 1044 access denied for user root
Hi Guyz, The issue is Resolved, I have applied following command in database server. UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root'; FLUSH PRIVILEGES; And I have removed password from cloud-setup-database statement (--deploy-as=root:). 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 "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...@frontier.in [mailto:tejas.sh...@frontier.in] Sent: Tuesday, August 19, 2014 6:19 PM To: CloudStack-Users Subject: mysql-setup-database ERROR 1044 access denied for user root 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:@localhost --deploy-as=root: 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