[SOLVED] Can't connect to local MySQL server

[akintemel]

Hi,
I try to find issues my problem but i am not sure what isues is right
zmcontrol status come out :
Host mail.yatas.com.tr

antispam Running

antivirus Running

ldap Running

logger Running

mailbox Stopped

mysql.server is not running.

mta Running

snmp Running

spell Running

stats Stopped



/etc/hosts file :

127.0.0.1 localhost.localdomain localhost

212.175.218.122 mail.yatas.com.tr mail

::1 localhost6.localdomain6 localhost6
/etc/resolv.conf file :

search yatas.com.tr

name server 127.0.0.1
host 'mail.yatas.com.tr' come out:
mail.yatas.com.tr has address 212.175.218.122
dig mail.yatas.com.tr come out:
;; ANSWER SECTION:

mail.yatas.com.tr. 86400 IN A 212.175.218.122
;; AUTHORITY SECTION:

yatas.com.tr. 86400 IN NS mail.yatas.com.tr.


dig -x 212.175.218.122 come out :
;; ANSWER SECTION:

122.218.175.212.in-addr.arpa. 86400 IN PTR mail.yatas.com.tr.
;; AUTHORITY SECTION:

218.175.212.in-addr.arpa. 86400 IN NS ns.yatas.com.tr.


[zimbra@mail ~]$ mysql mysql

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
[zimbra@mail ~]$ mysql zimbra

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
myslow.log file :

Tcp port: 7306 Unix socket: /opt/zimbra/db/mysql.sock

Time Id Command Argument
mysql_error.log :

thd=(nil)

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

frame pointer is NULL, did you compile with

-fomit-frame-pointer? Aborting backtrace!

The manual page at MySQL :: MySQL 5.1 Reference Manual :: B.5.4.2 What to Do If MySQL Keeps Crashing contains

information that should help you find out what is causing the crash.

100921 02:29:27 mysqld ended
---------------
what can i do for this error.i found Mysql Crash Recovery wiki page is it right my issues or am i change mysql password .
Thank you
Best regards.

[iway]

Might be some MySQL database corruption.

[akintemel]

how to i resolve msyql Colud you show me ?

[akintemel]

i wanto know just which way to get my problem issues.I think mysql password is problem.Her is zmmysqlstatus command ;
[zimbra@mail ~]$ zmmysqlstatus

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

Error while running 'mysql --user=zimbra --password=E_ubUodH77jvgNhiBRrEq9XNWOZdB --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 248.

[phoenix]

Look in the log files for errors and search the forums and wiki forr some troubleshooting tips and resolutions - the likelihood is this problem has been covered before.

[akintemel]

I am so so hapy i did it .:) problem was innodb crash that way mysql wold not start.

Thankyou verymuch for your spelling time for me.
Best regards
Mysql Crash Recovery - Zimbra :: Wiki

[phoenix]

[quote user="akintemel"]I am so so hapy i did it .:) problem was innodb crash that way mysql wold not start.[/QUOTE]Excellent, I'm glad you've fixed it. :)

[doc2354j]

All thank you this came in very handy here is the link I used to fix the issue

Mysql Crash Recovery - Zimbra :: Wiki
Cheers