At 05:19 PM 07/13/2001 , you wrote:
>Hi,
>
>I would like to be able to create some tables in a database on an SQL server
>at my web provider, then access those tables via a client application
>running on my PC over the Internet (dial-up connection). My understanding is
>that the client application accesses the SQL server via TCP/IP and not ODBC.
>
>My web provider says no way. They can enable an ODBC connection for one
>static IP address, which is not an acceptable solution, because a) I don't
>want to use ODBC, and b) my dial-up connection may use one of a range of IP
>addresses. They will not let me have direct TCP/IP access to the database.
>
>My question is why my ISP would say this. Of course the database is password
>protected, so I don't see why direct access is any more a security risk than
>using their web-based client. Is this common practice among ISPs, or do I
>need to shop for a new one? Any suggestions?
Bruce;
I have been following this thread, and I'm a little confused.
I am a web hosting provider, quite small, but I have some very well
connected collocation boxes, one of which is newly setup with
MySql/PHP/SSL/ssh1&2 and optional Telnet. A full blown IP based hosting
package on my box is $19.95/mo.
Ok, enough advertising. What I'm confused about, and maybe missing
something here, is why an ISP/WHP would not grant you remote access to your
MySQL database?
When I setup the grant tables for a user I give them access to ADD, DROP,
etc. for their database only. They don't have access to anyone else's
database. So where is the security risk. Generally I don't have telnet
running, and by default I allow remote access via ssh 1 or 2. If the user
wants to start and run telnet in their own server area that's up to
them--they get to clean up after the crackers themselves.
The main box is a Solaris, running Ensim Appliance software, and each
webhost has RH 6.0, Apache, PHP4, and MySQL 3.22.32. MySQL will be upgraded
next month.
I am new to administering MySQL, so I would be happy to cut my price
substantially to anyone who needs a virtual home in exchange for a little
help in understanding and using MySQL.
Please don't take this as a blatant opportunity to advertise, that's not my
intention--however, feedback or criticism gladly accepted.
Joe
>--
>Bruce Vander Werf
>[EMAIL PROTECTED]
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php