python ssl mysql_Python MySQL连接器无法使用SSL

我最近在MySQL服务器上配置了SSL，它似乎破坏了python应用程序。我可以通过命令行连接到服务器：user@kiosk:~$ mysql -u -p -h

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 19

Server version: 5.7.25-0ubuntu0.18.04.2 (Ubuntu)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

SSL似乎在处理连接：

^{pr2}$

用户被配置为需要SSL，而我目前没有使用客户机上的CA/client-cert/client密钥进行连接(据我所知，这是可选的)。在

我的python脚本使用一个简单的连接：db_ip_address = raw_input('Ip Address: ')

db_username = raw_input('Username: ')

db_passwd = raw_input('Password: ')

try:

db = mysql.connector.connect(

host=db_ip_address,

user=db_username,

passwd=db_passwd,

)

cursor = db.cursor()

connected = True

except Exception as e:

installer.fatal('\r\n Failed to connect to SQL server please try again \r\n')

print traceback.format_exception_only(type(e), e)[0]

现在由于以下错误而失败：ProgrammingError: 1045 (28000): Access denied for user ''@'' (using password: YES)

我假设这是由于我的SSL配置造成的，但是我不完全确定为什么mysql CLI可以正常工作，但是我的脚本却不能？在

任何洞察力都将不胜感激。在