Access A Database

• Use the SHOW statement to find out what databases currently exist on the server.

  mysql> SHOW DATABASES;

• MySQL starts out with two databases.
  • The mysql database describes user access privileges.
  • The test database is a workspace for users to try things out.

• To access a database use the USE command.
  • USE does not require a semicolon.
  • USE must be executed on one line.
  • For example:

    mysql> USE test

How do I create a database?

---

---

© 2007 John Michael Pierobon

Notes