Login to MYSQL Database

This code illustrates loging in to a MYSQL database with the database selected, in this instance the MythTV database mythconverg.

To login and edit the mythtv database mythconverg use:

mysql mythconverg -u root -p

where -u is specifying the username of root and -p says to request the password

gate:/home/nt/# mysql mythconverg -u root -p

Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 121
Server version: 5.0.51a-24+lenny1 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

NAT July 2009