 | | | -none- | -none- 2007-10-09 - By Gary Josack
Back
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/mysql?unsub=mysql@(protected)
|
|
|