Thanks for the clarification, at the time of installation there was no /user/.my.cnf file in existence so this makes sense. On Sun, 29 Jan 2017, David C. Rankin wrote:
Date: Sun, 29 Jan 2017 16:00:12 From: David C. Rankin <drankinatty@suddenlinkmail.com> Reply-To: General Discussion about Arch Linux <arch-general@archlinux.org> To: General Discussion about Arch Linux <arch-general@archlinux.org> Subject: Re: [arch-general] mysql_secure_installation
On 01/28/2017 06:47 AM, Jude DaShiell wrote:
I now have mariadb installed and working. Another internet site gave an example /root/.my.cnf file of about 3 lines that has to be read-only and I was able to do it with that file. The thing is when you hit enter and the error 1045 (28000) error comes up, hit enter again and you go right past that error successfully and can then do the rest of the script. I don't know if the /root/.my.cnf file helped or not but I keyed in the password that was in that file and had it all come up working.
You may be a bit confused about the use of /user/.my.conf. If you invoke mysql (mariadb) without parameters, then it looks for a .my.conf file under the current user directory (e.g. /$HOME/.my.cnf). In your .my.conf you simple enter the mode of operation followed by the password and user, e.g.
$ cat ~/.my.cnf | sed 's/password[ ]=[ ].*$/password = secret/' [mysqladmin] password = secret user = david
[mysql] password = secret user = david
[mysqldump] password = secret user = david
[mysqlcheck] password = secret user = david
The above will allow local operation of 'mysqladmin', 'mysql', 'mysqldump' and 'mysqlcheck' for my user. You can do the same for 'root', but understand it is for mysql user 'root' that just happened to check '/root/.my.conf' by default when invoked by root.
--