SQL Issue URGENCY (Yes I Searched)

S

ScathDeSolas

Verified User
Joined
Feb 10, 2011
Messages
52
Right so here's my issue: Somehow mysql got f***d and I have to clean up the pieces. My issue is bottled all into one and I checked google to no prevail.

I can't copy mysqld.sock to the /tmp/ directory.

I get this error on DirectAdmin's sql management:
Code: 
Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)


I get this error when I just try to run mysqld.sock...
Code: 
server:/var/run/mysqld# mysql --socket=/var/run/mysqld/mysqld.sock ...
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

..,. that's just for starters.

Debian Lenny OS. Dedicated Server.
 
Not that simple really. my.conf is updated and has the information. What files does directadmin require to read.

Code: 
server:/var/run/mysqld# ps -A | grep mysql
13403 ?        00:00:00 mysqld_safe
14203 ?        00:00:00 mysqld
server:/var/run/mysqld# kill 13403
server:/var/run/mysqld# kill 14203
-bash: kill: (14203) - No such process
server:/var/run/mysqld# ps -A | grep mysql
server:/var/run/mysqld# /etc/init.d/mysql start
/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
Starting MySQL database server: mysqld/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
.
Checking for corrupt, not cleanly closed and upgrade needing tables..
 
I copied the correct file with the right information in it and then tried to stop mysql. Same error with libz.so.1

Code: 
server:/var/run/mysqld# cp /etc/mysql/my.cnf /etc/my.cnf
server:/var/run/mysqld# nano/etc/my.cnf
-bash: nano/etc/my.cnf: No such file or directory
server:/var/run/mysqld# nano /etc/my.cnf
server:/var/run/mysqld# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
.
 
Directadmin still says even when I start mysqld and ignore the libz error:
Code: 
Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Which I have researched online and I just don't know what to do.
 
Start learning to analize errors and google for answers. Don't you see the error message:

/usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld
Click to expand...
???

Show results for:

Code: 
ls -l /usr/local/lib/libz.so.1
updatedb
locate libz.so
 
When I checked google I got different results since I put the error and directadmin so I was searching these forums and not the entire google. I'm very good at google search but just didn't think to isolate just the "libz" portion of the error.
 
Code: 
server:# ls -l /usr/local/lib/libz.so.1
lrwxrwxrwx 1 root staff 13 2011-02-15 14:33 /usr/local/lib/libz.so.1 -> libz.so.1.2.3

They really need an edit button for their forums posts this is annoying.
 
I installed using apt-get install locate and got updatedb and install... I really wish I could edit my posts here :(
 
Right I did everything you said but still it's being weird now what?

Code: 
server:/var/run/mysqld# locate libz.so
/usr/lib/libz.so
/usr/lib/libz.so.1
/usr/lib/libz.so.1.2.3.3
/usr/local/lib/libz.so
/usr/local/lib/libz.so.1
/usr/local/lib/libz.so.1.2.3
server:/var/run/mysqld# /init.d/mysql/ stop
-bash: /init.d/mysql/: No such file or directory
server:/var/run/mysqld# /etc/init.d/mysql/ stop
-bash: /etc/init.d/mysql/: Not a directory
server:/var/run/mysqld# /etc/init.d/mysql stop
Stopping MySQL database server: mysqld/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
/usr/sbin/mysqld: /usr/local/lib/libz.so.1: no version information available (required by /usr/sbin/mysqld)
.
 
You must log in or register to reply here.
Back
Top