Date: Fri, 2 Mar 2001 10:40:47 +0100 From: Michael Lyngbøl <none@michael--lyngbol.dk.lh.bsd-dk.dk> To: bsd-dk@BSD-Dk.dk Subject: Re: MySQL problem - kan ikke connecte via mysql.sock
On Fri, Mar 02, 2001 at 10:35:55AM +0100, Scotty wrote:
> Jeg har forsøgt at installerer MySQL på min linux box, og testet det ved
^^^^^
Nu er det her jo en BSD-liste, og ikke en Linux liste.
Dit spørgsmål har ikke direkte noget med hverken Linux eller BSD at
køre.
Har du?:
- Læst dokumentationen
- Startet MySQL
(ellers prøv at installere en RPM-pakke, det virkede da jeg bruge Linux)
/Michael
>
> 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