import pymysql

conn = pymysql.connect(host='localhost',

user='root',

passwd='h5zhuang',

port=3306,

db='news',

charset='utf8'

)

cursor = conn.cursor()

cursor.execute("SELECT * FROM `news` ORDER BY `created_at` DESC")

result = cursor.fetchall()

print(result)

pymysql.err.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)")

hanlindembp:python_mysql hanlinzhuang$

上面显示

(using password: NO)")

但是我的在终端中打 mysql -u root -p之后我需要输入我的密码h5zhuang才能进去 所以我是设置过密码的