Tutorial by Examples

To access MySQL from the command line: mysql --user=username --password=pwd --host=hostname test_db This can be shortened to: mysql -u username -p password -h hostname test_db By omitting the password value MySQL will ask for any required password as the first input. If you specify password ...

This set of example show how to execute commands stored in strings or script files, without the need of the interactive prompt. This is especially useful to when a shell script needs to interact with a database. Execute command from a string $ mysql -uroot -proot test -e'select * from people' +...