Can't connect to local MySQL

[Sean Berry]

I have downloaded the source code for mysql-3.23.58. I unzip and untarred
it and ran

$ ./configure --prefix=/usr/local --localstatedir=/usr/local/mysql
$ make
$ make install
$ ./scripts/mysql_install_db

I have a user mysql, and group mysql.
I ran
$ chown -R root /usr/local/mysql
$ chgrp -R mysql /usr/local/mysql

I try to run
$ ./scripts/safe_mysqld --user=mysql &

and get...
Can't connect to local MySQL server through socket '/tmp/mysql.sock'

/tmp/mysql.sock exists.

Is there anyting major I have overlooked? I have installed from source
before but never really had too many problems.

Just throw out some ideas to me. I am looking for a brain-storm of possible
fixes.

Thanks.

[Missaka Wijekoon]

You run as mysql, but start as root. Who owns /tmp/mysql.sock? Is it
writeable by mysql?

-Misk

Sean Berry wrote:

I have downloaded the source code for mysql-3.23.58. I unzip and untarred
it and ran

$ ./configure --prefix=/usr/local --localstatedir=/usr/local/mysql
$ make
$ make install
$ ./scripts/mysql_install_db

I have a user mysql, and group mysql.
I ran
$ chown -R root /usr/local/mysql
$ chgrp -R mysql /usr/local/mysql

I try to run
$ ./scripts/safe_mysqld --user=mysql &

and get...
Can't connect to local MySQL server through socket '/tmp/mysql.sock'

/tmp/mysql.sock exists.

Is there anyting major I have overlooked? I have installed from source
before but never really had too many problems.

Just throw out some ideas to me. I am looking for a brain-storm of possible
fixes.

Thanks.

--
================================================== ======================
Missaka Wijekoon (a.k.a. Misk) mw*******@RemoveThis.villageEdocs.com
Sr. Software Engineer http://www.villageEdocs.com
VillageEdocs
================================================== ======================

[Aggro]

Sean Berry wrote:

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

Have you tried this?

http://dev.mysql.com/doc/mysql/en/Ca...to_server.html