Bug #18794 ps -ef shows passwords for mysqld_multi with configured replication
Submitted: 5 Apr 2006 10:51 Modified: 5 May 2006 13:47
Reporter: Daniel Kerwin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:5.0.18 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[5 Apr 2006 10:51] Daniel Kerwin
Description:
Hi,

i'd like to run several mysql instances on a single server with mysqld_multi for replication. I have all replication databases configured in a single config file. mysqld_multi starts all the databases without problems. 
If i look at the processes i can see the replication passwords in the output of "ps -ef". I wasn't able to figure out how to make mysqld_multi read the password from a different file or how to make it blank the passwords in the process table.

Please help me.

root      7422  0.5  0.0 52764 1144 pts/2    S    10:30   0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql_rep --socket=/var/lib/mysql_repl/mysql.sock --pid-file=/var/lib/mysql_repl/repl.pid --port=3309 --old_passwords=1 --user=mysql --server-id=7 --master-host=1.2.3.4 --master-user=repl --master-password=the_password --master-port=3307 --replicate-do-db=xxxxxxxx --replicate-ignore-table=xxxxxxx.T_xxxxxxxxx --replicate-rewrite-db=yyyyyyyyy->xxxxxxxxxxx

How to repeat:
Start mysqld_multi

Suggested fix:
mysqld_multi or mysqld_safe should read the passwords from a file (maybe a different one) or dont show it in the process list.
[5 Apr 2006 13:47] Valeriy Kravchuk
Thank you for a problem report. You should not put replication-related passwords in my.cnf, anyway. They should be set in master.info file on a slave. See http://dev.mysql.com/doc/refman/5.0/en/replication-options.html for the details. Please, check, if it solves your problem.
[5 May 2006 23:01] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".