Connecting to a MySQL Database from the Command Prompt

Connecting to a MySQL database from the command prompt 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 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.

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.