sqlalchemy connection error - Unknown MySQL server host

I m trying to perform a connection to mysql via sqlalchemy.

note - I access my db in ssms through windows auth

I am receiving this error - sqlalchemy connection error - Unknown MySQL server host

I have tried the same connection via the same parameters through pyodbc.connect and it is successful.

I have grabbed the db ip adress via the below commands.

SELECT  
   CONNECTIONPROPERTY('net_transport') AS net_transport,
   CONNECTIONPROPERTY('protocol_type') AS protocol_type,
   CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,
   CONNECTIONPROPERTY('local_net_address') AS local_net_address,
   CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,
   CONNECTIONPROPERTY('client_net_address') AS client_net_address

My python script to establish a connection is like below.

import mysql.connector
import sqlalchemy
database_username = 'xyz'
database_password = 'abc'
database_ip       = 'xx.x.x.xxx'
host = 'abcd65'
port = 1433
database_name     = 'lmn'
database_connection = sqlalchemy.create_engine('mysql+mysqlconnector://{0}:{1}@{2}/{3}'.
                                                format(database_username, database_password, 
                                                      database_ip, database_name), pool_recycle=1, pool_timeout=57600).connect()

print(database_connection)

Note - I have also used host and port number too, but didn't help.