RE: secure host and user name for non static ip address

2007-10-11 Thread Doug Phillips
> QUESTION: What are the most secure permissions settings for > administrator > access to connect to my server without using a static IP address? Assuming a unix server (or even a windows server running SSH), use an SSH tunnel, and then connect to 127.0.0.1:whatever_port_you_chose. You get the e

Re: secure host and user name for non static ip address

2007-10-11 Thread Michael Cole
My take on this never have no password.. At no time any data you have someone else will also want therefore running a open query with nopasword on the system for a couple of hours will get access to your system.. Allways use passwords, If the users dont want passwords then you dont need any membe

Re: secure host and user name for non static ip address

2007-10-09 Thread Gary Josack
Sign up for dyndns.com or some other similiar service. Create permissions to the domain and run a script that updates you IP with dyndns whenever it changes. (such scripts already exist). As far as "'username'@'%' with no password with SELECT, INSERT, UPDATE and DELETE privileges"... worst ide

secure host and user name for non static ip address

2007-10-09 Thread Stephen Sunderlin
QUESTION: What are the most secure permissions settings for administrator access to connect to my server without using a static IP address? MY ISP changes my DSL ip address almost daily so when I log on to MySQL Administrator with 'myusername'@'currentipaddress' using password 'mypassword' I