From: Christian Mack
Date: March 18 1999 11:47am
Subject: Re: Mysql-3_22_19b Install Trouble
List-Archive: http://lists.mysql.com/mysql/479
Message-Id: <36F0E7DB.32161B63@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

"Kevin P. O'Brien" wrote:
> 
> We have just installed 19b on our RH 4.2 Server.
> 
> After installing the pthreads-devel package, everything configured ok.
> Also the make was fine.
> the make install 'seemed' to work.
> 
> I ran the scripts/mysql_install_db script - it went fine.
> 
> When I run /usr/local/bin/safe_mysqld&
> 
>   I get a message saying "Starting mysqld daemon with databases from /usr/local/var"
> 
> When I type mysqlshow, I get a message saying
> 
>  "Can't connect to local MySQL server (111)"
> 
> When I do a ps I get
> 
>   4820  p3 S N  0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var
>  4822  p3 S N  0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var
>  4823  p3 S N  0:00 /usr/local/libexec/mysqld --basedir=/usr/local --datadir=/usr/local/var
> 
> Seems to have 3 process started.
> 
> I tried to shutdown and restart, but no difference. 3 processes start and I can't connect.
> 
> What should I try.
> I am running RedHat 4.2 - 2.036
> 
> Thanks for your time,
> 
> Kevin P. O'Brien, MCP, CPST <kevino@stripped>

Hi Kevin

If the ./scripts/mysql_install_db script was successful, then you should have a directory /usr/local/var/mysql with the following
files in it:
user.frm, user.isd, user.ism
db.frm, db.isd, db.ism
host.frm, host.isd, host,ism
tables_priv.frm, tables_priv.isd, tables_priv.ism
columns_priv.frm, columns_priv.isd, columns_priv.ism

The three mysqld's are one process and two threads running. This is o.k.

I assume you tried to connect from the machine running mysql.
Which version of mysqldump do you use?
Did you use the correct port?
Can you connect by giving IP address 127.0.0.1 as host?

Tschau
Christian