Need information for connecting to mariadb from remote machine
Hi I am connecting to mariadb from remote machine , I am executing this commands from bash @when 'relation_name.available' function mariadb_install_check(){ db_host=`relation-get host` db_user=`relation-get user` db_pass=`relation-get password` mysql -h db_host -u db_user -p db_pass } while connecting to my sql : I am getting error: ERROR 1045 (28000): Access denied for user please let me know what grant permission I can provide from mariadb to default user of remote machine. remote machine user I am getting: ietohvoibaitaik Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Rajith P Venkata/India/IBM To: Daniel Bartholomew , juju Date: 14-06-16 11:31 PM Subject:Need information for performing housekeeping tasks on mariadb from a remote machine Hi, I have deployed mariadb in unit 1 and want to perform following tasks from RTM charm which is in unit 2 rm -f /var/lib/mysql/ib_logfile* service mysql stop rm -f /var/lib/mysql/ibdata* Please let me know how I can perform this housekeeping tasks. Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata wrote: > Hi > > I am connecting to mariadb from remote machine , I am executing this > commands from bash > > @when 'relation_name.available' > function mariadb_install_check(){ > db_host=`relation-get host` > db_user=`relation-get user` > db_pass=`relation-get password` > mysql -h db_host -u db_user -p db_pass > } > Didn't know that is a proper bash function; learning something new every day. > > while connecting to my sql : I am getting error: ERROR 1045 (28000): Access > denied for user > Have you tried manually to connect as said user? From the mariadb server and then from remote host? > please let me know what grant permission I can provide from mariadb to > default user of remote machine. > I think that is a mysql (and derivatives) question, not a juju one. The error message you got might provide a hint. > remote machine user I am getting: ietohvoibaitaik > > > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Rajith P Venkata/India/IBM > To:Daniel Bartholomew , juju > > Date:14-06-16 11:31 PM > Subject:Need information for performing housekeeping tasks on > mariadb from a remote machine > > > > Hi, > > I have deployed mariadb in unit 1 and want to perform following tasks from > RTM charm which is in unit 2 > > rm -f /var/lib/mysql/ib_logfile* > service mysql stop > rm -f /var/lib/mysql/ibdata* > > Please let me know how I can perform this housekeeping tasks. > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > > -- > Juju mailing list > Juju@lists.ubuntu.com > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/juju > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
Hi To be more precise, I am getting below error when I execute this : ubuntu@charm-local-machine-5:~$ mysql -h 10.0.3.46 -u ietohvoibaitaik ERROR 1045 (28000): Access denied for user 'ietohvoibaitaik'@'10.0.3.76' Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Mauricio Tavares To: Rajith P Venkata/India/IBM@IBMIN Cc: Daniel Bartholomew , juju Date: 20-06-16 03:46 PM Subject:Re: Need information for connecting to mariadb from remote machine On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata wrote: > Hi > > I am connecting to mariadb from remote machine , I am executing this > commands from bash > > @when 'relation_name.available' > function mariadb_install_check(){ > db_host=`relation-get host` > db_user=`relation-get user` > db_pass=`relation-get password` > mysql -h db_host -u db_user -p db_pass > } > Didn't know that is a proper bash function; learning something new every day. > > while connecting to my sql : I am getting error: ERROR 1045 (28000): Access > denied for user > Have you tried manually to connect as said user? From the mariadb server and then from remote host? > please let me know what grant permission I can provide from mariadb to > default user of remote machine. > I think that is a mysql (and derivatives) question, not a juju one. The error message you got might provide a hint. > remote machine user I am getting: ietohvoibaitaik > > > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Rajith P Venkata/India/IBM > To:Daniel Bartholomew , juju > > Date:14-06-16 11:31 PM > Subject:Need information for performing housekeeping tasks on > mariadb from a remote machine > > > > Hi, > > I have deployed mariadb in unit 1 and want to perform following tasks from > RTM charm which is in unit 2 > > rm -f /var/lib/mysql/ib_logfile* > service mysql stop > rm -f /var/lib/mysql/ibdata* > > Please let me know how I can perform this housekeeping tasks. > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > > -- > Juju mailing list > Juju@lists.ubuntu.com > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/juju > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
On Mon, Jun 20, 2016 at 6:23 AM, Rajith P Venkata wrote: > Hi > > To be more precise, I am getting below error when I execute this : > > ubuntu@charm-local-machine-5:~$ mysql -h 10.0.3.46 -u ietohvoibaitaik > ERROR 1045 (28000): Access denied for user 'ietohvoibaitaik'@'10.0.3.76' > 1. Your command seems to be incomplete. How are you passing the password? 2. Have you tried as I suggested connecting from 10.0.3.46 instead of 10.0.3.76? > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Mauricio Tavares > To:Rajith P Venkata/India/IBM@IBMIN > Cc:Daniel Bartholomew , juju > > Date: 20-06-16 03:46 PM > Subject:Re: Need information for connecting to mariadb from remote > machine > > > > > On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata > wrote: >> Hi >> >> I am connecting to mariadb from remote machine , I am executing this >> commands from bash >> >> @when 'relation_name.available' >> function mariadb_install_check(){ >> db_host=`relation-get host` >> db_user=`relation-get user` >> db_pass=`relation-get password` >> mysql -h db_host -u db_user -p db_pass >> } >> > Didn't know that is a proper bash function; learning something > new every day. > >> >> while connecting to my sql : I am getting error: ERROR 1045 (28000): >> Access >> denied for user >> > Have you tried manually to connect as said user? From the > mariadb server and then from remote host? > >> please let me know what grant permission I can provide from mariadb to >> default user of remote machine. >> > I think that is a mysql (and derivatives) question, not a juju > one. The error message you got might provide a hint. > >> remote machine user I am getting: ietohvoibaitaik >> >> >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> From:Rajith P Venkata/India/IBM >> To:Daniel Bartholomew , juju >> >> Date:14-06-16 11:31 PM >> Subject:Need information for performing housekeeping tasks on >> mariadb from a remote machine >> >> >> >> Hi, >> >> I have deployed mariadb in unit 1 and want to perform following tasks from >> RTM charm which is in unit 2 >> >> rm -f /var/lib/mysql/ib_logfile* >> service mysql stop >> rm -f /var/lib/mysql/ibdata* >> >> Please let me know how I can perform this housekeeping tasks. >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> >> -- >> Juju mailing list >> Juju@lists.ubuntu.com >> Modify settings or unsubscribe at: >> https://lists.ubuntu.com/mailman/listinfo/juju >> > > > > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
Hi please check this I am connecting to mariadb from remote machine 10.0.3.76. Mariadb is installed in 10.0.3.46 Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Mauricio Tavares To: Rajith P Venkata/India/IBM@IBMIN Cc: juju Date: 20-06-16 04:02 PM Subject:Re: Need information for connecting to mariadb from remote machine On Mon, Jun 20, 2016 at 6:23 AM, Rajith P Venkata wrote: > Hi > > To be more precise, I am getting below error when I execute this : > > ubuntu@charm-local-machine-5:~$ mysql -h 10.0.3.46 -u ietohvoibaitaik > ERROR 1045 (28000): Access denied for user 'ietohvoibaitaik'@'10.0.3.76' > 1. Your command seems to be incomplete. How are you passing the password? 2. Have you tried as I suggested connecting from 10.0.3.46 instead of 10.0.3.76? > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Mauricio Tavares > To:Rajith P Venkata/India/IBM@IBMIN > Cc:Daniel Bartholomew , juju > > Date: 20-06-16 03:46 PM > Subject:Re: Need information for connecting to mariadb from remote > machine > > > > > On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata > wrote: >> Hi >> >> I am connecting to mariadb from remote machine , I am executing this >> commands from bash >> >> @when 'relation_name.available' >> function mariadb_install_check(){ >> db_host=`relation-get host` >> db_user=`relation-get user` >> db_pass=`relation-get password` >> mysql -h db_host -u db_user -p db_pass >> } >> > Didn't know that is a proper bash function; learning something > new every day. > >> >> while connecting to my sql : I am getting error: ERROR 1045 (28000): >> Access >> denied for user >> > Have you tried manually to connect as said user? From the > mariadb server and then from remote host? > >> please let me know what grant permission I can provide from mariadb to >> default user of remote machine. >> > I think that is a mysql (and derivatives) question, not a juju > one. The error message you got might provide a hint. > >> remote machine user I am getting: ietohvoibaitaik >> >> >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> From:Rajith P Venkata/India/IBM >> To:Daniel Bartholomew , juju >> >> Date:14-06-16 11:31 PM >> Subject:Need information for performing housekeeping tasks on >> mariadb from a remote machine >> >> >> >> Hi, >> >> I have deployed mariadb in unit 1 and want to perform following tasks from >> RTM charm which is in unit 2 >> >> rm -f /var/lib/mysql/ib_logfile* >> service mysql stop >> rm -f /var/lib/mysql/ibdata* >> >> Please let me know how I can perform this housekeeping tasks. >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> >> -- >> Juju mailing list >> Juju@lists.ubuntu.com >> Modify settings or unsubscribe at: >> https://lists.ubuntu.com/mailman/listinfo/juju >> > > > > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
Hi I have deployed Mariadb 5.5 and tried to connect to mariadb from remote machine, I am getting error: ERROR 1045 (28000):Access denied for user As Mariadb has restricted access is it fine If I execute following queries in Mariadb to access from remote machine. CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass'; GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; FLUSH PRIVILEGES; Let me know if this queries are fine or any alternate approach you have. Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Rajith P Venkata/India/IBM To: Mauricio Tavares Cc: juju Date: 20-06-16 04:11 PM Subject: Re: Need information for connecting to mariadb from remote machine Hi please check this I am connecting to mariadb from remote machine 10.0.3.76. Mariadb is installed in 10.0.3.46 Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Mauricio Tavares To: Rajith P Venkata/India/IBM@IBMIN Cc: juju Date: 20-06-16 04:02 PM Subject: Re: Need information for connecting to mariadb from remote machine On Mon, Jun 20, 2016 at 6:23 AM, Rajith P Venkata wrote: > Hi > > To be more precise, I am getting below error when I execute this : > > ubuntu@charm-local-machine-5:~$ mysql -h 10.0.3.46 -u ietohvoibaitaik > ERROR 1045 (28000): Access denied for user 'ietohvoibaitaik'@'10.0.3.76' > 1. Your command seems to be incomplete. How are you passing the password? 2. Have you tried as I suggested connecting from 10.0.3.46 instead of 10.0.3.76? > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Mauricio Tavares > To:Rajith P Venkata/India/IBM@IBMIN > Cc: Daniel Bartholomew , juju > > Date:20-06-16 03:46 PM > Subject:Re: Need information for connecting to mariadb from remote > machine > > > > > On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata > wrote: >> Hi >> >> I am connecting to mariadb from remote machine , I am executing this >> commands from bash >> >> @when 'relation_name.available' >> function mariadb_install_check(){ >> db_host=`relation-get host` >> db_user=`relation-get user` >> db_pass=`relation-get password` >> mysql -h db_host -u db_user -p db_pass >> } >> > Didn't know that is a proper bash function; learning something > new every day. > >> >> while connecting to my sql : I am getting error: ERROR 1045 (28000): >> Access >> denied for user >> > Have you tried manually to connect as said user? From the > mariadb server and then from remote host? > >> please let me know what grant permission I can provide from mariadb to >> default user of remote machine. >> > I think that is a mysql (and derivatives) question, not a juju > one. The error message you got might provide a hint. > >> remote machine user I am getting: ietohvoibaitaik >> >> >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> From:Rajith P Venkata/India/IBM >> To:Daniel Bartholomew , juju >> >> Date:14-06-16 11:31 PM >> Subject:Need information for performing housekeeping tasks on >> mariadb from a remote machine >> >> >> >> Hi, >> >> I have deployed mariadb in unit 1 and want to perform following tasks from >> RTM charm which is in unit 2 >> >> rm -f /var/lib/mysql/ib_logfile* >> service mysql stop >> rm -f /var/lib/mysql/ibdata* >> >> Please let me know how I can perform this housekeeping tasks. >> >> >> Rajith >> >> IBM AIX Certified, OCPCertified >> >> >> Cell- 9901966577 >> Email: rajith...@in.ibm.com >> >> >> >> >> -- >> Juju mailing list >> Juju@lists.ubuntu.com >> Modify settings or unsubscribe at: >> https://lists.ubuntu.com/mailman/listinfo/juju >> > > > > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
Have you tried including the db name when connecting, e.g.: mysql -h db_host -u db_user -p db_pass -D `relation-get database` Pretty sure you only get perms to the database created for you when you join the relation. On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata wrote: > Hi > > I am connecting to mariadb from remote machine , I am executing this > commands from bash > > @when 'relation_name.available' > function mariadb_install_check(){ > db_host=`relation-get host` > db_user=`relation-get user` > db_pass=`relation-get password` > mysql -h db_host -u db_user -p db_pass > } > > > while connecting to my sql : I am getting error: ERROR 1045 (28000): > Access denied for user > > please let me know what grant permission I can provide from mariadb to > default user of remote machine. > > remote machine user I am getting: ietohvoibaitaik > > > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > From:Rajith P Venkata/India/IBM > To:Daniel Bartholomew , juju < > juju@lists.ubuntu.com> > Date:14-06-16 11:31 PM > Subject:Need information for performing housekeeping tasks on > mariadb from a remote machine > -- > > > Hi, > > I have deployed mariadb in unit 1 and want to perform following tasks from > RTM charm which is in unit 2 > > rm -f /var/lib/mysql/ib_logfile* > service mysql stop > rm -f /var/lib/mysql/ibdata* > > Please let me know how I can perform this housekeeping tasks. > > > Rajith > > IBM AIX Certified, OCPCertified > > > Cell- 9901966577 > Email: rajith...@in.ibm.com > > > > > -- > Juju mailing list > Juju@lists.ubuntu.com > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/juju > > -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
Re: Need information for connecting to mariadb from remote machine
Hi I tried with below code, we are getting error Access denied error @when 'relation_name.available' function mariadb_install_check(){ db_host=`relation-get host` db_user=`relation-get user` db_pass=`relation-get password` db_database=`relation-get database` mysql -h $db_host -u $db_user -p $db_pass -D $db_database } +++ mysql -h 10.0.3.46 -u aogheelaengeebe -p shaethieteirowu -D ibm-platform-rtm 2016-06-24 06:22:23 INFO ibm-prtm-mariadb-relation-changed Enter password: ERROR 1045 (28000): Access denied for user 'aogheelaengeebe'@'10.0.3.245' Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From: Tim Van Steenburgh To: Rajith P Venkata/India/IBM@IBMIN Cc: juju Date: 23-06-16 02:38 AM Subject: Re: Need information for connecting to mariadb from remote machine Have you tried including the db name when connecting, e.g.: mysql -h db_host -u db_user -p db_pass -D `relation-get database` Pretty sure you only get perms to the database created for you when you join the relation. On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata wrote: Hi I am connecting to mariadb from remote machine , I am executing this commands from bash @when 'relation_name.available' function mariadb_install_check(){ db_host=`relation-get host` db_user=`relation-get user` db_pass=`relation-get password` mysql -h db_host -u db_user -p db_pass } while connecting to my sql : I am getting error: ERROR 1045 (28000): Access denied for user please let me know what grant permission I can provide from mariadb to default user of remote machine. remote machine user I am getting: ietohvoibaitaik Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com From:Rajith P Venkata/India/IBM To:Daniel Bartholomew , juju < juju@lists.ubuntu.com> Date:14-06-16 11:31 PM Subject:Need information for performing housekeeping tasks on mariadb from a remote machine Hi, I have deployed mariadb in unit 1 and want to perform following tasks from RTM charm which is in unit 2 rm -f /var/lib/mysql/ib_logfile* service mysql stop rm -f /var/lib/mysql/ibdata* Please let me know how I can perform this housekeeping tasks. Rajith IBM AIX Certified, OCPCertified Cell- 9901966577 Email: rajith...@in.ibm.com -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju -- Juju mailing list Juju@lists.ubuntu.com Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju