Make sure some previous version of MySql isn't running.
I have seen this on systems which had the OS installed version
of MySql, and I had to issue

shell> /sbin/service mysql stop

shell> cd /usr/local/mysqlversion

shell> ./bin/mysqld_safe -user=theuserid

Hope this helps...

~Kelly W. Black

-----Original Message-----
From: George Chelidze [mailto:wrath@;geo.net.ge]
Sent: Tuesday, November 12, 2002 1:39 AM
To: [EMAIL PROTECTED]
Subject: mysql_install_db hangs


Hello,

One of my custommers use mysql database and a few days ago he asked me 
to solve the strange problem with it. I don't know the history of server 
  so I am unable to feed you with information like what has been changed 
before problem occured, but below is the describtion of problem itself 
and maybe someone can tell what can be the reason.

facts:

ps ax doesn't show any mysql process running
netstat -lnp shows that tcp/3306 port is in listening state but 
application doesn't present ('-' instead). pid file still exsists but 
process with pid listed in pid file doesn't present. mysql is unable to 
start because "socket is already in use..."

I have uninstalled mysql rpm-s and rebooted, after system booted up 3306 
port became finally closed so I tried to install new rpm-s. First I 
tried to install MySQL-<VERSION>.i386.rpm and after some time I saw:

Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables

after that it hangs and there is no message until I terminate it from 
shell using CTRL+c. After termination:

#ps ax | grep mysql

5736 pts/2    S      0:00 sh /usr/bin/mysql_install_db -IN-RPM
5741 pts/2    S      0:00 /usr/sbin/mysqld --bootstrap 
--skip-grant-tables --basedir=/ --datadir=/var/lib/mysql --skip-innodb 
--skip-gemini --skip-bdb

#netstat -lnp | grep 3306

tcp     0       0 0.0.0.0:3306  0.0.0.0:*       LISTEN  -

#

I have tried to install mysql from source and installation finished 
successfully but problem still exsist when I run mysql_install_db

Any ideas?
-- 
George Chelidze




---------------------------------------------------------------------
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

---------------------------------------------------------------------
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

Reply via email to