PDA

View Full Version : Is there a way to give access to any IP?


Jezebell
04-02-2004, 06:29 PM
for instance

grant all privileges on *.* to username@localhost identified by 'password' with grant option;

is there a way to make "localhost" a variable like *.*.*.*?

I want to be able to give myself access to the db from any IP with my username and password.

KhaN
04-02-2004, 08:26 PM
grant all privileges on *.* to username@'%' identified by 'password' with grant option;

Monrezz
04-03-2004, 01:08 AM
GRANT ALL PRIVILEGES ON eq.* TO username@'%' IDENTIFIED BY 'password';

...this would be safer. Restricts access to the eq database (change eq to whatever your database is called). Change username and password, of course.

Jezebell
04-03-2004, 02:09 AM
Thanks guys!