UnicodeEncodeError: 'ascii' codec can't encode characters in position 0-4: ordinal not in range(128)

出现报错，网上搜的方法都不管用,求大佬帮忙看看

# -*- coding:utf-8 -*-
import importlib
import sys

importlib.reload(sys)
import os
os.environ['NLS_LANG'] = 'Simplified Chinese_CHINA.ZHS16GBK'
import cx_Oracle as cx
import pymssql
import pandas as pd

serverName ='10.xxx.xx.xxx'
userName = 'xx'
passWord = 'xxxxxx'
database = '数据统计库'

conn = pymssql.connect(serverName , userName , passWord, database)
cursor = conn.cursor()

sql = 'select * from 日数据' 
cursor.execute(sql) #读取数据
all_date = cursor.fetchall() 
data = pd.DataFrame(list(all_date),columns = ['ID','SID','TT','BA','BC','BCMX','BCMXT','BCMN','BCMNT','SJWZX'])
data.to_excel(r'D`:\test.xlsx')

mysq版本过高，新版的mysql使用新的用户密码加密方式，所以你无法连接数据库，直接报错