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

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-2018 Togaware Pty Ltd
Support further development through the purchase of the PDF version of the book.
Brought to you by Togaware and the author of the open source software Rattle and wajig.
Also the author of Data Mining with Rattle and Essentials of Data Science.