Difference between revisions of "MySQL basics"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
== Getting Started == | == Getting Started with MySQL == | ||
=== Connecting to MySQL === | === Connecting to MySQL === | ||
To access a MySQL db you need:<br> | |||
- user name and password | |||
- host name or IP | |||
- name of db | |||
=== Two ways to access MySQL directl === | |||
mysql -u username -ppassword -h hostname databasename | * command line | ||
** telnet or 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. | Note: There is no space between the -p and the password. | ||
=== Using MySQL Client Programs === | |||
Install the client programs | |||
Revision as of 12:14, 15 July 2007
Getting Started with MySQL
Connecting to MySQL
To access a MySQL db you need:
- user name and password
- host name or IP
- name of db
Two ways to access MySQL directl
- command line
- telnet or SSH (recommended due to enhanced security)
- MySQL client programs [
mysql, mysqladmin, mysqldump]
To access a database from the command line
mysql -u username -ppassword -h hostname databasename
Note: There is no space between the -p and the password.
Using MySQL Client Programs
Install the client programs