I have a bash script that logs into MySQL and creates a database. It has a sequence that requests the MySQL credentials (username and password) and then executes

```
read username
read password
read databasename
mysql -u$username -p$password -e "CREATE DATABASE $databasename;"

```

whenever I run this script, I get the warning "Using a password on the command line interface can be insecure"

What is the right, secure way to create a script like this where you need to log into MySQL and then run a command?