Sinisa Milivojevic <[EMAIL PROTECTED]> writes: > Trond Eivind Glomsrød writes: > > Is there a clean way to administrate mysqld without a password by > > root? > > > > I'm looking for ways to make it flush logs, reload my.cnf and shut > > down cleanly, in an automated way - i.e, no password, but by root. > > > > (similar to pg_ctl for postgresql or `kill -HUP` for reloading) > > > > (e.g. shut down the server on system shutdown, and make log rotation > > and > > kill -HUP will flush everything.
We used to do that, but got complaints: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=51711 It wreaked havoc on bin-logs. OTOH, we need to be able to have scripts controlling the DB as root, while not needing to have a passwordless DB account. -- Trond Eivind Glomsrød Red Hat, Inc. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php