Press "Enter" to skip to content

mysqlconnection

Starting MySQL

What is the command to connect Mysql Server ?.

Before start with MySQL you should have login id and password. Like Mysql -u is for username 

-p is for password .

TYPE at command prompt 

 MYSQL

Example for Connect to MYSQL server

shell>mysql -u root -p
Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.5.16-log MySQL Community Server (GPL) Copyright (c) 2000, 2011, 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>