Connecting to a MySQL Database from the Command Prompt

Connecting to a MySQL database from the command prompt can be very easy:

[[email protected]]#mysql -S /opt/db/mysql//mysql.sock -uroot -prootPassword

Here, we are trying to connect to the MySQL database

  1. Installed in location /opt/db/
  2. Database Name is the database name
  3. -u indicates the parameter username, i.e. in this case it is root
  4. -p indicates the parameter password, in this case it is rootPassword

Most importantly, we are connecting using sockets, which is faster than any other type of connection.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: