Hi Guys,
Could anyone help me with this: Whenever I try to connect to MySQL, I get this:-


[root@www /]# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
mysqld daemon ended
[root@www /]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m
ysql.sock' (111)
[root@www /]# mysqladmin -p ping
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql
.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex
ists!

I need some Urgent Help !
I am a weh hosting provider & because mysql is not working my clients are asking for their money back !
Thanks In Advance
KS
:(

I thied help from http://www.sitepointforum.com/showthread.php?threadid=14025
but still did not get any success !

when I type "ps aux|grep mysqld" i get :-root 9105 0.0 0.0 10664 0 ? SWN 00:46 0:00 [mysqld]
root 12009 0.0 1.4 1192 460 pts/1 S 01:49 0:00 grep mysqld

I tried doing :-
/etc/rc.d/init.d/mysqld stop

/etc/rc.d/init.d/mysqld start


It Got this :-
No mysqld pid file found. Looked /var/lib/mysql/mysqld.pid.
Please Help !
No Success !
:(

I need HELP Urgently !!
Please Reply ASAP !

Buys Please Help ME
I need HELP Urgently !!
Please Reply ASAP !
:bawling:
:confused:

I wish I could help.. I just felt pity for you cuz you were replying to your own post

Well, hopefully someone will help you.. :(

Have you got the mysql tables (the one that contain db,username, IP allowed etc) setup correctly.

Gimme root access and I'll have a look :) admin@webhostlink.com

check in /var/lib/mysql, there should eb a file called HOSTNAME.err where HOSTNAME will change.

Check that file to see what is the problem, if you don'T understnad the error, paste it here!


cd /var/lib/mysql
cat HOSTNAME.err

Originally posted by kunalsood
I tried doing :-
/etc/rc.d/init.d/mysqld stop

/etc/rc.d/init.d/mysqld start


It Got this :-
No mysqld pid file found. Looked /var/lib/mysql/mysqld.pid.
Please Help !
No Success !
:(


Did you look to see if there is a file called mysqld.pid in /var/lib/mysql/? If not then, try starting mysql by typing:

/usr/sbin/mysqld

while logged in as root.

Hope this helps.

Felix This is what I Get :-
010102 6:39:17 Found old style password for user 'kunal'. Restart using --old$
010102 6:39:17 Found old style password for user 'kunal'. Restart using --old$
010116 10:57:41 Found old style password for user 'kunal'. Restart using --old$
010116 10:57:41 Found old style password for user 'kunal'. Restart using --old$
010125 8:58:54 Found old style password for user 'kunal'. Restart using --old$
010206 11:22:15 Found old style password for user 'kunal'. Restart using --old$
010206 21:25:13 Found old style password for user 'kunal'. Restart using --old$
010211 0:10:00 Found old style password for user 'kunal'. Restart using --old$
010206 11:22:15 Found old style password for user 'kunal'. Restart using --old$
010206 21:25:13 Found old style password for user 'kunal'. Restart using --old$
010211 0:10:00 Found old style password for user 'kunal'. Restart using --old$
010211 0:13:15 Found old style password for user 'kunal'. Restart using --old$
010211 0:28:22 Found old style password for user 'kunal'. Restart using --old$
010211 0:46:20 Found old style password for user 'kunal'. Restart using --old$
010211 0:13:15 Found old style password for user 'kunal'. Restart using --old$
010211 0:28:22 Found old style password for user 'kunal'. Restart using --old$
010211 0:46:20 Found old style password for user 'kunal'. Restart using --old$
010211 1:52:22 Found old style password for user 'kunal'. Restart using --old$
010211 1:52:22 Found old style password for user 'kunal'. Restart using --old$
010211 4:06:00 Found old style password for user 'kunal'. Restart using --old$

Can You Guys Atleast Tell Me how to uninstall MySQL from my Cobalt RaQ3 Server ?
I used the Package Provided by Cobalt to Install It !
Thanks In Advance !

If it was a .pkg file SSH into your server, su to root, and look for the directory:

/var/lib/cobalt/uninstallers

There should be an uninstall script for it there. To run the uninstall script, simply type:

./scriptname

I'm not sure what filename you need to look for, as I installed rpm versions of MySQL on a seperate server.

Good luck.

Thanks for That However I just Got MySQL Fixed !
Thank You All Guys This Is What I Did !
:-
I Typed "/usr/local/sbin/mysqld --skip-grant-tables &"
Then I Typed "mysql -u root mysql" to connect to MySQL
& It worked Out Beautifully !
Thanks :)