B4J Question Using jSQL on other PC

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

 

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

 

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.

 

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

 

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.

 

How do I go about it please

 

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

Code:

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

Code:

FLUSH PRIVILEGES;

 

MAke sure to not disable networking in the MySQL ini