Calling mysql in batch mode as Cron command - need for trailing "QUIT" ?

[rupertrealbear]

Hi

 

I managed to alter something in my MySQL database (on a VPS) by creating a user "cron" with no priviledges and then granting it a few table-specific priviledges in the database in question.  A small text file was created containing some MySQL statements:

mysql -h localhost -u cron < quick.txt

quick.txt just connected to the databse and updated the test field in a table called sample:-

USE crontest;
UPDATE sample SET test = "changes successful";

My plan is to use a cron job to perform some useful databse housekeeping one every minute.  I notice that you are advised to use the "QUIT" command (if calling mysql in batch while logged in on the local machine).

Would adding "QUIT;" at the end of quick.txt achieve that end?

 

[fenway]

Sure, why not?

[rupertrealbear]

I have since found that the call to mysql is closed automatically so there is no need to "QUIT"

[fenway]

It's close implicitly because the php thread terminates.