XAMPP: Couldn't start MySQL! [Solved]
Posted: 07. May 2012 10:05
After adding new vhost and some time (i come today and its just dead, maybe not only "just dead" - other coder creates some new bases two days ago, but SQL server dies only after xampp restarting) -
Starting XAMPP for Linux 1.7.7...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
Warning: World-writable config file '/opt/lampp/etc/my.cnf' is ignored
XAMPP: Couldn't start MySQL!
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
I used command from another topic -
[root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf
-rwxrwxrwx 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf
[root@gn141 ~]# chmod 644 /opt/lampp/etc/my.cnf
[root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf
-rw-r--r-- 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf
(my.cnf wasnt modified since install)
and now it just XAMPP: Couldn't start MySQL!
Error log - gn141.zone.eu.err
120507 10:48:14 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
120507 10:48:14 [Note] Plugin 'FEDERATED' is disabled.
/opt/lampp/sbin/mysqld: Table 'mysql.plugin' doesn't exist
120507 10:48:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120507 10:48:14 InnoDB: The InnoDB memory heap is disabled
120507 10:48:14 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120507 10:48:14 InnoDB: Compressed tables use zlib 1.2.3
120507 10:48:14 InnoDB: Initializing buffer pool, size = 16.0M
120507 10:48:14 InnoDB: Completed initialization of buffer pool
120507 10:48:14 InnoDB: highest supported file format is Barracuda.
120507 10:48:14 InnoDB: Waiting for the background threads to start
120507 10:48:15 InnoDB: 1.1.8 started; log sequence number 627359224
120507 10:48:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120507 10:48:15 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/gn141.zone.eu.pid ended
Also a httpd.pid file near the log with 11862 inside
What it can be? (And/or how i can reinstall xampp and save DBs and other stuff? And any good autobackup tool for xampp please.)
Starting XAMPP for Linux 1.7.7...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
Warning: World-writable config file '/opt/lampp/etc/my.cnf' is ignored
XAMPP: Couldn't start MySQL!
XAMPP: Starting ProFTPD...
XAMPP for Linux started.
I used command from another topic -
[root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf
-rwxrwxrwx 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf
[root@gn141 ~]# chmod 644 /opt/lampp/etc/my.cnf
[root@gn141 ~]# ls -l /opt/lampp/etc/my.cnf
-rw-r--r-- 1 root root 5054 Dec 17 2010 /opt/lampp/etc/my.cnf
(my.cnf wasnt modified since install)
and now it just XAMPP: Couldn't start MySQL!
Error log - gn141.zone.eu.err
120507 10:48:14 mysqld_safe Starting mysqld daemon with databases from /opt/lampp/var/mysql
120507 10:48:14 [Note] Plugin 'FEDERATED' is disabled.
/opt/lampp/sbin/mysqld: Table 'mysql.plugin' doesn't exist
120507 10:48:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120507 10:48:14 InnoDB: The InnoDB memory heap is disabled
120507 10:48:14 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
120507 10:48:14 InnoDB: Compressed tables use zlib 1.2.3
120507 10:48:14 InnoDB: Initializing buffer pool, size = 16.0M
120507 10:48:14 InnoDB: Completed initialization of buffer pool
120507 10:48:14 InnoDB: highest supported file format is Barracuda.
120507 10:48:14 InnoDB: Waiting for the background threads to start
120507 10:48:15 InnoDB: 1.1.8 started; log sequence number 627359224
120507 10:48:15 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120507 10:48:15 mysqld_safe mysqld from pid file /opt/lampp/var/mysql/gn141.zone.eu.pid ended
Also a httpd.pid file near the log with 11862 inside
What it can be? (And/or how i can reinstall xampp and save DBs and other stuff? And any good autobackup tool for xampp please.)