Re: Host '192.168.1.5' is not allowed to connect to this MySQL server
Posted by: Fernando Gonzalez.Sanchez
Date: March 09, 2013 04:25PM

Hi,

As I understand your server address is 192.168.1.5, putting that address as the host component in the user account will be the same than using localhost.
In other words, you have to put in the host part the IP of the client machine, thus is your client (where the ASP.NET app is located has IP 192.168.1.6), then you have to create a user 'user'@'192.168.1.6', to create an account for any client (as long as they enter the right password) use %: 'user'@'%'.

You can also use other wildcards and netmasks, for more details please refer to http://dev.mysql.com/doc/refman/5.6/en/account-names.html.

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
Re: Host '192.168.1.5' is not allowed to connect to this MySQL server
March 09, 2013 04:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.