B4J Question Using jSQL on other PC

[Kope]

hi, Please I need help with how to access Database from another PC. Am using this example https://www.b4x.com/android/forum/threads/jsql-v1-20-asynchronous-initialization.42251/#content

 

[EnriqueGonzalez]

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

 

[Kope]

Am using xampp

I tried to connect to the server from another PC using this

    "jdbc:mysql://192.167.8.2/example?characterEncoding=utf8", "user", ""

But it seems not to be responding.

 

[mcqueccu]

Check this post from StackOverflow, you will have to configure the firewall and allow access to your port

https://stackoverflow.com/questions...from-another-computer-over-lan-network-how-to

 

[Kope]

Check this post from StackOverflow, you will have to configure the firewall and allow access to your port

https://stackoverflow.com/questions...from-another-computer-over-lan-network-how-to

Thanks for this but wasn’t able to serve my question

 

[Erel]

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.

 

[Kope]

First step is to create a B4J program that runs on the same computer. Are you able to connect to the database?

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

 

[Erel]

Windows Firewall and open port number 3306 to all programs.

 

[EnriqueGonzalez]

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

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]

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.

How do I go about it please

 

[EnriqueGonzalez]

Here for the remote access
https://serverfault.com/questions/52794/how-do-i-allow-remote-access-to-mysql-using-xampp

here for the user remote access run this 2 sql sentences (one after the other), write root password instead of @password

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
    IDENTIFIED BY '@password' 
    WITH GRANT OPTION;

FLUSH PRIVILEGES;

 

[DonManfred]

MAke sure to not disable networking in the MySQL ini