Difference between revisions of "MySQL basics"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
<code>mysql -u username -ppassword -h hostname databasename</code> | <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. Password after -p is optional here. If left blank, you will be prompted to enter your password. | ||
=== Using MySQL Client Programs === | === Using MySQL Client Programs === | ||
Install the client programs | Install the client programs | ||
Revision as of 12:34, 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. Password after -p is optional here. If left blank, you will be prompted to enter your password.
Using MySQL Client Programs
Install the client programs