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: [email protected] From: Mauricio Tavares <[email protected]> To: Rajith P Venkata/India/IBM@IBMIN Cc: Daniel Bartholomew <[email protected]>, juju <[email protected]> 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 <[email protected]> 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: [email protected] > > > > From: Rajith P Venkata/India/IBM > To: Daniel Bartholomew <[email protected]>, juju > <[email protected]> > 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: [email protected] > > > > > -- > Juju mailing list > [email protected] > Modify settings or unsubscribe at: > https://lists.ubuntu.com/mailman/listinfo/juju >
-- Juju mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/juju
