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
Thanks for this but wasn’t able to serve my questionCheck 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
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.First step is to create a B4J program that runs on the same computer. Are you able to connect to the database?
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.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
How do I go about it pleasekeep 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.
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
IDENTIFIED BY '@password'
WITH GRANT OPTION;
FLUSH PRIVILEGES;