Access mysql data from other host


#1

I’d like to know if it’s possible to open a datasource from an outside host.

When I try I get denied. I can login using the web interface and using telnet. Is it possible to to change privilges to allow access from my home address?

I java.sql.SQLException: Invalid authorization specification: Access denied for user: ‘myuser@ip68-xxx-72-123.sb.sd.cox.net’ (Using password: YES)


#2

Yes. Edit the MySQL user from the web panel, and grant permissions to an IP or IP range.


#3

awesome, works great!!

thanks will