Setting password for mysql user in .my.cnf

By halfgaar | On August 11, 2010 at 09:08 | 1 comment

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

/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

    1 Comment ( Add comment / trackback )

    1. (permalink) Pingback from Back up MySQL on Linux without stopping services or dumping the database | Virtual Lifestyle
      On Mar 26, 2013 at 14:30

      […] Please set the password for MySQL in /root/.my.cnf for automated access. See this post for details. […]