MySQL problem - kan ikke connecte via mysql.sock

From: Scotty (none@scotty--scotty.dk.lh.bsd-dk.dk)
Date: Fri 02 Mar 2001 - 10:35:55 CET 

Date: Fri, 02 Mar 2001 10:35:55 +0100
From: Scotty <none@scotty--scotty.dk.lh.bsd-dk.dk>
To: bsd-dk@bsd-dk.dk
Subject: MySQL problem - kan ikke connecte via mysql.sock

Jeg har forsøgt at installerer MySQL på min linux box, og testet det ved

et script, men jeg får denne fejl:

DBI->connect failed: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111) at /home/scotty/cgi-bin/movies.pl line 24

fra mit Perl script.

Det samme sker når jeg forsøger at connecte til den direkte fra shell.
Har
i en forklaring, der kan hjælpe på mit problem ? Jeg har forsøgt at
følge
de vejledninger der er på mysql.org - ved denne fejl, men ligemeget
hjælper det.

Her er hvad jeg har af oplysninger på selve serveren:

[root@scotty /root]# mysqladmin version
mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty

Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 21 hours 31 min 23 sec

Threads: 1 Questions: 20 Slow queries: 0 Opens: 6 Flush tables: 1
Open tables: 2

[root@scotty /root]# mysqladmin variables
+----------------------------+---------------------------+
| Variable_name | Value |
+----------------------------+---------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | / |
| datadir | /var/lib/mysql/ |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| join_buffer | 131072 |
| flush_time | 0 |
| key_buffer | 8388600 |
| language | /usr/share/mysql/english/ |
| log | OFF |
| log_update | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 1048576 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_insert_threads | 20 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_write_lock_count | 4294967295 |
| net_buffer_length | 16384 |
| pid_file | /var/lib/mysql/mysqld.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| skip_locking | ON |
| skip_networking | OFF |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| thread_stack | 65536 |
| tmp_table_size | 1048576 |
| tmpdir | /tmp/ |
| version | 3.22.32 |
| wait_timeout | 28800 |
+----------------------------+---------------------------+

[root@scotty /root]# mysqladmin -h '64.225.121.82' version
mysqladmin: connect to server at '64.225.121.82' failed
error: 'Host '64.225.121.82' is not allowed to connect to this MySQL
server'

[root@scotty /root]# mysqladmin --socket=/tmp/mysql.sock version
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists

mysql.sock ligger i /tmp/ og ,mysql kører - men jeg kan ikke connecte... 

--

----------------------------------------------

             Best Regards - Scotty

This archive was generated by hypermail 2b30 : Wed 15 Nov 2006 - 18:24:05 CET