Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




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

Copyright © 1995-2006 [email protected]

  Published under the terms fo the GNU General Public License Design by Interspire