MySQLTuner script

From the MySQLTuner FAQ:

Question: Will MySQLTuner fix my slow MySQL server?

No. MySQLTuner is a read only script. It won't write to any configuration files, change the status of any daemons, or call your mother to wish her a happy birthday. It will give you an overview of your server's performance and make some basic recommendations for improvements that you can make after it completes. Make sure you read the warning above prior to following any recommendations.

The above leads me to believe that the answer to your question is no. However, I'm not a MySQL dba nor do I play one on tv. You take my advice at your own risk. YMMV.

Good luck.

-- sw

I'm just about to run the sqltuner script and it's brought up another question.

The script prompts for our MySQL administrative user credentials.

Please enter your MySQL administrative login:
Please enter your MySQL administrative password:

Does this have to be a MySQL user with ALL PRIVILEDGES (Global) or could I use a user with only SELECT (Global) privileges to minimize any risk of anything being changed by the script (which I know it shouldn't do).

Thanks

Since it's asking for an "administrative" login/password, I would assume the request is for the credentials of the "root" user…which, by definition, has ALL PRIVILEGES…

I'm not a MySQL dba nor do I play one on tv. You take my advice at your own risk. YMMV.

-- sw