Need information for connecting to mariadb from remote machine

[Rajith P Venkata]

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



From:   Tim Van Steenburgh <tim.van.steenburgh at canonical.com>
To:     Rajith P Venkata/India/IBM at IBMIN
Cc:     juju <juju at lists.ubuntu.com>
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 <rajith.pv at 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
}


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




--
Juju mailing list
Juju at lists.ubuntu.com
Modify settings or unsubscribe at: 
https://lists.ubuntu.com/mailman/listinfo/juju





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