使用mysql-connector-python 8.0.33版本的包去连接goldendb8.9.99，报错Error:1064(HY000):you have an error in your sql syntax;check the manual that corresponds to your DB server version for the right syntax to use near ‘’utf8_general_ci'' at line 1，采用的连接代码如下：
import mysql.connector
config = {
'user': 'your_username',
'password': 'your_password',
'host': 'your_host',
'port': 7777,
'database': 'your_database',
'auth_plugin': 'mysql_native_password',
'charset': 'utf8'
}
try:
conn = mysql.connector.connect(**config)
cursor = conn.cursor()
cursor.execute("SELECT 1;")
print("Connection successful")
except mysql.connector.Error as err:
print(f"Error: {err}")
finally:
if 'conn' in locals() and conn.is_connected():
cursor.close()
conn.close()
请问这是什么原因？？？？？
报错是SQL语法问题, 但报错内容和SQL关系不大, 估计是驱动的问题,或者编码的问题. 你可以换pymysql试下, 没条件的话, 可以下这个mini版的pymysql:https://github.com/ddcw/ddcw/tree/master/python/minipymysql
之前在内网没得条件的时候,就是写的这个脚本去测试的goldenDB的连接的.
例子(和pymysql一样的用法,只是很多东西写死了的,但不影响使用.):
import pymysql
conn = pymysql.connect(
host='192.168.101.21',
port=3314,
user='root',
password='123456',
)
cursor = conn.cursor()
cursor.execute('select "ddcw"')
cursor.fetchall()
评论
有用 1
墨值悬赏