Re: Need information for connecting to mariadb from remote machine

2016-06-22 Thread Rajith P Venkata 
Hi

I have deployed Mariadb 5.5 and  tried to connect to mariadb from remote 
machine, I am getting error: ERROR 1045 (28000):Access denied for user

As Mariadb has restricted access is it fine If I execute following queries 
in Mariadb to  access  from remote machine.


CREATE USER 'root'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;

Let me know if this queries are fine or any alternate approach you have.




Rajith

IBM AIX Certified, OCPCertified


Cell- 9901966577
Email: rajith...@in.ibm.com



From:   Rajith P Venkata/India/IBM
To: Mauricio Tavares <raubvo...@gmail.com>
Cc: juju <juju@lists.ubuntu.com>
Date:   20-06-16 04:11 PM
Subject:    Re: Need information for connecting to mariadb from remote 
machine


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




From:   Mauricio Tavares <raubvo...@gmail.com>
To: Rajith P Venkata/India/IBM@IBMIN
Cc: juju <juju@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...@in.ibm.com> 
wrote:
> 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'
>

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






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

Re: Need information for connecting to mariadb from remote machine

2016-06-20 Thread Rajith P Venkata 
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...@in.ibm.com



From:   Mauricio Tavares <raubvo...@gmail.com>
To: Rajith P Venkata/India/IBM@IBMIN
Cc: juju <juju@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...@in.ibm.com> 
wrote:
> 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'
>

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





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

Re: Need information for connecting to mariadb from remote machine

2016-06-20 Thread Mauricio Tavares 
On Mon, Jun 20, 2016 at 6:23 AM, Rajith P Venkata <rajith...@in.ibm.com> wrote:
> 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'
>

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

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

Re: Need information for connecting to mariadb from remote machine

2016-06-20 Thread Rajith P Venkata 
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: rajith...@in.ibm.com



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





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

Re: Need information for connecting to mariadb from remote machine

2016-06-20 Thread Mauricio Tavares 
On Mon, Jun 20, 2016 at 5:51 AM, Rajith P Venkata  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...@in.ibm.com
>
>
>
> From:Rajith P Venkata/India/IBM
> To:Daniel Bartholomew , juju
> 
> 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...@in.ibm.com
>
>
>
>
> --
> Juju mailing list
> Juju@lists.ubuntu.com
> Modify settings or unsubscribe at:
> https://lists.ubuntu.com/mailman/listinfo/juju
>

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

Need information for connecting to mariadb from remote machine

2016-06-20 Thread 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...@in.ibm.com



From:   Rajith P Venkata/India/IBM
To: Daniel Bartholomew , juju 

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




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