mysql -h web.eecs.utk.edu -p databasenamewith the following information:
set password = password("New Password");
source /home/bvz/cs465/lectures/sql/createdb.sql;where you replace my filename with your file name. Do not use quotes and you must provide the full pathname of the file.
mysql> \! clearwill clear your screen. Similarly,
mysql> \! lswill list the contents of the current directory on a Unix workstation. If it's easier to remember, you can also type system at the mysql prompt, and then your command. For example:
mysql> system clear
show tables;