To logon to the MySQL server type the following at the command prompt:
|mysql -u username -pSecret|
*Note: there is NO SPACE between the -p and the actual password (in this example: ‘Secret’ )
IF you leave a space after -p, you will prompted for the password:
This will log you on to the server and provide the mysql> prompt:
|Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 50
Server version: 5.5.28 MySQL Community Server (GPL)
Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
Once logged on, all commands must be terminated with a semi-colon ;
\! clear to clear the screen (\! executes a shell command)
\s to see the current status information of the server
\q to quit