B4J Question Using jSQL on other PC

Discussion in 'B4J Questions' started by Kope, Jul 8, 2019.

Similar threads

B4J Tutorial SQL Tutorial
B4J Library [B4X] DBUtils 2
B4J Tutorial DBUtils Example
B4A Tutorial [B4X] SQL with Wait For
B4J Code Snippet Opening MS Access databases (mdb)
  1. Kope

    Kope Member Licensed User

  2. Enrique Gonzalez R

    Enrique Gonzalez R Well-Known Member Licensed User

    You have to tell us which database are you connecting to.
     
  3. Kope

    Kope Member Licensed User

    Am using xampp

    I tried to connect to the server from another PC using this
    Code:
    "jdbc:mysql://192.167.8.2/example?characterEncoding=utf8""user"""
    But it seems not to be responding.
     
    Last edited: Jul 8, 2019
  4. mcqueccu

    mcqueccu Active Member Licensed User

    Kope likes this.
  5. Kope

    Kope Member Licensed User

  6. Erel

    Erel Administrator Staff Member Licensed User

    First step is to create a B4J program that runs on the same computer. Are you able to connect to the database?
    If so then it is likely a firewall issue.
     
  7. Kope

    Kope Member Licensed User

    Yes I have created a B4j program that runs on the same computer. Am able to connect to the database using “Localhost” in the JSQL.


    How do I resolve the firewall issue. Please help. Am using Xampp.

    Thank You
     
  8. Erel

    Erel Administrator Staff Member Licensed User

    Windows Firewall and open port number 3306 to all programs.
     
    Kope likes this.
  9. Enrique Gonzalez R

    Enrique Gonzalez R Well-Known Member Licensed User

    keep in mind that by default mysql does not allow external communications beyond localhost, what you should do is enable it. also root user is not allowed to enter beyond localhost you have to give permissions to it also.
     
    Kope likes this.
  10. Kope

    Kope Member Licensed User

    How do I go about it please
     
  11. Enrique Gonzalez R

    Enrique Gonzalez R Well-Known Member Licensed User

    Kope likes this.
  12. DonManfred

    DonManfred Expert Licensed User

    MAke sure to not disable networking in the MySQL ini
     
    Kope likes this.
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice