Kope Active Member Licensed User Longtime User Jul 8, 2019 #1 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
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 Expert Licensed User Longtime User Jul 8, 2019 #2 You have to tell us which database are you connecting to. Upvote 0
Kope Active Member Licensed User Longtime User Jul 8, 2019 #3 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 Upvote 0
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.
mcqueccu Expert Licensed User Longtime User Jul 8, 2019 #4 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 Upvote 0
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 Active Member Licensed User Longtime User Jul 9, 2019 #5 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 Click to expand... Thanks for this but wasn’t able to serve my question Upvote 0
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 Click to expand... Thanks for this but wasn’t able to serve my question
Erel B4X founder Staff member Licensed User Longtime User Jul 9, 2019 #6 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. Upvote 0
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 Active Member Licensed User Longtime User Jul 9, 2019 #7 Erel said: First step is to create a B4J program that runs on the same computer. Are you able to connect to the database? Click to expand... 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 Upvote 0
Erel said: First step is to create a B4J program that runs on the same computer. Are you able to connect to the database? Click to expand... 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 B4X founder Staff member Licensed User Longtime User Jul 9, 2019 #8 Windows Firewall and open port number 3306 to all programs. Upvote 0
EnriqueGonzalez Expert Licensed User Longtime User Jul 9, 2019 #9 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 Click to expand... 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. Upvote 0
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 Click to expand... 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 Active Member Licensed User Longtime User Jul 9, 2019 #10 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. Click to expand... How do I go about it please Upvote 0
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. Click to expand... How do I go about it please
EnriqueGonzalez Expert Licensed User Longtime User Jul 9, 2019 #11 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; Upvote 0
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;
DonManfred Expert Licensed User Longtime User Jul 9, 2019 #12 MAke sure to not disable networking in the MySQL ini Upvote 0
