VB.Net Unable to connect SQL from Local IP and Public IP
Posted by: xhbx (---.singnet.com.sg)
Date: May 09, 2019 04:00PM

Hi All

I could like to know how to let my VB.net application connect to sql server from public and local IP?


if use Localhost my coding no issue but when using 192.168.1.2 which is my PC or my public IP it have a error message


host xxx.xxx.xxx.xxx is not allowed to connect to this mysql server


From web browser I can using either localhost or 192.168.1.2 or my public IP no issue


Anyone have any idea how to solve?

Options: ReplyQuote
Re: VB.Net Unable to connect SQL from Local IP and Public IP
Posted by: RiggsFolly (Moderator)
Date: May 09, 2019 04:56PM

Hi

Are you using WAMPServer? If so please answer all these questions before asking a question

Read and answer all these questions

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.1.8 32bit & 64bit)
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.16>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: VB.Net Unable to connect SQL from Local IP and Public IP
Posted by: Otomatic (Moderator)
Date: May 09, 2019 06:58PM

Hi,

In any case, in order to be able to connect to MySQL (or MariaDcool smiley, it is imperative that the three entities from which you want to connect (user, from host, password) are known to MySQL, so that this user account has been registered in MySQL. The "from host" can be a host name or an IP.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.9 32 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27 - MariaDB 10.3.16
Wampserver 3.1.9 64 bit - Apache 2.4.41 - PHP 7.3.8/7.2.21/7.1.31/7.0.33/5.6.40 - MySQL 5.7.27/8.0.17 - MariaDB 10.3.16
PhPMyadmin 4.9.0.1 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.