Need information for connecting to mariadb from remote machine
Rajith P Venkata
rajith.pv at in.ibm.com
Mon Jun 20 10:41:38 UTC 2016
Hi
please check this
I am connecting to mariadb from remote machine 10.0.3.76. Mariadb is
installed in 10.0.3.46
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: juju <juju at lists.ubuntu.com>
Date: 20-06-16 04:02 PM
Subject: Re: Need information for connecting to mariadb from remote
machine
On Mon, Jun 20, 2016 at 6:23 AM, Rajith P Venkata <rajith.pv at in.ibm.com>
wrote:
> 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'
>
1. Your command seems to be incomplete. How are you passing the password?
2. Have you tried as I suggested connecting from 10.0.3.46 instead of
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/c6e57e47/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 5245 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/juju/attachments/20160620/c6e57e47/attachment.gif>
More information about the Juju
mailing list