MySQL Notes - Revision history

Hutch at 15:38, 14 April 2008

2008-04-14T15:38:39Z

←Older revision		Revision as of 15:38, 14 April 2008
Line 7:		Line 7:
	* To list the tables in a MySQL database:		* To list the tables in a MySQL database:
	show tables;		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.,		* 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.,

Hutch at 15:38, 14 April 2008

2008-04-14T15:38:16Z

←Older revision		Revision as of 15:38, 14 April 2008
Line 1:		Line 1:
	* To list the databases on a MySQL server:		* To list the databases on a MySQL server:
	show databases;		show databases;
		+
		+	* To select a database on a MySQL server:
		+	use ''database'';

	* To list the tables in a MySQL database:		* To list the tables in a MySQL database:

Hutch at 15:33, 14 April 2008

2008-04-14T15:33:12Z

←Older revision		Revision as of 15:33, 14 April 2008
Line 1:		Line 1:
		+	* To list the databases on a MySQL server:
		+	show databases;
		+
		+	* To list the tables in a MySQL database:
		+	show tables;
		+
	* 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.,		* 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.,
	[client]		[client]
	password="''password''"		password="''password''"
	[http://dev.mysql.com/doc/refman/5.1/en/password-security.html 5.5.6. Keeping Your Password Secure]		[http://dev.mysql.com/doc/refman/5.1/en/password-security.html 5.5.6. Keeping Your Password Secure]

Hutch at 15:28, 14 April 2008

2008-04-14T15:28:42Z

←Older revision		Revision as of 15:28, 14 April 2008
Line 1:		Line 1:
-	* To securely provide a user password ~~non-interactively~~, place user passwords within the ''[client]'' section of ''~/.my.cnf''. e.g.,	+	* 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.,
	[client]		[client]
	password="''password''"		password="''password''"
	[http://dev.mysql.com/doc/refman/5.1/en/password-security.html 5.5.6. Keeping Your Password Secure]		[http://dev.mysql.com/doc/refman/5.1/en/password-security.html 5.5.6. Keeping Your Password Secure]

Hutch: New page: * To securely provide a user password non-interactively, place user passwords within the ''[client]'' section of ''~/.my.cnf''. e.g., [client] password="''password''" [http://dev.mysql.c...

2008-04-14T15:28:00Z

New page: * To securely provide a user password non-interactively, place user passwords within the ''[client]'' section of ''~/.my.cnf''. e.g., [client] password="''password''" [http://dev.mysql.c...

New page

* To securely provide a user password non-interactively, place user passwords within the ''[client]'' section of ''~/.my.cnf''. e.g.,
[client]
password="''password''"
[http://dev.mysql.com/doc/refman/5.1/en/password-security.html 5.5.6. Keeping Your Password Secure]