# Selecting MySQL Database
Once you get connected with the MySQL server, it is required to select a database to work with. This is because there might be more than one database available with the MySQL Server.
## Selecting MySQL Database from the Command Prompt
It is very simple to select a database from the mysql> prompt. You can use the SQL command **use** to select a database.
### Example
Here is an example to select a database called **TUTORIALS** −
```
[root@host]# mysql -u root -p
Enter password:******
mysql> use TUTORIALS;
Database changed
mysql>
```
Now, you have selected the TUTORIALS database and all the subsequent operations will be performed on the TUTORIALS database.
**NOTE** − All the database names, table names, table fields name are case sensitive. So you would have to use the proper names while giving any SQL command.
## Selecting a MySQL Database Using PHP Script
PHP uses **mysqli\_select\_db** function to select the database on which queries are to be performed. This function takes two parameters and returns TRUE on success or FALSE on failure.
### Syntax
```
mysqli_select_db ( mysqli $link , string $dbname ) : bool
```
Sr.No.
Parameter & Description
1
**$link**
Required - A link identifier returned by mysqli\_connect() or mysqli\_init().
2
**$dbname**
Required - Name of the database to be connected.
### Example
Try the following example to select a database −
Copy and paste the following example as mysql\_example.php −
```
Selecting MySQL Database
';
$retval = mysqli_select_db( $conn, 'TUTORIALS' );
if(! $retval ) {
die('Could not select database: ' . mysqli_error($conn));
}
echo "Database TUTORIALS selected successfully\n";
mysqli_close($conn);
?>
```
### Output
Access the mysql\_example.php deployed on apache web server and verify the output.
```
Database TUTORIALS selected successfully
```