Setting password for mysql user in .my.cnf

By halfgaar | On August 11, 2010 at 09:08 | No comments

Sometimes you want automated access for root on your MySQL database. One way of accomplishing that is by doing this:

cd /root
touch .my.cnf
chmod 640 .my.cnf

And put in it:

[client]
user=root
password=foobar

Posted by halfgaar on August 11, 2010 at 09:08

Technology

No Comments ( Add comment / trackback )

Post a comment

Copyleft: These days everything you can think of is copyrighted, patented, protected or otherwise made into someone's imaginary intellectual property. I have a lot of imagination but not enough to pretend that I have some divine right to share things with you without giving you the right to share it further. That would be childish. So, everything here is licenced under a Creative Commons Attribution-Noncommercial-Share Alike license. That means that you can bloody well do anything you like with my content as long as you tell that it's from me (or the respective author). Only if you want to make money from my content do you have to ask me permission first. (As if I could be bothered to sue.) Oh, and you can't redistribute your derivate content under more restrictive terms. Share the love.

Colophon: This weblog is powered by a WordPress installation running on PHP5 and MySQL, hosted by NearlyFreeSpeech.Net's outstanding FreeBSD hosting platform. The markup for this WP theme is my own and should usually validate as some sort of XHTML concoction. So should the CSS. I've actually blogged about this theme.

Setting password for mysql user in .my.cnf

No Comments ( Add comment / trackback )

Post a comment

Categories

Tags/Keywords

Recent Posts

Recent Comments