right, and any field but the username and password can be a *. with my laptop, i will normally make a very restrictive user and give myself access to all of my databases from any IP. this is so i can view the database, but i can only edit it from a secure link.
grant all privileges on *.* to winkydo@* identified by 'mypassword';
this way i can run mysql admin from my windows based laptop to connect to the database instance.
Last edited by winkydo; 12-27-2006 at 12:15 AM.