Код:
connection = pymysql.connect(host=host,user=userbd,password=passw,db=db)
with connection.cursor() as cursor:
sql = 'SELECT players
from lobby
where lobby_id
= '+game_id
temp = cursor.execute(sql)
print(sql)
print(temp)
Ты в хосте локал хост использовал?