Urgent - mysql socket errors.. - tried previous posts but to no avail

SupermanInNY

Well-Known Member
Jul 19, 2003
255
0
166
Urgent - mysql socket errors.. - [RESOLEVED]

[THE ISSUE IS RESOLVED]

[RESOLVED - READ BELOW HOW I DID IT].


ERROR 2002: Can't connect to local MySQL server through socket


myserver.com:/var/lib/mysql => mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


From the log file:
myserver.com:/var/lib/mysql => less myserver.com.err


050924 15:37:03 mysqld started
050924 15:37:03 Warning: Asked for 196608 thread stack, but got 126976
050924 15:37:03 InnoDB: Started
050924 15:37:03 /usr/sbin/mysqld: Can't open file: 'host.MYI'. (errno: 142)
050924 15:37:03 Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
050924 15:37:03 Aborting

050924 15:37:03 InnoDB: Starting shutdown...
050924 15:37:06 InnoDB: Shutdown completed
050924 15:37:06 /usr/sbin/mysqld: Shutdown Complete

050924 15:37:06 mysqld ended



my.cnf file:


myserver.com:/etc => less my.cnf
[mysqld]

socket=/var/lib/mysql/mysql.sock
set-variable = max_connections=650
safe-show-database

set-variable = long_query_time=2
log-long-format

key_buffer = 384M
max_allowed_packet = 1M

table_cache = 512


sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8

query_cache_size= 32M
thread_concurrency = 4


I've already done the
/scripts/mysqlup --force

but got the same error.


Please help.

-Alon.


[UPDATE]


THE ISSUE HAS BEEN RESOLVED.
HOW???

My sys admin guru did the following:

---------------------------------------------------------------------
I tried checking the database file with myisamchk:
myisamchk /var/lib/mysql/mysql/host.MYI


The error message said that mysql's programs can't find charset number 83. So I added one to /usr/share/mysql/charset/Index
---------------------------------------------------------------------

And.. the issue was resolved!

Thanks,

-Alon.
 
Last edited: