mysql

MySQL - Introduction
MySQL Introduction
MySQL Installation
MySQL Installation
MySQL Administration
MySQL Administration
MySQL PHP Syntax
MySQL Connection

MySQL BASICS
MySQL Create Database
MySQL Transactions
MySQL Alter Command
MySQL Indexes
MySQL Temporary Tables
MySQL Clone Tables
MySQL Database Info
MySQL Using Sequences
MySQL Handling Duplicates
MySQL SQL Injection
MySQL Database Export
MySQL Database Import
MySQL Vs SQL
Grant_ Revoke Privilege
MySQL Regexps
MySQL NULL Values
MySQL Drop Database
MySQL Select Database
MySQL Datatypes
MySQL Create Tables
MySQL Drop Tables
MySQL Insert Query
MySQL Select Query
MySQL Where Clause
MySQL Update Query
MySQL Delete Query
MySQL Like Clause
MySQL Sorting Results
MySQL Using Join
MySQL TRIGGERS

MySQL - Connection

MySQL - Connection

MySQL Connection Using MySQL Binary :

You can establish the MySQL database using the mysql binary at the command prompt.

Example

Here is a simple example to connect to the MySQL server from the command prompt :

[root@host]# mysql -u root -p
Enter password:******

This will give you the mysql> command prompt where you will be able to execute any SQL command. Following is the result of above command :

The following code block shows the result of above code :

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2854760 to server version: 5.0.9

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

In the above example, we have used root as a user but you can use any other user as well. Any user will be able to perform all the SQL operations, which are allowed to that user.

You can disconnect from the MySQL database any time using the exit command at mysql> prompt.