Get an SQL prompt first

mysql -u root -p

CREATE DATABASE sitename;
CREATE USER sitename@localhost IDENTIFIED BY 'some-strong-password';
GRANT ALL PRIVILEGES ON sitename.* TO sitename@localhost;
FLUSH PRIVILEGES;
exit