title:MySQL notes
description:Hints and notes for getting started with MySQL
keywords:mysql,table,create,database,


By default, MySQL has the admin user "root". You can start the command
line mysql, but you'll discover that your options are limited. For
instance, you won't be able to create a new database.

Use this command:
mysql -u root -- password

You'll be prompted for the root password that you set using mysqladmin.

Here are some common command line arguments for the command line tool
mysql:


-h host
-u userid
dbname
-p  (prompt for password)

mysql -h dbserv.data.example.com  -u db_user db_name -p


show tables;

show columns from table annot;

http://dev.mysql.com/doc/mysql/en/SHOW.html

As far as I can tell, C-c will exit mysql, and there is no way to
cancel a command. Often you can just type some gibberish, and mysql
will give an error instead of running the command. (As opposed to the
PostgreSQL psql, which is a fully functional shell, complete with two
types of help, command line editing, history editing and the ability
to cancel commands.)