var/log/mysql.log 0 байт
mysql.err 0 байт
все время спотыкался о них и думал что логов вообще нет
а оказывается этот хитрец прячет их в /var/log/mysql/error.log
и их за полгода там накопилось аж 100мб.
а я всё это время думал не переустановить ли мне Ubuntu раз даже логи не сохраняются.
случайно вообще нашёл.
110413 0:00:33 InnoDB: Waiting for the background threads to start
110413 0:00:34 InnoDB: 1.1.5 started; log sequence number 1610330
110413 0:00:34 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'
110413 0:01:03 [Note] Plugin 'FEDERATED' is disabled.
110413 0:01:03 InnoDB: The InnoDB memory heap is disabled
110413 0:01:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110413 0:01:03 InnoDB: Compressed tables use zlib 1.2.3
110413 0:01:03 InnoDB: Using Linux native AIO
110413 0:01:03 InnoDB: Initializing buffer pool, size = 128.0M
110413 0:01:03 InnoDB: Completed initialization of buffer pool
110413 0:01:03 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110413 0:01:03 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
110413 0:01:03 InnoDB: Waiting for the background threads to start
110413 0:01:04 InnoDB: 1.1.5 started; log sequence number 1610330
110413 0:01:04 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect file format 'host'
110413 0:01:33 [Note] Plugin 'FEDERATED' is disabled.
110413 0:01:33 InnoDB: The InnoDB memory heap is disabled
110413 0:01:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
110413 0:01:33 InnoDB: Compressed tables use zlib 1.2.3
110413 0:01:33 InnoDB: Using Linux native AIO
110413 0:01:33 InnoDB: Initializing buffer pool, size = 128.0M
110413 0:01:33 InnoDB: Completed initialization of buffer pool
110413 0:01:33 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
110413 0:01:33 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
делал это
al@al-desktop:~$ sudo mysql_upgrade
[sudo] password for al:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock'
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
al@al-desktop:~$ sudo mc
не помогло
запускается только вот так
al@al-desktop:~$ sudo mysqld --skip-grant
похоже неисправна таблица авторизации какаято
root@al-desktop:~# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.5.9 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
О дело наконец пошло!!!
ysql> repair table host
-> ;
+------------+--------+----------+------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------+--------+----------+------------------------------+
| mysql.host | repair | Error | Incorrect file format 'host' |
| mysql.host | repair | error | Corrupt |
+------------+--------+----------+------------------------------+
пока правда не понял как лучше починить
пересоздал таблицы как тут -
http://mihouny.blogspot.com/2009/12/incorrect-information-in-file.htmlне помогло
al@al-desktop:~$ sudo /usr/bin/mysqladmin -u root password asdf
/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!
al@al-desktop:~$ cd /usr/mysql-test ; perl mysql-test-run.pl
bash: cd: /usr/mysql-test: Нет такого файла или каталога
Can't open perl script "mysql-test-run.pl": Нет такого файла или каталога
al@al-desktop:~$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
al@al-desktop:~$ sudo dpkg-reconfigure mysql-server
al@al-desktop:~$ sudo service mysql restart
* MySQL server PID file could not be found!
Starting MySQL
.......................
и много много точек и
........................... * The server quit without updating PID file (/media/E/Work/mysql/al-desktop.pid).
al@al-desktop:~$
это домашний комп, это не сервер
я в принципе не нуждаюсь в авторизации...хотя конечно знать как фиксить не против
но это не обязательно
можно ли тупо sudo mysqld --skip-grant вместо обычного запуска прописать ?