The most important directories in your MySQL installation are bin (executable programs), data (database data), and docs (documentation).
The two programs you will use the most are mysqld, the MySQL server, and mysql, the command-line client.
You have a choice of several
interfaces/client programs. We discussed mysql (command-line), MySQLCC (GUI), and phpMyAdmin (Web-based).
The mysql command-line program has many useful command-line switches and options. We have discussed
(to specify username),
(to log in with a password),
(to specify the host), and
(for damage-control mode).
When logged in, you can use
to get a list of what is in the system and
to get information about a particular table.
You can log out with
You can terminate commands with
to send them to the server for execution.
You can execute a file of commands from inside the client with
and from outside the client by using file redirection.