Red Hat Bugzilla – Bug 855704
mysql server prompts for password at startup
Last modified: 2017-04-12 06:20:49 EDT
(This is for mysql-server but there is no Component for that in bugzilla)
Description of problem:
mysql server asks for a password at startup:
[root@mysql ~]# service mysqld start
Starting MySQL: [ OK ]
Steps to Reproduce:
1. Edit /etc/my.cnf and add
2. stop and start mysqld
The init script runs this command:
/usr/bin/mysqladmin --socket="$socketfile" --user=UNKNOWN_MYSQL_USER ping
which prompts for a password.
The server should start without prompting for a password.
to the mysqladmin command, the prompt is not displayed.
Perhaps --no-defaults would be a more inclusive solution.
Indeed. I did not know about that option. In fact, I can't find any info about that option at all.
Still it does work :-)
(I was looking for a --no-password option but that does not exist).
I've pushed --no-defaults into the Fedora versions of the package. It'll ultimately work its way into newer RHEL releases from there, but I'm not sure if this will get into RHEL5 without your filing a request with your customer support contact.
I am sorry, but it is now too late in the RHEL-5 release cycle. RHEL-5.10 (the next RHEL-5 minor release) is going to be the first production phase 2  release of RHEL-5. Since phase 2 we'll be addressing only security and critical issues.
However, this one issue is not fixed in RHEL-6 yet therefore I am moving this bugzilla to RHEL-6.