Need information for connecting to mariadb from remote machine

[Rajith P Venkata]

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.pv at in.ibm.com



From:   Rajith P Venkata/India/IBM
To:     Daniel Bartholomew <dbart at mariadb.com>, juju 
<juju at 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.pv at in.ibm.com




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/juju/attachments/20160620/fad37600/attachment.html>