Re: OS User mysql
Posted by:
Rick James
Date: February 15, 2016 04:40PM
"locked"??
The OS "mysql" user is handy for MySQL to know that it can get to all its files.
The OS "root" can get to those files, too.
The MySQL "root" is, by convention, the admin for doing things inside mysql, usually via utility programs mysql, mysqladmin, etc. You should set the password for that mysql user, independent of the OS "root".
A MySQL DBA often needs admin privs for those utilities.
A MySQL DBA rarely needs OS permissions, but usually he/she has OS root access anyway.
You could probably do "sudo -u mysql" or something like that, but in my many years of dev/DBA/SE/etc, I don't think I ever did that, nor felt the need.
Do you have something more specific in mind?
Subject
Written By
Posted
February 10, 2016 07:52AM
Re: OS User mysql
February 15, 2016 04:40PM
February 16, 2016 07:35PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.