Re: Newbie - database access online
Posted by:
toivo
(203.19.130.---)
Date: January 02, 2008 01:32PM
Hi,
If you are accessing the MySQL database from a web application, it does not matter where the browser client is, the username your application is using for the MySQL connection always accesses the database from the host 'localhost'. Therefore, if the username and password are valid for the host 'localhost', your application should be able to access the database.
However, if you are trying to access the MySQL database using a client application running on your workstation like MySQL Administrator or SQLyog, you need to make sure that the host appearing under the username your application uses to connect is the accurate name of the computer.
In the local LAN the host is likely to be the IP address of your workstation, but if you connect from the internet, the name of the host is the computer name of your workstation followed by the domain name, which is extracted from the ISP's internet connection or your corporate VPN. Even though it is possible to use a wildcard '%' as a host, you may not want to do that for security reasons.
Regards,
toivo
Sydney, Australia