mysql -u root -p
mysql> create database prosody;
mysql> grant usage on *.* to prosody@localhost identified by 'extremelySECRET';
mysql> grant all privileges on prosody.* to prosody@localhost;