Working on server with shell access.
- mysql -u yourusernamewithadminrights -p;
- create database yournewdatbasename;
For security you should make a new user with a different password for each database . This will keep it secure like submarine. If one program and db are cracked the others should be safe
To create and grant privileges to a user now being created
- CREATE USER ‘youruser’@’localhost’ IDENTIFIED BY ‘yourpassword’;
- GRANT ALL PRIVILEGES ON yourdb.* to ‘youruser’@’localhost’