How to access MySQL database on local computer with Android App?

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
ertank
Posts: 172
Joined: Wed 13 Jan 2016 16:00

Re: How to access MySQL database on local computer with Android App?

Post by ertank » Wed 09 Aug 2017 23:27

kerbadoughazali wrote:i do it, from the PC it connect but from Android it dosn't connect.
Hello,

Are you sure that MySQL server is listening on all IP addresses in its installed PC? You are welcome to check below link if you're not absolutely sure.

https://stackoverflow.com/questions/147 ... n-to-mysql

I advise, you read complete question and answers including all comments before you attempt to do any modifications on your own server. It is possible that answer is not for your particular version. If that is the case, you may need to check for relevant sources.

When you are sure that MySQL is listening on all IP numbers in the PC it is installed. You should first try connecting MySQL with PC which is already connecting. However, this time use IP number you see in ipconfig on PC where MySQL server is installed (I presume that is your own computer where Delphi and MySQL is installed).

If your test on PC is not successful, you should continue to search why regular IP number is not connecting.

Once you have successful connection on your PC using an IP number other than 127.0.0.1, you should do your Android application connection test using same IP number that you used on your PC.

I do sincerely hope that you will figure what your problem is.

Regards,
Ertan

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: How to access MySQL database on local computer with Android App?

Post by ViktorV » Thu 10 Aug 2017 11:26

kerbadoughazali wrote:i do it, from the PC it connect but from Android it dosn't connect.
This error is related to MySQL server configuration, but not to UniDAC functionality. To solve the issue, please refer to MySQL documentation or ask the question at some specialized forums.

Post Reply