MySQL Root User Password

leejones edited this page Aug 19, 2010 · 2 revisions

Moonshine utilizes the root MySQL user to ensure that your app’s database exists and the your app’s MySQL user exists with the necessary permissions.

By default, Moonshine sets up the root MySQL user with no password. If you wish to add a root user password, be sure to add the following configuration to your server(s) so that Moonshine will be able to manage your database.

  • log into your server
  • become the root user
  • edit or create the file /root/.my.cnf with the following contents:
user     = root
password = <secret>
  • save that file and exit
  • then, from the command line, set the proper permissions to secure that file
chmod 0600 /root/.my.cnf

See more information about this convention.