Bug 21472

Summary:	Mariadb: README.urpmi gives a command to change password, which is not accepted
Product:	Mageia	Reporter:	papoteur <yvesbrungard>
Component:	RPM Packages	Assignee:	AL13N <alien>
Status:	RESOLVED OLD	QA Contact:
Severity:	normal
Priority:	Normal	CC:	marja11, ouaurelien, pkg-bugs
Version:	6
Target Milestone:	---
Hardware:	All
OS:	Linux
See Also:	https://bugs.mageia.org/show_bug.cgi?id=19223
Whiteboard:
Source RPM:	mariadb-10.1.25-1.mga6	CVE:
Status comment:

Description papoteur 2017-08-08 11:21:58 CEST

README urpmi says:
NOTE: MariaDB is installed without root password, it is recommended to set the
root password with the following command as soon as possible:

   mysqladmin password

But the command is not accepted:
Mysqld is running:
$ mysqladmin password
New password: 
Confirm new password: 
mysqladmin: 
You cannot use 'password' command as mysqld runs
 with grant tables disabled (was started with --skip-grant-tables).
Use: "mysqladmin flush-privileges password '*'" instead

mysqld is stopped:
$ mysqladmin password
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

papoteur 2017-08-08 11:57:55 CEST

See Also: (none) => https://bugs.mageia.org/show_bug.cgi?id=19223

Comment 1 Marja Van Waes 2017-08-08 23:19:50 CEST

Assigning to the registered maintainer, but CC'ing all packagers collectively, in case the maintainer is unavailable.

CC: (none) => marja11, pkg-bugs
Assignee: bugsquad => alien

Comment 2 Frédéric "LpSolit" Buclin 2017-08-08 23:35:47 CEST

Why not typing this command while mysqld is running instead?

  mysqladmin flush-privileges password '*'

You should then be able to run

  mysqladmin password

Comment 3 Aurelien Oudelet 2020-08-02 22:14:16 CEST

This message is a reminder that Mageia 6 is end of life.

Mageia stopped maintaining and issuing updates for Mageia 6. At that time this bug will be closed as OLD (EOL).

Package Maintainer: If you wish for this bug to remain open because you plan to 
fix it in a currently maintained version, simply change the 'version' to a later 
Mageia version prior to Mageia 6's end of life.

Bug Reporter: Thank you for reporting this issue and we are sorry that we cannot 
be able to fix it before Mageia 6 was end of life.
If you would still like to see this bug fixed and are able to reproduce it against a later version of Mageia, you are encouraged to click on "Version" and change it against that version of Mageia.

Although we aim to fix as many bugs as possible during every release's lifetime, 
sometimes those efforts are overtaken by events. Often a more recent Mageia 
release includes newer upstream software that fixes bugs or makes them obsolete.

--
Mageia Bugsquad

CC: (none) => ouaurelien
Status: NEW => RESOLVED
Resolution: (none) => OLD