Changes between Initial Version and Version 1 of mysql_command_line_access

Timestamp:

Dec 21, 2010, 6:45:42 PM (15 years ago)

Author:

Ross

Comment:

--

mysql_command_line_access

@@ +1 @@
+[[PageOutline]]
+= Mysql Command Line Access =
+
+In order to get command line access to mysql servers, each database must have a unique .my.cnf file specifying the database, username and password.
+
+== .my.cnf ==
+
+A .my.cnf file should have the following structure:
+
+{{{
+[client]
+user=USERNAME
+password=PASSWORD
+[mysql]
+database=DATABASENAME
+}}}
+
+Where USERNAME = the mysql_db user, PASSWORD = the mysql db_user password, and DATABASENAME = the mysql_db name.
+
+== Using multiple databases ==
+
+Each individual database should contain its own .my.cnf file.  You can access multiple databases by naming database specific files with .my.db_name.cnf and then issuing the mysql command:
+
+{{{
+mysql --defaults-file=.my.db_name.cnf
+}}}
+