Describe MySQL Connection using mysql binary.

Answer

Establishing connection to MySQL database using Mysql binary can be done at command prompt.

Mysql –u user_name –p

On entering the user name and password the mysql command prompt will be opened to execute any sql statement. 

MySQL Connection - September 30, 2009 at 18:00 pm by Vidya Sagar

Describe MySQL Connection using mysql binary.

The MySQL connection using mysql binary can be established by using the following command at os command prompt of unix.

mysql -u root –p

which connects to MySQL and launches mysql> prompt.