[FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed

Hello,
i have made command mistake when upgrading php and i harmed mysql.
i tried to reinstall mysql with command :
apt-get purge mysql-server mysql-common mysql-client
rm -rf /var/lib/mysql
rm -rf /etc/mysql*

and than
apt-get install mysql-server mysql-common mysql-client
apt-get update
apt-get upgrade

but getting [FAIL] Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed

i have made backups of /etc/mysql & /var/lib/mysql & /var/lib/mysql.bak
my
/var/log/mysql/mysql.log is empty


Thank you

 

Check the permissions for /var/log/mysql and make sure that you defined general_log_file or log-error in your my.cnf.
You can also try to start mysql manually with

Code:

/usr/bin/mysqld_safe

to see what´s going wrong.

 

my /var/log/syslog
https://docs.google.com/document/d/19k01sPR4z8FVT6XoprzfqTDcEkf6_EwrW1Q13_05kJ0/edit?usp=sharing

tried -
/usr/bin/mysqld_safe
141231 16:03:48 mysqld_safe Logging to '/var/lib/mysql/vps-265655-16121.manage.myhosting.com.err'.
141231 16:03:48 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141231 16:03:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
root@vps-265655-16121:~#

 

ls -la /var/lib/mysql
total 316100
drwx------ 28 mysql mysql 4096 Dec 31 16:04 .
drwxr-xr-x 51 root root 4096 Dec 31 14:35 ..
drwx------ 2 root root 4096 Oct 13 02:46 c1aps1
drwx------ 2 root root 16384 Sep 25 15:08 c1arabOpenCart_1
drwx------ 2 root root 4096 Sep 19 21:45 c1DrupalCore
drwx------ 2 root root 4096 Sep 20 01:46 c1Drupal_local
drwx------ 2 root root 24576 Sep 4 12:37 c1moodleJIM
drwxr-xr-x 2 root root 24576 Sep 4 20:00 c1moodleJIM888
drwx------ 2 root root 24576 Dec 9 07:23 c1OC_2_0_0_RTL
drwx------ 2 root root 24576 Nov 23 02:10 c1opencart2
drwx------ 2 root root 16384 Sep 22 23:06 c1opencartarab
drwx------ 2 root root 24576 Oct 1 03:07 c1Opencart_My
drwx------ 2 root root 4096 May 19 2014 c1SpywareAds
drwx------ 2 root root 4096 Sep 13 15:59 c2moodle
drwx------ 2 root root 24576 Dec 14 15:12 c2moodle1
drwx------ 2 root root 24576 Jun 3 2014 c2MyMoodle
drwx------ 2 root root 12288 May 20 2014 dbispconfig
-rw-r--r-- 1 root root 0 May 15 2014 debian-5.1.flag
-rw-rw---- 1 root root 312475648 Dec 22 02:14 ibdata1
-rw-rw---- 1 root root 5242880 Dec 22 02:14 ib_logfile0
-rw-rw---- 1 root root 5242880 Dec 15 19:51 ib_logfile1
drwx------ 2 root root 24576 May 19 2014 moodlecantlog
drwx------ 2 root root 24576 May 19 2014 moodledontknow
drwx------ 2 root root 24576 May 26 2014 moodle_jimbackup
drwx------ 2 root root 24576 May 26 2014 moodle_jimbackupafterplugincustom@002dno
drwx------ 2 mysql root 4096 Dec 31 14:40 mysql
-rw------- 1 root root 6 May 15 2014 mysql_upgrade_info
drwx------ 2 root root 4096 Nov 5 00:11 openmeeting@00203@002e0@002e4
drwx------ 2 root root 4096 Nov 29 00:37 openmeetings
drwx------ 2 root root 4096 Sep 14 14:26 openmeetings@002d2@002e2
drwx------ 2 root root 4096 Sep 14 16:12 openmeetings@002d3@002e0@002e2
drwx------ 2 root root 4096 Oct 19 04:00 openmeetings@002d3@002e0@002e3
drwx------ 2 root root 4096 Sep 13 15:14 phpmyadmin
-rw-r----- 1 mysql root 8772 Dec 31 16:04 vps-1130913-16121.manage.myhosting.com.err

 

chown -R mysql:mysql /var/lib/mysql
root@vps-265655:~# /etc/init.d/mysql start
[ ok ] Starting MySQL database server: mysqld.
[info] Checking for corrupt, not cleanly closed and upgrade needing tables..
root@vps-265655-16121:~# ERROR 1548 (HY000) at line 1: Cannot load from mysql.proc. The table is probably corrupted

 

phpmyadmin - ERROR 404 - Not Found!

 

installed phpmyadmin and repair mysql tabels
Your SQL query has been executed successfully

but cant log to any of my sites

 

according to your post i noticed that in phpmyadmin in mysql tables i get message:
mysql.general_log optimize note The storage engine for the table doesn't support o...
mysql.slow_log optimize note The storage engine for the table doesn't support o...


and when tried to log to mysql:
mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

 

localhost root *56231E4D1C51E43B6A0EC5E5ED62D4A270F70A33 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL
vps-265655-16121.manage.myhosting.com root *56231E4D1C51E43B6A0EC5E5ED62D4A270F70A33 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL
127.0.0.1 root *56231E4D1C51E43B6A0EC5E5ED62D4A270F70A33 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL
localhost debian-sys-maint *639D263019D781E4460B0511F894518F17E893B0 Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y N [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL
localhost openmeetings *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 N N N N N N N N N N N N N N N N N N N N N N N N N N N N N [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL
localhost phpmyadmin *CC67043C7BCFF5EEA5566BD9B1F3C74FD9A5CF5D N N N N N N N N N N N N N N N N N N N N N N N N N N N N N [BLOB - 0B] [BLOB - 0B] [BLOB - 0B] 0 0 0 0 NULL

 

Resync Tool / Resync shell users / start

what i should do now as i still cant log to mysql

 

you right Sir, i used the phpmyadmin password and it is working.
in my ispconfig i have 2 domain name, one of them work o.k but the second domain all database are not running
what could be the problem?

Thank you