Layer 7 API Management

Expand all | Collapse all

change mysql db from local host to ip

Jump to Best Answer
  • 1.  change mysql db from local host to ip

    Posted 07-28-2018 04:10 PM

    Hi There,

    Amusing localhost while configured gateway database and OTK database for both the database is mysql.I want to change from localhost to the ip address of the server.At what places i should update this from localhost to ip?

    Essentially i want to connect mysql database using a SQL developer tool so that I can have a clear view about the tables and the data.pls advice.



  • 2.  Re: change mysql db from local host to ip

    Posted 07-30-2018 03:46 AM

    Hi,

     

     

     

    For Gateway Database, Change in node.properties file.

     

    For OTK Database, change in JDBC connection.

     

     

     

    Note - otk_user is having access only via localhost. Allow otk_user to connect via server IP.

     

     

     

     

     

    Regards,

     

    Mahesh



  • 3.  Re: change mysql db from local host to ip

    Posted 07-30-2018 06:04 PM

    Am getting the following exception changed from localhost to the hostname of the machine.If it was localhost it works but not with the hostname.pls advice.

     



  • 4.  Re: change mysql db from local host to ip

    Posted 07-30-2018 08:08 PM

    You need to set DNS properly for gateway server, or you may need to put it in /etc/hosts file.



  • 5.  Re: change mysql db from local host to ip

    Posted 07-31-2018 08:02 PM

    Sorry, it's not a connection problem, it's "Access denied" which means a permission problem. As Joe Dascole said below, you need to grant proper permissions to  'otk_user1'@'ssg91pri.mydmn.com'



  • 6.  Re: change mysql db from local host to ip
    Best Answer

    Posted 07-31-2018 09:12 AM

    Hi Sharath,

     

    You need to set the grants for that user in MySQL

     

    ie:

     

    GRANT SELECT,UPDATE,DELETE,INSERT ON otk_db.* TO 'otk_user1'@'ssg91pri.mydmn.com' identified by 'PASSWORD';

     

    where PASSWORD is to be changed to the otk_user1 password.

     

    Regards,

    Joe