MYSQL Server Connection

MYSQL Connection To Server

Host, user and password parameters are needed to connect the mysql server. We have to connect server like this

shell>mysql -h host -u user -p
Enter Password: *******

host – Where MYSQL server is running user – username of MYSQL server password – password of MYSQL server When server is connected, it show like this message

shell> mysql -h host -u user -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25338 to server version: 5.6.13-standard

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

mysql>

When server is not connected, it show like this message

 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' 

MYSQL Disconnect From Server

To disconnect the server, use the “QUIT” command at mysql prompt

shell>mysql
mysql>QUIT