Форум русскоязычного сообщества Ubuntu


Получить помощь и пообщаться с другими пользователями Ubuntu можно
на irc канале #ubuntu-ru в сети Freenode
и в Jabber конференции ubuntu@conference.jabber.ru

Автор Тема: Не запускается mysql  (Прочитано 2216 раз)

0 Пользователей и 1 Гость просматривают эту тему.

andrey95

  • Автор темы
  • Гость
Не запускается mysql
« : 06 Июля 2010, 18:40:18 »
Здраствуйте!
Кто-то просвятит почему не запускапется mysql?

Цитировать
cat error.log

100704  8:24:48 [Note] /usr/sbin/mysqld: Normal shutdown

100704  8:24:48 [Note] Event Scheduler: Purging the queue. 0 events
100704  8:24:48  InnoDB: Starting shutdown...
100704  8:24:48  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:24:49 [Note] /usr/sbin/mysqld: Shutdown complete

100704  8:30:01 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:01  InnoDB: Started; log sequence number 0 44243
100704  8:30:01  InnoDB: Starting shutdown...
100704  8:30:02  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:30:02 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:03  InnoDB: Started; log sequence number 0 44243
100704  8:30:03  InnoDB: Starting shutdown...
100704  8:30:04  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:30:04 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:04  InnoDB: Started; log sequence number 0 44243
ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
100704  8:30:04 [ERROR] Aborting

100704  8:30:04  InnoDB: Starting shutdown...
100704  8:30:05  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:30:05 [Note] /usr/sbin/mysqld: Shutdown complete

100704  8:30:05 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:06  InnoDB: Started; log sequence number 0 44243
100704  8:30:06  InnoDB: Starting shutdown...
100704  8:30:07  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:30:07 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:07  InnoDB: Started; log sequence number 0 44243
ERROR: 1050  Table 'plugin' already exists
100704  8:30:07 [ERROR] Aborting

100704  8:30:07  InnoDB: Starting shutdown...
100704  8:30:08  InnoDB: Shutdown completed; log sequence number 0 44243
100704  8:30:08 [Note] /usr/sbin/mysqld: Shutdown complete

100704  8:30:09 [Note] Plugin 'FEDERATED' is disabled.
100704  8:30:09  InnoDB: Started; log sequence number 0 44243
100704  8:30:09 [Note] Event Scheduler: Loaded 0 events
100704  8:30:09 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.3'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
100704  8:40:35 [Note] /usr/sbin/mysqld: Normal shutdown

100704  8:40:35 [Note] Event Scheduler: Purging the queue. 0 events
100704  8:40:35  InnoDB: Starting shutdown...
100704  8:40:36  InnoDB: Shutdown completed; log sequence number 0 44253
100704  8:40:36 [Note] /usr/sbin/mysqld: Shutdown complete



Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql restart

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the restart(8) utility, e.g. restart mysql
start: Job failed to start

Заранее спасибо.




Оффлайн Sam Stone

  • Старожил
  • *
  • Сообщений: 1131
    • Просмотр профиля
Re: Не запускается mysql
« Ответ #1 : 06 Июля 2010, 21:49:12 »
маловато этих логов. В сислоге что-нибудь еще есть?
Jellyfish 6.5.0-45-generic
2690v4 64Gb

Оффлайн SvMidi

  • Активист
  • *
  • Сообщений: 815
    • Просмотр профиля
Re: Не запускается mysql
« Ответ #2 : 06 Июля 2010, 21:52:18 »
service mysql start ?
Я знаю только то, что ничего не знаю, остальные не знают и этого.

andrey95

  • Автор темы
  • Гость
Re: Не запускается mysql
« Ответ #3 : 06 Июля 2010, 23:16:51 »
Цитировать
cat /var/log/syslog | grep mysql
Jul  6 17:14:53 gateway init: mysql pre-start process (6616) terminated with status 1
Jul  6 17:17:47 gateway init: mysql pre-start process (6655) terminated with status 1
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jul  6 17:26:00 gateway mysqld[6980]: To do so, start the server, then issue the following commands:
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: /usr/bin/mysqladmin -u root password 'new-password'
Jul  6 17:26:00 gateway mysqld[6980]: /usr/bin/mysqladmin -u root -h gateway password 'new-password'
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: Alternatively you can run:
Jul  6 17:26:00 gateway mysqld[6980]: /usr/bin/mysql_secure_installation
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: which will also give you the option of removing the test
Jul  6 17:26:00 gateway mysqld[6980]: databases and anonymous user created by default.  This is
Jul  6 17:26:00 gateway mysqld[6980]: strongly recommended for production servers.
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: See the manual for more instructions.
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: Please report any problems with the /usr/bin/mysqlbug script!
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[6980]: The latest information about MySQL is available at http://www.mysql.com/
Jul  6 17:26:00 gateway mysqld[6980]: Support MySQL by buying support/licenses from http://shop.mysql.com/
Jul  6 17:26:00 gateway mysqld[6980]:
Jul  6 17:26:00 gateway mysqld[7010]: 100706 17:26:00 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: The first specified data file ./ibdata1 did not exist:
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: a new database to be created!
Jul  6 17:26:00 gateway mysqld[7010]: 100706 17:26:00  InnoDB: Setting file ./ibdata1 size to 10 MB
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: Database physically writes the file full: wait...
Jul  6 17:26:00 gateway mysqld[7010]: 100706 17:26:00  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: Setting log file ./ib_logfile0 size to 5 MB
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: Database physically writes the file full: wait...
Jul  6 17:26:00 gateway mysqld[7010]: 100706 17:26:00  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: Setting log file ./ib_logfile1 size to 5 MB
Jul  6 17:26:00 gateway mysqld[7010]: InnoDB: Database physically writes the file full: wait...
Jul  6 17:26:01 gateway mysqld[7010]: InnoDB: Doublewrite buffer not found: creating new
Jul  6 17:26:01 gateway mysqld[7010]: InnoDB: Doublewrite buffer created
Jul  6 17:26:01 gateway mysqld[7010]: InnoDB: Creating foreign key constraint system tables
Jul  6 17:26:01 gateway mysqld[7010]: InnoDB: Foreign key constraint system tables created
Jul  6 17:26:01 gateway mysqld[7010]: 100706 17:26:01  InnoDB: Started; log sequence number 0 0
Jul  6 17:26:01 gateway mysqld[7010]: 100706 17:26:01 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
Jul  6 17:26:01 gateway mysqld[7010]: ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
Jul  6 17:26:01 gateway mysqld[7010]: 100706 17:26:01 [ERROR] Aborting
Jul  6 17:26:01 gateway mysqld[7010]:
Jul  6 17:26:01 gateway mysqld[7010]: 100706 17:26:01  InnoDB: Starting shutdown...
Jul  6 17:26:02 gateway mysqld[7010]: 100706 17:26:02  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:26:02 gateway mysqld[7010]: 100706 17:26:02 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:26:02 gateway mysqld[7010]:
Jul  6 17:26:04 gateway mysqld[7039]: 100706 17:26:04 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:26:04 gateway mysqld[7039]: 100706 17:26:04  InnoDB: Started; log sequence number 0 44233
Jul  6 17:26:04 gateway mysqld[7039]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul  6 17:26:04 gateway mysqld[7039]: 100706 17:26:04 [ERROR] Aborting
Jul  6 17:26:04 gateway mysqld[7039]:
Jul  6 17:26:04 gateway mysqld[7039]: 100706 17:26:04  InnoDB: Starting shutdown...
Jul  6 17:26:05 gateway mysqld[7039]: 100706 17:26:05  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:26:05 gateway mysqld[7039]: 100706 17:26:05 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:26:05 gateway mysqld[7039]:
Jul  6 17:26:05 gateway mysqld[7053]: 100706 17:26:05 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:26:06 gateway mysqld[7053]: 100706 17:26:06  InnoDB: Started; log sequence number 0 44233
Jul  6 17:26:06 gateway mysqld[7053]: 100706 17:26:06 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/user.frm' (errno: 13)
Jul  6 17:26:06 gateway mysqld[7053]: ERROR: 1017  Can't find file: './mysql/user.frm' (errno: 13)
Jul  6 17:26:06 gateway mysqld[7053]: 100706 17:26:06 [ERROR] Aborting
Jul  6 17:26:06 gateway mysqld[7053]:
Jul  6 17:26:06 gateway mysqld[7053]: 100706 17:26:06  InnoDB: Starting shutdown...
Jul  6 17:26:07 gateway mysqld[7053]: 100706 17:26:07  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:26:07 gateway mysqld[7053]: 100706 17:26:07 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:26:07 gateway mysqld[7053]:
Jul  6 17:26:07 gateway mysqld[7067]: 100706 17:26:07 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:26:07 gateway mysqld[7067]: 100706 17:26:07  InnoDB: Started; log sequence number 0 44233
Jul  6 17:26:07 gateway mysqld[7067]: ERROR: 1050  Table 'plugin' already exists
Jul  6 17:26:07 gateway mysqld[7067]: 100706 17:26:07 [ERROR] Aborting
Jul  6 17:26:07 gateway mysqld[7067]:
Jul  6 17:26:07 gateway mysqld[7067]: 100706 17:26:07  InnoDB: Starting shutdown...
Jul  6 17:26:08 gateway mysqld[7067]: 100706 17:26:08  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:26:08 gateway mysqld[7067]: 100706 17:26:08 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:26:08 gateway mysqld[7067]:
Jul  6 17:26:09 gateway kernel: [184811.386009] type=1505 audit(1278426369.092:11):  operation="profile_replace" pid=7080 name="/usr/sbin/mysqld"
Jul  6 17:26:18 gateway init: mysql pre-start process (7085) terminated with status 1
Jul  6 17:30:13 gateway init: mysql pre-start process (7573) terminated with status 1
Jul  6 17:31:38 gateway kernel: [185140.292873] type=1503 audit(1278426698.002:12):  operation="capable" pid=7763 parent=7751 profile="/usr/sbin/mysqld" name="chown"
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jul  6 17:31:38 gateway mysqld[7752]: To do so, start the server, then issue the following commands:
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: /usr/bin/mysqladmin -u root password 'new-password'
Jul  6 17:31:38 gateway mysqld[7752]: /usr/bin/mysqladmin -u root -h gateway password 'new-password'
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: Alternatively you can run:
Jul  6 17:31:38 gateway mysqld[7752]: /usr/bin/mysql_secure_installation
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: which will also give you the option of removing the test
Jul  6 17:31:38 gateway mysqld[7752]: databases and anonymous user created by default.  This is
Jul  6 17:31:38 gateway mysqld[7752]: strongly recommended for production servers.
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: See the manual for more instructions.
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: Please report any problems with the /usr/bin/mysqlbug script!
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7752]: The latest information about MySQL is available at http://www.mysql.com/
Jul  6 17:31:38 gateway mysqld[7752]: Support MySQL by buying support/licenses from http://shop.mysql.com/
Jul  6 17:31:38 gateway mysqld[7752]:
Jul  6 17:31:38 gateway mysqld[7783]: 100706 17:31:38 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:31:38 gateway mysqld[7783]: 100706 17:31:38  InnoDB: Started; log sequence number 0 44233
Jul  6 17:31:38 gateway mysqld[7783]: 100706 17:31:38  InnoDB: Starting shutdown...
Jul  6 17:31:39 gateway mysqld[7783]: 100706 17:31:39  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:31:41 gateway mysqld[7813]: 100706 17:31:41 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:31:41 gateway mysqld[7813]: 100706 17:31:41  InnoDB: Started; log sequence number 0 44233
Jul  6 17:31:41 gateway mysqld[7813]: ERROR: 1064  You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul  6 17:31:41 gateway mysqld[7813]: 100706 17:31:41 [ERROR] Aborting
Jul  6 17:31:41 gateway mysqld[7813]:
Jul  6 17:31:41 gateway mysqld[7813]: 100706 17:31:41  InnoDB: Starting shutdown...
Jul  6 17:31:42 gateway mysqld[7813]: 100706 17:31:42  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:31:42 gateway mysqld[7813]: 100706 17:31:42 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:31:42 gateway mysqld[7813]:
Jul  6 17:31:42 gateway mysqld[7827]: 100706 17:31:42 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:31:42 gateway mysqld[7827]: 100706 17:31:42  InnoDB: Started; log sequence number 0 44233
Jul  6 17:31:42 gateway mysqld[7827]: 100706 17:31:42  InnoDB: Starting shutdown...
Jul  6 17:31:44 gateway mysqld[7827]: 100706 17:31:44  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:31:44 gateway mysqld[7841]: 100706 17:31:44 [Note] Plugin 'FEDERATED' is disabled.
Jul  6 17:31:44 gateway mysqld[7841]: 100706 17:31:44  InnoDB: Started; log sequence number 0 44233
Jul  6 17:31:44 gateway mysqld[7841]: ERROR: 1050  Table 'plugin' already exists
Jul  6 17:31:44 gateway mysqld[7841]: 100706 17:31:44 [ERROR] Aborting
Jul  6 17:31:44 gateway mysqld[7841]:
Jul  6 17:31:44 gateway mysqld[7841]: 100706 17:31:44  InnoDB: Starting shutdown...
Jul  6 17:31:45 gateway mysqld[7841]: 100706 17:31:45  InnoDB: Shutdown completed; log sequence number 0 44233
Jul  6 17:31:45 gateway mysqld[7841]: 100706 17:31:45 [Note] /usr/sbin/mysqld: Shutdown complete
Jul  6 17:31:45 gateway mysqld[7841]:
Jul  6 17:31:45 gateway kernel: [185148.179433] type=1505 audit(1278426705.882:13):  operation="profile_replace" pid=7854 name="/usr/sbin/mysqld"
Jul  6 17:31:45 gateway init: mysql pre-start process (7857) terminated with status 1
Jul  6 17:35:08 gateway init: mysql pre-start process (7874) terminated with status 1
Jul  6 18:59:12 gateway init: mysql pre-start process (621) terminated with status 1
Jul  6 18:59:15 gateway kernel: [    9.569693] type=1505 audit(1278431955.346:9):  operation="profile_load" pid=903 name="/usr/sbin/mysqld"


 

Страница сгенерирована за 0.03 секунд. Запросов: 23.