B4J Question Using jSQL on other PC

Kope · Jul 8, 2019

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 · Jul 8, 2019

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

Kope · Jul 8, 2019

Am using xampp

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

B4X:

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

But it seems not to be responding.

mcqueccu · Jul 8, 2019

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 · Jul 9, 2019

mcqueccu said:
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 · Jul 9, 2019

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 · Jul 9, 2019

Erel said:
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 · Jul 9, 2019

Windows Firewall and open port number 3306 to all programs.

EnriqueGonzalez · Jul 9, 2019

Kope said:
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 · Jul 9, 2019

Enrique Gonzalez R said:
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 · Jul 9, 2019

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

B4X:

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

B4X:

FLUSH PRIVILEGES;

DonManfred · Jul 9, 2019

MAke sure to not disable networking in the MySQL ini

B4J Question Using jSQL on other PC

Kope

Active Member

EnriqueGonzalez

Well-Known Member

Kope

Active Member

mcqueccu

Well-Known Member

Kope

Active Member

Erel

B4X founder

Kope

Active Member

Erel

B4X founder

EnriqueGonzalez

Well-Known Member

Kope

Active Member

EnriqueGonzalez

Well-Known Member

DonManfred

Expert

Similar Threads

B4J Question Using jSQL on other PC

Active Member

Well-Known Member

Active Member

Well-Known Member

Active Member

B4X founder

Active Member

B4X founder

Well-Known Member

Active Member

Well-Known Member

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency