From: Christina Date: June 9 2004 1:02pm Subject: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' List-Archive: http://lists.mysql.com/cluster/2 Message-Id: MIME-Version: 1.0 Content-Type: multipart/related; type="multipart/alternative"; boundary="----=_NextPart_000_0041_01C44DE7.5EE0A020" ------=_NextPart_000_0041_01C44DE7.5EE0A020 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0042_01C44DE7.5EE0A020" ------=_NextPart_001_0042_01C44DE7.5EE0A020 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable BlankIn just installed mysql 3.23.58 on my debian system. and copied = my.conf to /etc/mysql/ I tried to start the the database by=20 mysqld --user=3Dmysql& and it works just fine but as I tried to start it by=20 /bin/safe_mysqld --user=3Dmysql& or = /support-files/mysql.server start there is only one line of response: starting mysqld daemon with = database from /usr/local/mysql/data and then when I typed in "mysql" I got "Can't connect to local MySQL server through socket = '/var/run/mysqld/mysqld.sock'" I found the sock file is in /tmp/mysqld.sock instead of the path in = my.conf "var/run/mysqld/mysqld.sock'" so I changed all the socket path in the configuration file to let it = poin to /tmp/mysql.sock,=20 but again there is error message "Can't connect to local MySQL server = through socket '/tmp/mysqld.sock'" now I totally have no idea why would anybody throw me some light? Thanks!! ------=_NextPart_001_0042_01C44DE7.5EE0A020 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable Blank
In just installed mysql 3.23.58 on my debian system. and copied = my.conf to=20 /etc/mysql/
I tried to start the the database by
mysqld  --user=3Dmysql&
and it works just fine
 
but as I tried to start it by
./bin/safe_mysqld=20 --user=3Dmysql&         =        =20 or     ./support-files/mysql.server start
there is only one line of response:  starting mysqld daemon = with=20 database from /usr/local/mysql/data
and then when I typed in "mysql"
I got "Can't connect to local MySQL server through socket=20 '/var/run/mysqld/mysqld.sock'"

I found the sock file is in /tmp/mysqld.sock instead of the path in = my.conf=20 "var/run/mysqld/mysqld.sock'"

so I changed all the socket path in  the configuration file to = let it=20 poin to /tmp/mysql.sock,

but again there is error message "Can't connect to local MySQL server = through=20 socket '/tmp/mysqld.sock'"

now I totally have no idea why

would anybody throw me some light?

Thanks!!

------=_NextPart_001_0042_01C44DE7.5EE0A020-- ------=_NextPart_000_0041_01C44DE7.5EE0A020--