> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MindsDB and MySQL CLI

MindsDB provides a powerful MySQL API that allows users to connect to it
using the MySQL Command Line Client.

Please note that connecting to MindsDB's MySQL API is the same as connecting to
a MySQL database. Find more information on MySQL CLI
[here](https://dev.mysql.com/doc/refman/8.0/en/mysql.html).

<Tip>
  By default, MindsDB starts the `http` and `mysql` APIs. You can define which APIs to start using the `api` flag as below.

  ```bash theme={null}
  python -m mindsdb --api http,mysql,postgres
  ```

  If you want to start MindsDB without the graphical user interface (GUI), use the `--no_studio` flag as below.

  ```bash theme={null}
  python -m mindsdb --no_studio
  ```
</Tip>

## How to Connect

To connect MindsDB in MySQL, use the `mysql` client program:

```bash theme={null}
mysql -h [hostname] --port [TCP/IP port number] -u [user] -p [password]
```

Here is the command that allows you to connect to MindsDB.

```bash theme={null}
mysql -h 127.0.0.1 --port 47335 -u mindsdb
```

On execution, we get:

```bash theme={null}
Welcome to the MariaDB monitor.  Commands end with ";" or "\g".
Server version: 5.7.1-MindsDB-1.0 (MindsDB)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]>
```

## What's Next?

Now that you are all set, we recommend you check out our [Use Cases](/use-cases/overview) section, where you'll find various examples of regression, classification, time series, and NLP predictions with MindsDB.

To learn more about MindsDB itself, follow the guide on [MindsDB database structure](/sql/table-structure/). Also, don't miss out on the remaining pages from the **MindsDB SQL** section, as they explain a common SQL syntax with examples.

Have fun!