[SATLUG] Mysql service problem

[Zeb Fletcher]

Caleb, 
         Did you remove the anonymous user ? if so you need to make a
change to the /etc/init.d/mysqld file

here is the part to look for:
        # If you've removed anonymous users, this line must be changed to
        # use a user that is allowed to ping mysqld.
        ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"

this is located in the start function of the script 
there is nothing wrong with the way your starting it others correct me
if I'm wrong but root start safe-mysqld and then forks it over to user
mysql who starts the actual database so you will see mysql-safe and
mysqld



On Mon, 6 Sep 2004 11:43:33 -0500, Caleb Wylie <mynameiscaleb at gmail.com> wrote:
> I have a strange problem with Mysql... everytime i start it running
> the command "service mysqld start" from root I recieve the following.
> 
> [root at Phoenix log]# service mysqld start
> Timeout error occurred trying to start MySQL Daemon.
> Starting MySQL:                                            [FAILED]
> 
> I check the logs for the failure to find none... tail from log.
> 
> [root at Phoenix log]# tail mysqld.log
> 040906 11:29:06  mysqld started
> /usr/libexec/mysqld: ready for connections
> 040906 11:36:44  /usr/libexec/mysqld: Normal shutdown
> 
> 040906 11:36:44  /usr/libexec/mysqld: Shutdown Complete
> 
> 040906 11:36:44  mysqld ended
> 
> 040906 11:36:50  mysqld started
> /usr/libexec/mysqld: ready for connections
> 
> I am able to login and work with I just find it very perplexing that
> it is not starting successfully.  Also it seems to be trying to run in
> safe mode.
> 
> root      5158  0.0  0.5  4248 1144 pts/0    S    11:29   0:00 /bin/sh
> /usr/bin/safe_mysqld --defau
> mysql     5182  0.0  2.2 29696 5112 pts/0    S    11:29   0:00
> /usr/libexec/mysqld --defaults-file=
> 
> Is this correct can anyone verify this for me.   As i am not sure this
> is the correct way of it starting.
> 
> Thankyou ahead of time.
> 
> Caleb
> _______________________________________________
> Satlug mailing list
> Satlug at satlug.org
> http://alamo.satlug.org/mailman/listinfo/satlug
>