pycharm链接MySQL失败_pycharm连接本地mysql失败

import pymysql

"""

1、连接本地数据库

2、建立游标

3、创建表

4、插入表数据、查询表数据、更新表数据、删除表数据

"""

def create_table():

#连接本地数据库

db &＃61; pymysql.connect("localhost","root","123456","test")

#创建游标

cursor &＃61; db.cursor()

#如果存在student表&＃xff0c;则删除

cursor.execute("DROP TABLE IF EXISTS student")

#创建student表

sql &＃61; """

CREATE TABLE IF NOT EXISTS FANUC_DROP(

id int UNSIGNED AUTO_INCREMENT,

x int not null,

y int not null,

z int not null,

PRIMARY KEY ( id )

)

"""

try:

# 执行SQL语句

cursor.execute(sql)

print("创建数据库成功")

except Exception as e:

print("创建数据库失败&＃xff1a;case%s"%e)

finally:

#关闭游标连接

cursor.close()

# 关闭数据库连接

db.close()

def main():

create_table()

if __name__ &＃61;&＃61; "__main__":

main()

db &＃61; pymysql.connect("localhost","root","123456","test")这句代码要想成功连接数据库&＃xff0c;还需要pycharm连接mysql数据库。

pycharm连接本地mysql失败&＃xff0c;出现以下问题&＃xff1a;

问题&＃xff1a;

Server returns invalid timezone. Go to &＃39;Advanced&＃39; tab and set &＃39;serverTimezone&＃39; property manually.

The specified database user/password combination is rejected: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value &＃39;Öйú±ê׼ʱ¼ä&＃39; is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.

翻译一下错误“ The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone”是时区不对

解决办法&＃xff1a;

故在URL后面加上?serverTimezone&＃61;GMT%2B8 解决问题