Editing MySQL basics (section)

== Getting Started with MySQL ==

=== Connecting to MySQL ===
To access a MySQL db you need:<br>
- user name and password<br>
- host name or IP<br>
- name of db

=== Two ways to access MySQL directly ===

* command line:
** telnet
** SSH (recommended due to enhanced security)
* MySQL client programs [<code>mysql, mysqladmin, mysqldump</code>]

=== To access a database from the command line ===

<code>mysql -u username -ppassword -h hostname databasename</code>

Note: There is no space between the -p and the password. Password after -p is optional here. If left blank, you will be prompted to enter your password.

Alternatively, you can use <code>mysql -u root -p</code> then enter password at prompt.

Perform SQL dump from CLI

<code>mysqldump -u username -ppassword -h hostname databasename > filename.sql</code>

=== Using MySQL Client Programs ===

Install the client programs