"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