Re: [cobalt-users] MySQL Not Connecting

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

JA <jjma@xxxxxxxxxxxxxx> wrote:
> Having restarted the RAQ2 this morning because it wasn't producing any web
> services there has been a problem with mysql that is puzzling. Trying to
> connect via telnet with password brings up the following error message:
>
> [root /]# mysql -p
> Enter password: ............
> ERROR 2002: Can't connect to local Mysql server (146)
>
> Mysql doesn't respond to some mysqladmin commands that I have tried a few
> tips of the cobalt list.

JA, my guess is that you don't have the mysql start script in a server initialization
script.  /etc/rc.d/rc.local gets called after the server starts.  You can save the
mysql startup script that was created when you installed mysql into
/etc/rc.d/init.d/mysql and then add a line in /etc/rc.d/rc.local to run it when the
server starts or if you don't have the mysql startup script or don't want to run it,
you can start mysqld directly by adding a line like
/home/mysql/libexec/mysqld --log=/var/log/mysql_log --log-update=/var/log/mysql_log_u
pdate to /etc/rc.d/init.d/mysql.  Be sure to use the actual path for your
installation of mysqld and whatever options you want to run at startup.  It's very
unlikely your installation is in the same place as mine.

Steven Werby {steven-lists@xxxxxxxxxxxx}