grant all on databasename.* to username@host identified by 'password'; flush privileges;
oh and you dont need to grant 'all' you can specify what you want that user to be able to do, ie create, drop, delete etc...
thanks _______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
