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: [email protected]
From: Tim Van Steenburgh <[email protected]>
To: Rajith P Venkata/India/IBM@IBMIN
Cc: juju <[email protected]>
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 <[email protected]>
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: [email protected]
From: Rajith P Venkata/India/IBM
To: Daniel Bartholomew <[email protected]>, juju <
[email protected]>
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: [email protected]
--
Juju mailing list
[email protected]
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/juju
--
Juju mailing list
[email protected]
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/juju
