Connecting To And Disconnecting From The Server

• The following is needed to connect to the server:
  • A MySQL user name
  • A password.
  • If the server runs on another machine the host name needs to be specified.
  • For example:

    mysql -h host -u user -p
    

    Enter password: ********

• To connect anonymously to the server running on the local host just enter mysql.

• When a connection is successfully established, the system responds with:

  Welcome to the MySQL monitor. Commands end with ; or \g.
  

  Your MySQL connection id is 11331 to server version: VERSION
  

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

  mysql>

  • The mysql> prompt indicates that mysql is ready to accept commands.

• If, when attempting to log in, the error message Can't connect to local MySQL server through socket '/tmp/mysql.sock' appears, it means the MySQL server daemon is not running.

• To disconnect type QUIT or \q at the mysql> prompt.

How do I enter commands?

---

---

© 2007 John Michael Pierobon

Notes