blabub
27.05.06, 02:43
Hi
Heute schmierte mir der mysql-Server ab. Warum weiss ich noch nicht, jedenfalls geht er nicht mehr hoch.
debian:/# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sylog
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing db table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing host table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing user table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing func table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing tables_priv table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing columns_priv table
May 27 00:43:30 localhost mysqld_safe[25801]: Installing all prepared tables
May 27 00:43:30 localhost mysqld_safe[25801]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
May 27 00:43:30 localhost mysqld_safe[25801]: To do so, start the server, then issue the following commands:
May 27 00:43:30 localhost mysqld_safe[25801]: /usr/bin/mysqladmin -u root password 'new-password'
May 27 00:43:30 localhost mysqld_safe[25801]: /usr/bin/mysqladmin -u root -h debian password 'new-password'
May 27 00:43:30 localhost mysqld_safe[25801]: See the manual for more instructions.
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: Please report any problems with the /usr/bin/mysqlbug script!
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: The latest information about MySQL is available on the web at
May 27 00:43:30 localhost mysqld_safe[25801]: http://www.mysql.com
May 27 00:43:30 localhost mysqld_safe[25801]: Support MySQL by buying support/licenses at https://order.mysql.com
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25816]: 060527 2:43:30 /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25816]: ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25816]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25816]:
May 27 00:43:30 localhost mysqld_safe[25823]: 060527 2:43:30 /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25823]: ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25823]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25823]:
May 27 00:43:30 localhost mysqld_safe[25870]: started
May 27 00:43:31 localhost mysqld[25873]: InnoDB: The first specified data file ./ibdata1 did not exist:
May 27 00:43:31 localhost mysqld[25873]: InnoDB: a new database to be created!
May 27 00:43:31 localhost mysqld[25873]: 060527 2:43:31 InnoDB: Setting file ./ibdata1 size to 10 MB
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:31 localhost mysqld[25873]: 060527 2:43:31 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:32 localhost mysqld[25873]: 060527 2:43:32 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
May 27 00:43:32 localhost mysqld[25873]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
May 27 00:43:32 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:33 localhost mysqld[25873]: InnoDB: Doublewrite buffer not found: creating new
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Doublewrite buffer created
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Creating foreign key constraint system tables
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Foreign key constraint system tables created
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 InnoDB: Started
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 Aborting
May 27 00:43:41 localhost mysqld[25873]:
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 InnoDB: Starting shutdown...
May 27 00:43:43 localhost mysqld[25873]: 060527 2:43:43 InnoDB: Shutdown completed
May 27 00:43:43 localhost mysqld[25873]: 060527 2:43:43 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:43 localhost mysqld[25873]:
May 27 00:43:43 localhost mysqld_safe[25886]: ended
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 27 00:43:48 localhost /etc/init.d/mysql[25947]:
May 27 00:45:32 localhost mysqld_safe[25979]: started
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 InnoDB: Started
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 Aborting
May 27 00:45:32 localhost mysqld[25982]:
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 InnoDB: Starting shutdown...
May 27 00:45:35 localhost mysqld[25982]: 060527 2:45:35 InnoDB: Shutdown completed
May 27 00:45:35 localhost mysqld[25982]: 060527 2:45:35 /usr/sbin/mysqld: Shutdown Complete
May 27 00:45:35 localhost mysqld[25982]:
May 27 00:45:35 localhost mysqld_safe[26011]: ended
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 27 00:45:39 localhost /etc/init.d/mysql[26056]:
Ich verwende Debian Sarge, habe jetzt 1 Stunde lang bei Google gesucht, nix gefunden das mir half.
Danke im Vorraus!
Heute schmierte mir der mysql-Server ab. Warum weiss ich noch nicht, jedenfalls geht er nicht mehr hoch.
debian:/# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sylog
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing db table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing host table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing user table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing func table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing tables_priv table
May 27 00:43:30 localhost mysqld_safe[25801]: Preparing columns_priv table
May 27 00:43:30 localhost mysqld_safe[25801]: Installing all prepared tables
May 27 00:43:30 localhost mysqld_safe[25801]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
May 27 00:43:30 localhost mysqld_safe[25801]: To do so, start the server, then issue the following commands:
May 27 00:43:30 localhost mysqld_safe[25801]: /usr/bin/mysqladmin -u root password 'new-password'
May 27 00:43:30 localhost mysqld_safe[25801]: /usr/bin/mysqladmin -u root -h debian password 'new-password'
May 27 00:43:30 localhost mysqld_safe[25801]: See the manual for more instructions.
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: Please report any problems with the /usr/bin/mysqlbug script!
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25801]: The latest information about MySQL is available on the web at
May 27 00:43:30 localhost mysqld_safe[25801]: http://www.mysql.com
May 27 00:43:30 localhost mysqld_safe[25801]: Support MySQL by buying support/licenses at https://order.mysql.com
May 27 00:43:30 localhost mysqld_safe[25801]:
May 27 00:43:30 localhost mysqld_safe[25816]: 060527 2:43:30 /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25816]: ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25816]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25816]:
May 27 00:43:30 localhost mysqld_safe[25823]: 060527 2:43:30 /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25823]: ERROR: 1017 Can't find file: './mysql/user.frm' (errno: 13)
May 27 00:43:30 localhost mysqld_safe[25823]: 060527 2:43:30 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:30 localhost mysqld_safe[25823]:
May 27 00:43:30 localhost mysqld_safe[25870]: started
May 27 00:43:31 localhost mysqld[25873]: InnoDB: The first specified data file ./ibdata1 did not exist:
May 27 00:43:31 localhost mysqld[25873]: InnoDB: a new database to be created!
May 27 00:43:31 localhost mysqld[25873]: 060527 2:43:31 InnoDB: Setting file ./ibdata1 size to 10 MB
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:31 localhost mysqld[25873]: 060527 2:43:31 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
May 27 00:43:31 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:32 localhost mysqld[25873]: 060527 2:43:32 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
May 27 00:43:32 localhost mysqld[25873]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
May 27 00:43:32 localhost mysqld[25873]: InnoDB: Database physically writes the file full: wait...
May 27 00:43:33 localhost mysqld[25873]: InnoDB: Doublewrite buffer not found: creating new
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Doublewrite buffer created
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Creating foreign key constraint system tables
May 27 00:43:41 localhost mysqld[25873]: InnoDB: Foreign key constraint system tables created
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 InnoDB: Started
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 Aborting
May 27 00:43:41 localhost mysqld[25873]:
May 27 00:43:41 localhost mysqld[25873]: 060527 2:43:41 InnoDB: Starting shutdown...
May 27 00:43:43 localhost mysqld[25873]: 060527 2:43:43 InnoDB: Shutdown completed
May 27 00:43:43 localhost mysqld[25873]: 060527 2:43:43 /usr/sbin/mysqld: Shutdown Complete
May 27 00:43:43 localhost mysqld[25873]:
May 27 00:43:43 localhost mysqld_safe[25886]: ended
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 27 00:43:48 localhost /etc/init.d/mysql[25947]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 27 00:43:48 localhost /etc/init.d/mysql[25947]:
May 27 00:45:32 localhost mysqld_safe[25979]: started
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 InnoDB: Started
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 Aborting
May 27 00:45:32 localhost mysqld[25982]:
May 27 00:45:32 localhost mysqld[25982]: 060527 2:45:32 InnoDB: Starting shutdown...
May 27 00:45:35 localhost mysqld[25982]: 060527 2:45:35 InnoDB: Shutdown completed
May 27 00:45:35 localhost mysqld[25982]: 060527 2:45:35 /usr/sbin/mysqld: Shutdown Complete
May 27 00:45:35 localhost mysqld[25982]:
May 27 00:45:35 localhost mysqld_safe[26011]: ended
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 27 00:45:39 localhost /etc/init.d/mysql[26056]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 27 00:45:39 localhost /etc/init.d/mysql[26056]:
Ich verwende Debian Sarge, habe jetzt 1 Stunde lang bei Google gesucht, nix gefunden das mir half.
Danke im Vorraus!