Norway


to a from the can be very easy:

[root@mypc]#mysql -S /opt/db/mysql//mysql.sock -uroot -prootPassword

Here, we are trying to connect to the MySQL database

  1. Installed in /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.

 

Visit the DevX Tip Bank

 



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here