Warning password insecure - Mysql backup with Python

[HyiikO]

I made this little script with Python to create a backup of a table from my database:

import subprocess
sql_cmd = 'mysql -B -uUser -p password database -e "SELECT * FROM device;" > file.csv'
subprocess.run([sql_cmd], shell=True)

It is working, but I got this warning message:

mysql: [Warning] Using a password on the command line interface can be insecure.

I would like to solve this problem if someone can help me please

Thanks ^^

[wavic]

OS?..

The message is too short. Please enter a message longer than 5 characters.

Next time I will add periods like that

[r3d_f0x]

That looks like a MySQL warning. You could try a way to securely store the password.

[nilamo]

Instead of using subprocess to invoke the command line client, you could use a mysql api to query the database directly. That would eliminate the "password using command line" issue.

[snippsat]

As mention bye @nilamo there are tool for this in Python to connect directly.
PyMySQL pure-Python MySQL client library
mysqlclient