Need information for connecting to mariadb from remote machine

[Rajith P Venkata]

Hi 

To be more precise,  I am  getting below error when I execute this :

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



From:   Mauricio Tavares <raubvogel at gmail.com>
To:     Rajith P Venkata/India/IBM at IBMIN
Cc:     Daniel Bartholomew <dbart at mariadb.com>, juju 
<juju at lists.ubuntu.com>
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 <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
> }
>
      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.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/20160620/2e920584/attachment.html>