[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 <---- great

[phoenix]

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

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