SQLContext load jdbc

Hi, I am trying to load JDBC table into data frame using following command -

sqlContext.read.format(“jdbc”).options(
url =“jdbc:mysql://nn01.itversity.com:3306/retail_db”,
dbtable=“customers”,
user=“retail_dba”,
password=“itversity”
).load().take(10)

It gives error

: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

Could you please help how to resolve?

Regards
Sumit

Provide these dependency libraries on runtime when you submit your application using the --jars option.

./spark-shell --jars /path/to/mysql-connector-java*.jar

How to pass this in command line? Do i need to submit job for this? Can i launch pyspark with these libraries

spark-shell --jars /path/to/mysql-connector-java*.jar