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


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

Leave a Reply