MySQL Notes


Revision as of 15:38, 14 April 2008 by Hutch (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search
  • To list the databases on a MySQL server:
show databases;
  • To select a database on a MySQL server:
use database;
  • To list the tables in a MySQL database:
show tables;
  • To list the schema of a table in a MySQL database:
desc table;
  • To securely provide a user password automatically, place user passwords within the [client] section of ~/.my.cnf. The file should have 600 or 400 permissions. e.g.,

5.5.6. Keeping Your Password Secure

Personal tools