> grant all on databasename.* to username at 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