I am new to MySQL and was going through the MySQL Concepts. I have few questions. I am working on MySQL 5.x on CentOS 5.7.
1) Does MySQL Server run under the privilege of any particular account
2) I installed it using YUM groupinstall. How is mysql typically installed. is it from YUM or is it from RPM's
3) I have gone through some articles for moving mysql databases to new directories which involves changing the data directory path in my.cnf. Is there a way in MySQL to move only a specific database to a new directory. If yes, how is this handled.
Appreciate your help.