1 |
Dear list, |
2 |
|
3 |
It appears as if mysql 5.0.18-r30 |
4 |
sets up: |
5 |
datadir = /var/lib/mysql-500 |
6 |
|
7 |
while my.cnf was from earlier version (I thought I deleted it with |
8 |
etc-update) indicating: |
9 |
datadir =/var/lib/mysql |
10 |
|
11 |
After correction in my.cnf to: |
12 |
datadir =/var/lib/mysql-500 |
13 |
|
14 |
everything works OK! |
15 |
|
16 |
Fredrik |
17 |
----- Original Message ----- |
18 |
From: "John Jolet" <john@×××××.net> |
19 |
To: <gentoo-user@l.g.o> |
20 |
Sent: Sunday, February 05, 2006 3:13 AM |
21 |
Subject: Re: [gentoo-user] ... Can't connect to local MySQL server ... |
22 |
|
23 |
|
24 |
> |
25 |
> On Feb 4, 2006, at 7:37 PM, Fredrik Lundgren wrote: |
26 |
> |
27 |
>> Thanks for the suggestions! |
28 |
>> |
29 |
>> The problem is that |
30 |
>> |
31 |
>> # /etc/init.d/mysql start |
32 |
>> * ... |
33 |
>> * Starting mysql (/etc/mysql/my.cnf) |
34 |
>> * MySQL NOT started (0) [!!] |
35 |
>> |
36 |
>> In my.cnf |
37 |
>> |
38 |
>> .... |
39 |
>> .... |
40 |
>> [client] |
41 |
>> # password = your_password |
42 |
>> port = 3306 |
43 |
>> socket = /var/run/mysqld/mysqld.sock |
44 |
>> ... |
45 |
>> ... |
46 |
>> |
47 |
>> [mysqld] |
48 |
>> ... |
49 |
>> ... |
50 |
>> user = mysql |
51 |
>> port = 3306 |
52 |
>> socket = /var/run/mysqld/mysqld.sock |
53 |
>> .... |
54 |
>> ... |
55 |
>> |
56 |
>> So it appears that /var/run/mysqld/mysqld.sock somehow is corrupted |
57 |
>> How should that be fixed? |
58 |
>> |
59 |
> not necessarily. make sure mysql is not running. check for the |
60 |
> existence of /var/run/mysqld/mysqld.sock...if it exists, delete it. |
61 |
> it shouldn't exist with mysql not running. |
62 |
> |
63 |
>> Fredrik |
64 |
>> |
65 |
>> ----- Original Message ----- From: "John Jolet" <john@×××××.net> |
66 |
>> To: <gentoo-user@l.g.o> |
67 |
>> Sent: Sunday, February 05, 2006 1:40 AM |
68 |
>> Subject: Re: [gentoo-user] ... Can't connect to local MySQL server |
69 |
>> ... |
70 |
>> |
71 |
>> |
72 |
>>> |
73 |
>>> On Feb 4, 2006, at 6:22 PM, A. Khattri wrote: |
74 |
>>> |
75 |
>>>> On Sun, 5 Feb 2006, Fredrik Lundgren wrote: |
76 |
>>>> |
77 |
>>>>> When I try to visit with |
78 |
>>>>> $ mysql -u root -p |
79 |
>>>>> password. ******* |
80 |
>>>>> |
81 |
>>>>> I get |
82 |
>>>>> ERROR 2002 (HY000): Can't connect to local MySQL server through |
83 |
>>>>> socket |
84 |
>>>>> 'var/run/mysqld.sock' (2) |
85 |
>>>>> |
86 |
>>>>> Evidently my configuration is wrong |
87 |
>>>>> |
88 |
>>>>> Has anyone a tip or two ? |
89 |
>>>> |
90 |
>>>> Maybe start mysqld? |
91 |
>>>> |
92 |
>>>> /etc/init.d/mysql start |
93 |
>>>> |
94 |
>>> and make sure it's still running. and make sure there's an entry |
95 |
>>> for |
96 |
>>> the mysql client in the my.cnf pointing to the proper socket. |
97 |
>>>>> and how do I get mysql to start at boot? |
98 |
>>>> |
99 |
>>>> Maybe use rc-update? |
100 |
>>>> |
101 |
>>>> rc-update add mysql default |
102 |
>>>> |
103 |
>>>> |
104 |
>>>> (Yes, its in the handbook) |
105 |
>>>> |
106 |
>>>> -- |
107 |
>>>> |
108 |
>>>> -- |
109 |
>>>> gentoo-user@g.o mailing list |
110 |
>>>> |
111 |
>>> |
112 |
>>> -- |
113 |
>>> gentoo-user@g.o mailing list |
114 |
>>> |
115 |
>>> |
116 |
>> |
117 |
>> |
118 |
>> -- |
119 |
>> gentoo-user@g.o mailing list |
120 |
>> |
121 |
> |
122 |
> -- |
123 |
> gentoo-user@g.o mailing list |
124 |
> |
125 |
> |
126 |
|
127 |
|
128 |
-- |
129 |
gentoo-user@g.o mailing list |