# Connecting to mysql using presto (on AWS EMR without using EMR config properties)

#### Step1: create mysql.properties in //etc/presto/conf.dist/catalog/
```
connector.name=mysql
connection-url=jdbc:mysql://10.29.7.xx:3306
connection-user=harleenxx
connection-password=harleenxx
```
#### Step2: restart presto server
```
sudo restart presto-server
```
#### Step3: start presto cli
```
$ presto-cli
presto:default> select * from mysql.reatail_db.customers limit 10;
```