Go to TogaWare.com Home Page.
GNU/Linux Desktop Survival Guide
by Graham Williams
Google

MySQL Root Password


Once mysql-server is installed it is ready for immediate use. However, it is best to at least set an admin password with:



  $ /usr/bin/mysqladmin -u root password 'new-password'

You will then also need to let cron jobs work on the database so create a personal mysql config file for root in /root/.my.cnf containing:

  [mysqladmin] 
  user            = root
  password        = <secret>

Make sure the permissions are set appropriately:



  # chmod 0600 /root/.my.cnf
  # ls -l /root/.my.cnf
  4.0k -rw-------    1 root root  64 Oct 12 10:52 /root/.my.cnf


Copyright © 1995-2014 Togaware Pty Ltd
Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware.