Welcome to WebmasterWorld Guest from 18.104.22.168
Forum Moderators: bakedjake
mysql -u username -p databasename
-pswitch is for. You could actually type in your password directly after the switch, but that is bad practice as it is entered into the bash logs where anybody with access to the logs will find your open text password.
More info on the MySQL command line options:
Just so you know where I'm coming from, I have plesk installed on this server and so far, I've set up all my databases in plesk.
Failing that I assume the password must be stored in the Plesk configuration somewhere if Plesk enables you to create databases. (I don't know Plesk so I've no idea where to look).