18.16 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
[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
Your donation will support ongoing development and give you access to the PDF version of this book. Desktop Survival Guides include Data Science, GNU/Linux, and MLHub. Books available on Amazon include Data Mining with Rattle and Essentials of Data Science. Popular open source software includes rattle, wajig, and mlhub. Hosted by Togaware, a pioneer of free and open source software since 1984. Copyright © 1995-2021 Graham.Williams@togaware.com Creative Commons Attribution-ShareAlike 4.0.