The error might be on parameter password instead of passwd

mysq = mysql.connector.connect(user = 'root',password = 'manager',host = 'localhost', database = 'krishna')

I think it is better to print(mysq) as well to check the output.

You can check this https://www.w3schools.com/python/python_mysql_select.asp for reference