Layer7 API Management

  • 1.  stop one of mysql DB on ssg

    Posted Sep 03, 2018 12:09 PM

    Hi There,

    I have 3 DB instances running on my ssg VMware, which are SSG, test, and test2DB (testDwhichch I have created). Now,I want to stop the test2DB how could I do it.



  • 2.  Re: stop one of mysql DB on ssg

    Posted Sep 03, 2018 07:46 PM

    Hi There,

     

    Are you referring to having multiple MYSQL DB instances on the same host or multiple DB's running on one MYSQL instance (which is the default setting for our CA API Gateway setting)?

     

    If the later, which is most likely, you can use the MYSQL command to remove grants to that DB.

     

    Kind Regards,

     

    Amit.



  • 3.  Re: stop one of mysql DB on ssg
    Best Answer

    Posted Sep 04, 2018 03:12 PM

    If you want to completely drop a database (that is, delete it) from the MySQL server, you can follow the MySQL documentation for that here: MySQL :: MySQL 5.5 Reference Manual :: 13.1.21 DROP DATABASE Syntax 

     

    If you do not want to drop a database from the database server, please clarify your request.