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:

  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

Support further development by purchasing the PDF version of the book.
Other online resources include the Data Science Desktop Survival Guide.
Books available on Amazon include Data Mining with Rattle and Essentials of Data Science.
Popular open source software includes rattle and wajig.
Hosted by Togaware, a pioneer of free and open source software since 1984.
Copyright © 1995-2020 Togaware Pty Ltd. Creative Commons ShareAlike V4.