469,167 Members | 1,207 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Can't connect to local MySQL

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.
Jul 20 '05 #1
2 1373
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
================================================== ======================
Jul 20 '05 #2
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
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by webhead74 | last post: by
1 post views Thread by Peter Nikolaidis | last post: by
reply views Thread by Bill Hernandez | last post: by
5 posts views Thread by scorpionbilli | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.