Connection probs due to unskilled webmasters

[summertime]

I asked several webspace-hoster if they can say, if connections to their mySQL-tables by sqlYog work or don't work. It was interesting to see, that most did not understand the question; most did not understand, what I meant with “external connection” trough ODBC, ADO or mySQLyog.

Skilled webmasters answered so:

“By default when the mysql users are created through cpanel, only localhost is in the access list. If you would like to

connect to the mysql from remote hosts you can add the remote hosts to the access list in cpanel.”

To solve the problem – for avoiding to use php-tunnel – one can mail to the unskilled webmasters some text of the mySQL-documentation (http://dev.mysql.com/doc/mysql/en/Access_denied.html) like

“A common problem here is that the Host value in the user table entry specifies an unqualified hostname, but your system's name resolution routines return a fully qualified domain name (or vice versa). For example, if you have an entry with host 'tcx' in the user table, but your DNS tells MySQL that your hostname is 'tcx.subnet.se', the entry will not work. Try adding an entry to the user table that contains the IP number of your host as the Host column value. (Alternatively, you could add an entry to the user table with a Host value that contains a wildcard; for example, 'tcx.%'.”

or

“You can fix this by setting up an account for the combination of client hostname and username that you are using when trying to connect. If you don't know the IP number or hostname of the machine from which you are connecting, you should put an entry with '%' as the Host column value in the user table.”

So the *web-master* has the duty to make a working user-table with the right *host value*.

If one has connect-problems I would suggest to let them first solve through the webhoster and to announce a changement of webhoster, because there are plenty webhosters who do their job right, configuring the user-table with the right “host” properties.

A whitelist of the “good” webhosters can be also be created here in this forum — a new job for Shadow ?!? 😉

[Shadow]

Then most of the Hungarian providers will not be included in the list…

Anyway, we kept telling people with such problems to resolve it with their ISP first!

[Ritesh]

Check out http://www.webyog.com/forums/index.php?act…st=0&#entry3610

[Author]

Posts