发布于 4年前

pycharm连接本地mysql失败

import pymysql
<span class="token triple-quoted-string string">"""
1、连接本地数据库
2、建立游标
3、创建表
4、插入表数据、查询表数据、更新表数据、删除表数据
"""

def create_table():
    #连接本地数据库
    db = pymysql.connect("localhost","root","123456","test")

    #创建游标
    cursor = db.cursor()
    #如果存在student表,则删除
    cursor.execute("DROP TABLE IF EXISTS student")

    #创建student表
    sql = <span class="token triple-quoted-string string">"""
    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("创建数据库失败:case%s"%e)
    finally:
        #关闭游标连接
        cursor.close()
        # 关闭数据库连接
        db.close()

def main():
    create_table()

if __name__ == "__main__":
    main()</span></span>

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

pycharm连接本地mysql失败,出现以下问题:

问题:

Server returns invalid timezone. Go to 'Advanced' tab and <span class="token builtin">set 'serverTimezone' <span class="token builtin">property manually. </span></span>

在这里插入图片描述

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

在这里插入图片描述
翻译一下错误“ The server time zone value ‘Öйú±ê׼ʱ¼ä’ is unrecognized or represents more than one time zone”是时区不对
解决办法:
故在URL后面加上?serverTimezone=GMT%2B8 解决问题

在这里插入图片描述

©2020 edoou.com   京ICP备16001874号-3