On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata <rajith...@in.ibm.com> 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 <db...@mariadb.com>, 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