you want to do something like this $ su # mysqladmin create openstreetmap # mysql > grant all privileges on openstreetmap.* to 'openstreetmap'@'localhost' identified by 'openstreetmap'; > exit # exit $ mysql openstreetmap -u openstreetmap -p < db/create_database.sql