It sounds like the problem is that you originally installed from RPM and
later installed from source, or vice versa. RPMs often use a different
file layout than source distributions, this is one reason why I always
install software that I consider system critical from source, so that
there are no unexpected results.
As for the socket problem, look here:
http://www.mysql.com/doc/C/o/Command-line_options.html
Specifically the --socket option which allows you to specify the path to
the socket which mysql uses to communicate with the rest of the
world. This option is also documented in the New Riders (Paul
DuBois) MySQL book, which I have found very useful.
Sean
On Tue, 27 Feb 2001, John Jensen wrote:
> There must be a bug here somewhere.
>
> I have just made three attempts to reinstall mysql, one from rpm, two
> from tarball. This is a Redhat6.1 system with 160meg of ram and mysql
> once ran on it, until I gave it an incorrect shutdown command.
> (It should not break so easily.)
>
> User and group "mysql" already exist, so I just chown & chgrp the
> contents after compiling. This time, I finally got it running, only
> after copying the old mysql/bin db files to mysql/var.
> (scripts/mysql_install_db failed to do so, possibly because "scripts"
> is no longer in the same directory level. Perhaps I untarred the
> wrong place, but the directions did not seem to tell me where I
> should.) Once running, mysql absolutely refuses to let me set the
> root password. It tries to connect through a mysql.sock file in
> /var/lib/mysql.
>
> HELLO???? Did mysql fail to detect the system installed on?
> My Redhat7 server uses /var/lib/mysql for all the mysql files. 6.x
> and earlier versions have the files in /usr/local/mysql. Why is mysql
> even looking in /var/lib??
>
> I remembered mention of similar problems on the list, so I did a
> search on the website, but I am turning up messages three years old,
> with commands like "UPDATE" that are not being recognized.
>
> Is there a way to fix this?
> Do I have to scratch again and start over in the /var/lib directory?
> I emailed the error files from my last attempt, but it disappeared.
> This time, the error file just filled with help messages.
> Do I have to reinstall Redhat with v.7 to make the current mysql
> release work?
> Do I have to scratch and use the previous version to make it work on
> v.6.1?
>
> Please help. I'm stumped and frustrated.
>
> John Jensen
> 520 Goshawk Court
> Bakersfield, CA 93309
> 661-833-2858
>
> ---------------------------------------------------------------------
> 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
