> On Thu, 2003-11-27 at 19:44, Alexandre de Abreu wrote: > > > just wondering if this is only happening to me. i have set up mysql to > > > require a password for "root" upon login. now, whenever i start mysql > > > using /etc/rc.d/init.d/mysqld start, i get the message that starting > > > mysql timed-out and failed, even though it actually started. checking > > > that script, i've determined that it hangs when it tries to ping the > > > mysql server (mysqladmin ping), since ping-ing now requires a password. > > > my temporary solution was to comment the ping part out (just so i can > > > get an OK for mysql's startup. was this how it always was? i've used rh9 > > > with mysql before, with the exact same setup (root requires psasword no > > > matter where logging in from), and this never occurred. is this only > > > happening to me? any solution on how to allow "mysqladmin ping" without > > > requiring a password? > > > > The same for me. :) > > On rh9's mysqld init script, there's nothing about mysqlping. I just > > commented it out, too. > > hehe alright. an RHCE that did what i did. i feel smart =) > > thanks for replying. i wonder if anyone knows why the did this. maybe a > changelog or something about the script change. I build from the source tarball -- our current installation is 3.23.55. In TOPDIR/support-files you will find the mysql.server script, which is what I use to fire-off MySQL on system boot. No "ping" to be found. We place the password in /etc/my.cnf (root ownership and 600 permissions): # The following options will be passed to all MySQL clients [client] password = ******** port = 3306 socket = /tmp/mysql.sock
