MySQL备份警告密码insecu

Question

我用Python编写了一个小脚本，用于从数据库创建表的备份：

import subprocess
sql_cmd = 'mysql -B -u User -pPassword  -e Database "SELECT * FROMdevice;" > file.csv'
subprocess.run([sql_cmd], shell=True)

它正在工作，但我收到了一条警告消息：mysql: [Warning] Using a password on the command line interface can be insecure.

我想隐藏或删除警告，如果可能的话。在

Answer 1

从输入中获取密码

import subprocess
import getpass

pswd = getpass.getpass('Password:')
sql_cmd = 'mysql -B -u User -p pswd  -e Database "SELECT * FROMdevice;" > 
file.csv'
subprocess.run([sql_cmd], shell=True)