Spark sql - MySQL connectivityissue

Hi,

I am getting the Error : Access denied for user ‘retail_user’@'gw03.itversity.com
screenshot attached. Kindly suggest?

df1=spark.read.format(“jdbc”).
option(“url”,“jdbc:mysql://nn01.itversity.com:3306/”).
option(“driver”,“com.mysql.jdbc.Driver”).
option(“user”,“retail_user”).
option(“password”,“itversity”).
option(“dbtable”,“retail_db.orders”).
load()

Looks like I was using some incorrect url.

df1=spark.read.format(‘jdbc’).
option(‘url’,‘jdbc:mysql://ms.itversity.com:3306/’).
option(‘driver’,‘com.mysql.jdbc.Driver’).
option(‘user’,‘retail_user’).
option(‘password’,‘itversity’).
option(‘dbtable’,‘retail_db.order_items’).
load()

This is working!