On 28/01/2017 18:43, Bruce Dubbs wrote:
Pierre Labastie wrote:
Hi
The command in the book (as root):
-----
mysqladmin -u root password
-----
returns:
-----
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
-----
I already had an existing database with a root password. When
updating mariadb to 10.1.21, using 'mysqladmin -u root password'
failed for me also with the message above. However, using:
sudo mysqladmin -u root -p password
and entering the old password, it allowed me to change it.
-- Bruce
Actually, that was the first install of mariadb. So I do not think I
could be polluted by a previous password. Problem is: now it works... As
I told you. I first downgraded to mariadb 10.1.20. In that case, the
instructions worked. Then I removed the whole /srv/mysql dir (so that I
could exclude having to enter an old paswword or having wrong
permissions). I removed the package (using porg). Then I rebuilt
10.1.21. And it run to completion... The possibilities are:
- some unnoticed leftover from 10.1.20, which allows the instructions to
run.
- (more likely). Since I have a script, I introduce a delay after
starting "mysqld_safe". The first time I did that, I put sleep 1. Then I
got the error. Maybe, that left an incomplete permission setting or
whatever, and so, after that, I was not working (I am not sure I have
tried to remove the database before building again). The second time, I
put sleep 5 (and as said, I had removed the database). Maybe that's the
reason why it passed...
Pierre
Sorry for the noise (although at least, it lead to the information given
by Bruce, which may be useful).
--
http://lists.linuxfromscratch.org/listinfo/blfs-support
FAQ: http://www.linuxfromscratch.org/blfs/faq.html
Unsubscribe: See the above information page