MySQL Server Logon

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:

 

Enter 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
affiliates. Other names may be trademarks of their respective
owners.

 

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

 

mysql>

 

 

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

Leave a Reply