Create Schema assign Permission January 17, 2011 mysqladmin -u root create <DBNAME> grant all on <USERNAME> .* to ' <DBNAME>'@'localhost' identified by '<PASSWORD>' with grant option; grant all on <USERNAME>.* to ' <DBNAME>'@'localhost.localdomain' identified by '<PASSWORD>' with grant option; Read more