Can't connect to local MySQL server

[bobescalin2005]

Hello! I can`t connect to the mysql server! Last week worked just fine! I am using opensuse 10.3! I know the mysqld is the server but i can`t find it to start and i start the mysql

$ su -c "/etc/rc.d/mysql start"
Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds
                                                                      done

when i want to see if the server run:

 su -c "mysqladmin version"
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

and it doesn`t exist the mysql.sock!

$ mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

How can i start the server? The server is in:

$ whereis mysqld
mysqld: /usr/sbin/mysqld /usr/share/man/man8/mysqld.8.gz

but when i go to execute manually...

$ /usr/sbin/mysqld
080526 21:40:12 [ERROR] Can't find messagefile '/var/lib/mysql/share/mysql/english/errmsg.sys'
080526 21:40:12 [ERROR] Aborting

Have you have any ideas? Thanks!

Cheers!

[yancek]

Try these in sequence, if the first doesn't work, the second,...

mysqld_safe &
/usr/bin/mysqld_safe
/usr/bin/mysqld_safe --user=mysql &

[bobescalin2005]

Thanks for the reply but it doesn`t work! i have the same error!
Cheers!

[HROAdmin26]

Verify there are no hung mysql processes (if there are, kill them off):

ps -ef | grep mysql

Try and start mysql normally:

/etc/init.d/mysql start

If it fails, look at your syslog for errors:

tail -50 /var/log/messages

Instead of "trying a bunch of random things," troubleshoot the problem.

MySQL Documentation

[bobescalin2005]

It isn`t working!

Cheers!

[bobescalin2005]

EVRIKA!!! It works! Remember when..

/usr/sbin/mysqld
080527 13:36:41 [ERROR] Can't find messagefile '/var/lib/mysql/share/mysql/english/errmsg.sys'
080527 13:36:41 [ERROR] Aborting

that file was in /usr/share/mysql/.....I have made a folder in /var/lib/mysql/share
with rwx permissions for the group and owner mysql and then copy all the files from /usr/share/mysql to /var/lib/mysql/share/mysql and made again the permission rwx group and owner mysql for the folder /var/lib/mysql and then:

$ su -c "/etc/init.d/mysql start"

and works great! Hope this helps someboby!

Cheers!