I have a script that collects information and generates a CSV file with it.
I don’t have remote access to MySQL via port 3306 released, I just have access to phpmyadmin through the browser using login and password.
The codes I’ve found apparently only work by directly accessing the database via 3306.
Would it be possible to convert the CSV file to MySQL embed code and open the browser, login and run the embed code via Python? (Chromedriver?)
2
Answers
In PHPMyadmin you can choose CSV format on "Import" tab.
Yoy can use SQL command too… like below.
But in this case your Client need to have access to CSV file.
More in documentation: https://dev.mysql.com/doc/refman/8.0/en/load-data.html