Re: [cobalt-users] errors installing mysql from source

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Jake Smith <jake@xxxxxxxxxx> wrote:
> I have just installed mysql from source on a new RaQ4,  problem is that it
> doesnt work,
>
> After reading through some of the archive and looking at the partitions that
> cobalt had set up I thought I would have to install mysql somewhere in the
> /home directory,
>
> so I configured mysql  './configure --prefix=/home/mysql'
>
> because i thought that was a logical place for it I know that it usually is
> istalled in /usr/local but again from past messages I thought it should go
> in the home directory
>
> i ran 'make' and then 'make install' in the /home/tmp/mysql-3.22.32 folder
> where I had unpacked it.
>
> but in the /home/mysql directory there is no scripts directory so when i try
> to do 'scripts/mysql_install_db'  i cant

Correct.  There shouldn't be.  They should be in the directory you unpacked the
source code to, not the directory you want MySQL installed to.

> i go to /home/tmp/mysql-3.22.32 and I can do it
>
> i then tried to start mysql up in the /home/mysql/bin './safe_mysqld &'
> and then try and change the mysqladmin password with:
>
> ./mysqladmin -u root password 'newpass'
>
> and get the error:
>
> ./mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
> (11
> 1)'
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

Did you specify that MySQL should be run as a specific user?  You would do so
using the --with-mysqld-user option.  I do --with-mysqld-user=mysql to run MySQL
as a non-privileged user mysql.  If you didn't MySQL will run as the system user
"root".  You probably got the last few errors because you weren't logged in as
root during those steps.  Let us know if that was the case so others can learn
from your experience.

> I dont know if I should either try and delete mysql from the server and
> start over and just let install in usr/local or what - please can someone
> send me some guidance?

I think you can probably just try the last few steps while logged in as root.  I
would urge against having MySQL running as root for security reasons, but that
might not matter to you.

> I am sorry if someone gets offended with me posting to this list with this
> question I thought it was more appropriate on this list than on a mysql
> list

I'm not offended and I'm glad to help, but this would probably be a problem
that's covered in the MySQL list archives extensively.  I don't have the time to
check though since I'm pretty certain my di?U{ïsis is correct.

--
Steven Werby {steven-lists@xxxxxxxxxxxx}