博观约取，厚积薄发

系统：ubuntu 20.4mysql 版本： 8.0.28-0ubuntu0.20.04.3 (Ubuntu)问题：mysql -u root -p # 失败sudo mysql -u root -p # 成功原因：mysql 对 root用户 使用了auth_socket plugin进行认证。sudo mysql -u root -puse mysql;select user,host,plugin from user;update user set plug

sudo cat /etc/mysql/debian.cnfuser = debian-sys-maintpassword = xxxxximport pandas as pdfrom sqlalchemy import create_enginehost = '127.0.0.1'db = 'test'user = 'debian-sys-maint'password = 'xxx'print(str(r"mysql+pymysql://%s:" + '%s' + ..

LOAD DATA INFILE '/home/xx/xxx.csv'当我使用 上面的 SQL 语句将 csv 文件 导入 mysql 时候，出错：ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement查看官方文档，secure_file_priv参数用于限制LOAD DATA, SELECT …OUTFIL.