mysql: [warning] using a password on the command line interface can be insecure.

                
                        One method that is convenient (but equally insecure) is to use:

MYSQL_PWD=xxxxxxxx mysql -u root -e "statement"