From: Peter Lloyd <[EMAIL PROTECTED]>
To: script
Subject: No response from mysql; & mysql_install_db freezes

>Description:

I am following the installation instructions in the documentation, and after invoking 
the script 
'mysql_install_db', I see a few announcements, then nothing happens. I waited for 
hours and still nothing 
happened. I tried several times and still nothing happened. The announcements that 
appear on the screen are:

  Creating db table
  Creating host table
  Creating user table
  Creating func table
  Creating tables_priv table
  Creating columns_priv table

... and then nothing. I looked inside the script and I can see that, at this point, it 
is 
issuing the command to mysql to create some tables. So, I tried to reproduce this 
manually, but again I get 
nothing. The documentation suggests that I should see the 'mysql' prompt and be able 
to issue SQL commands, 
but I see no prompt and every command is ignored except <CTRL-Z>, which produces the 
response

  Stopped (user)

I checked whether the MySQL daemon is running -- it is:

 20644 pts/10   0:02 mysqld
 20583 pts/10   0:00 csh
 20640 pts/10   0:00 mysql_in

After several attempts there seem to be multiple daemons, which I guess is wrong. I 
tried to 'kill <pid>' then but 
that had no effect.

I read the relevant documentation:
   2.4.1 Problems Running mysql_install_db
but it does not cover this situation.

I tried stopping and starting the daemon using mysql.server stop and start, but in 
both cases I got the response 
'cannot execute'.

>How-To-Repeat:

scripts/mysql_install_db

>Fix:

Not known. Help requested!

>Submitter-Id:  peri
>Originator:    Peter Lloyd
>Organization:  Nortel Networks
>MySQL support: none
>Synopsis:      mysql_install_db does not complete.
>Severity:      critical
>Priority:      high
>Category:      mysql
>Class:         support
>Release:       mysql-3.22.30 (TCX binary)

>Environment:

System: SunOS wcm1s0m1 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths:  /opt/bin/perl /usr/ccs/bin/make /opt/SUNWspro/bin/cc

Compilation info: CC='gcc'  CFLAGS='-O2 -fomit-frame-pointer'  CXX='gcc'  
CXXFLAGS='-O2 
-fomit-frame-pointer'  LDFLAGS=''
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=TCX binary' 
--disable-shared
Perl: This is perl, version 5.005_02 built for sun4-solaris

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