MySQL: Grant

Full access from local machine only
grant all privileges on *.* to 'testuser'@'localhost' identified by 'pass' with grant option;

Full access from any machine except localhost
grant all privileges on *.* to 'testuser'@'%' identified by 'pass' with grant option;

Full access from any machine
grant all privileges on *.* to 'testuser'@'localhost' identified by 'pass' with grant option;
grant all privileges on *.* to 'testuser'@'%' identified by 'pass' with grant option;


Roger
Roger Hall
COMPUSPEC
Google
 
Web Compuspec.net
Valid XHTML 1.0!
Valid CSS!