I currently have 67 Wordpress sites on Cpanel with nginx reverse proxy. As I have nginx in front, none of the servers are overwhelmed but not really good performance.
So, I spun up a ee vm to test whether I can get better performance with ee.
I have three scripts that run as wordpress user and updates the mysql database directly, DAILY. Actually one runs every hour and one runs twice daily. I having no success running the script manually or as they normally run under chron. I was able to use wp commands to upload the sql database but all the scripts fail with error establishing a database connection unable to use mysql.lock.
What do I need to do to get these scripts to connect to the database?