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 idea ever in my opinion. Anyone that
knows your server/username can get in query and delete records.
Stephen Sunderlin wrote:
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 have grant permission to the new ip address.
I also have and account: 'username'@'%' with no password with SELECT,
INSERT, UPDATE and DELETE privileges only for general users for this
membership site. Are there any security issues with this? Any input or
direction for informed reading on the issue would be appreciated.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
