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