Run MySQL As A Normal User

• The MySQL server can be started and run by any user.
  • Avoid running the server as the Linux root user for security reasons.

• To change mysqld to run as a normal unprivileged user user_name, do the following:
  • Use mysqladmin shutdown to stop the server if it is running.
  • Change the database directories and files so user_name has privileges to read and write files in them

    chown -R user_name /path/to/mysql/datadir

  • Start the server as user user_name.
    • Alternatively, start mysqld as the Linux root user with the --user=user_name option.
  • To automatically start the server as user user_name add a user option to the [mysqld] group of the /etc/my.cnf option file or the my.cnf option file in the server's data directory.

    [mysqld]
    

    user=user_name

What is the MySQL access privilege system?

---

---

© 2007 John Michael Pierobon

Notes