I've gathered more data on my problem here. We have recently made a few DNS
changes that I think have hosed mysql. See the error message below:
DBI->connect failed: Unknown MySQL Server Host 'myserver.com' (2) at
/home/httpd/test/stage2/cgi-bin/send_requests.cgi line 28
Can't call method "prepare" on an undefined value at
/home/httpd/test/stage2/cgi-bin/send_requests.cgi line 32.
The 'myserver.com' is no longer a viable domain, so is there anything in the
installation or starting of mysql that needs this domain? I have the same
'hanging' error on start and stop of mysql. And if so, where can I change it
so it uses our new domain? Or do I have to do a complete reinstall with a
newly compiled
installation app?
Thanks,
Jeff
-----Original Message-----
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 4:19 PM
To: Weber, Jeff
Cc: [EMAIL PROTECTED]
Subject: Re: Reinstallation HANG
"Weber, Jeff" wrote:
>
> Mysql is hanging when started on my Linux box (Red Hat Linux release 6.2
> (Zoot)
> Kernel 2.2.14-5.0 on an i686 -- mysqld, Version: 3.23.21), so I thought I
> would reinstall mysql_install_db. This hangs too, see below...
>
> [root@myserver mysql]# mysql_install_db
> Creating func table
> Creating tables_priv table
> Creating columns_priv table
>
> Server doesn't come back after this, I have to kill -9 to stop it. Anyone
> have any idea why the install would hang this quickly?
>
> Thanks,
> Jeff
>
You should have run
mysql_install_db --user=mysql
Now the database directory and all the files are probably owned by root,
and mysqld can't read the directory.
chown -R mysql /var/mysql/data
replacing "/var/mysql/data" with actual mysql database directory.
---------------------------------------------------------------------
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