Difference between revisions of "MySQL basics"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
=== Two ways to access MySQL directl === | === Two ways to access MySQL directl === | ||
* command line | * command line: | ||
** telnet | ** telnet | ||
** SSH (recommended due to enhanced security) | |||
* MySQL client programs [<code>mysql, mysqladmin, mysqldump</code>] | |||
=== To access a database from the command line === | === To access a database from the command line === | ||
Revision as of 12:28, 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
- 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