Не могу запустить mysql

[coolman]

установил новое ядро перезагрузился и все

root@ubuntu:~# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(
utility, e.g. service mysql start

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


dpkg -l | grep mysql

ii  libdbd-mysql-perl                       4.020-1build2                Perl5 database interface to the MySQL database
ii  libmysqlclient18                        5.5.22-0ubuntu1              MySQL database client library
ii  mysql-client-5.5                        5.5.22-0ubuntu1              MySQL database client binaries
ii  mysql-client-core-5.5                   5.5.22-0ubuntu1              MySQL database core client binaries
ii  mysql-common                            5.5.22-0ubuntu1              MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                            5.5.22-0ubuntu1              MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.5                        5.5.22-0ubuntu1              MySQL database server binaries and system database setup
ii  mysql-server-core-5.5                   5.5.22-0ubuntu1              MySQL database server binaries
ii  php5-mysql                              5.3.10-1ubuntu2              MySQL module for php5


 uname -a
Linux ubuntu 3.4.0-030400rc2-generic-pae #201204072235 SMP Sun Apr 8 02:50:00 UTC 2012 i686 athlon i386 GNU/Linux



/etc/mysql/my.cnf

[client]
port      = 3306
socket      = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket      = /var/run/mysqld/mysqld.sock
nice      = 0

[mysqld]


user      = mysql
pid-file   = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir      = /usr
datadir = /var/lib/mysql
tmpdir      = /tmp
lc-messages-dir   = /usr/share/mysql
skip-external-locking



key_buffer      = 16M
max_allowed_packet   = 16M
thread_stack      = 192K
thread_cache_size       = 8


myisam-recover         = BACKUP


query_cache_limit   = 1M
query_cache_size = 16M

expire_logs_days   = 10
max_binlog_size         = 100M

[mysqldump]
quick
quote-names
max_allowed_packet   = 16M

[mysql]


[isamchk]
key_buffer      = 16M



!includedir /etc/mysql/conf.d/

[victor00000]

Код: [Выделить]

/etc/init.d/mysql status?

[coolman]

попробовал сделать
sudo dpkg-reconfigure mysql-server-5.5

root@ubuntu:~# sudo dpkg-reconfigure mysql-server-5.5
120409 10:04:43 [Note] Plugin 'FEDERATED' is disabled.
120409 10:04:43 InnoDB: The InnoDB memory heap is disabled
120409 10:04:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120409 10:04:43 InnoDB: Compressed tables use zlib 1.2.3.4
120409 10:04:43 InnoDB: Initializing buffer pool, size = 128.0M
120409 10:04:43 InnoDB: Completed initialization of buffer pool
120409 10:04:43 InnoDB: highest supported file format is Barracuda.
120409 10:04:44  InnoDB: Waiting for the background threads to start
120409 10:04:45 InnoDB: 1.1.8 started; log sequence number 12394944
120409 10:04:45  InnoDB: Starting shutdown...
120409 10:04:45  InnoDB: Shutdown completed; log sequence number 12394944
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
Пользователь решил продолжить мысль 09 Апреля 2012, 08:04:52:

Код: [Выделить]

/etc/init.d/mysql status?

root@ubuntu:~# /etc/init.d/mysql status
Rather than invoking init scripts through /etc/init.d, use the service(
utility, e.g. service mysql status

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the status( utility, e.g. status mysql
mysql stop/waiting

базы все на месте скрипты не менял

Пользователь решил продолжить мысль 09 Апреля 2012, 08:10:09:в логах:

Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: To do so, start the server, then issue the following commands:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: /usr/bin/mysqladmin -u root password 'new-password'
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: /usr/bin/mysqladmin -u root -h ubuntu password 'new-password'
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: Alternatively you can run:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: /usr/bin/mysql_secure_installation
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: which will also give you the option of removing the test
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: databases and anonymous user created by default.  This is
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: strongly recommended for production servers.
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: See the manual for more instructions.
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4861]: Please report any problems with the /usr/scripts/mysqlbug script!
Apr  9 10:04:41 ubuntu mysqld_safe[4861]:
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 [Note] Plugin 'FEDERATED' is disabled.
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: The InnoDB memory heap is disabled
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: Compressed tables use zlib 1.2.3.4
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: Initializing buffer pool, size = 128.0M
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: Completed initialization of buffer pool
Apr  9 10:04:41 ubuntu mysqld_safe[4907]: 120409 10:04:41 InnoDB: highest supported file format is Barracuda.
Apr  9 10:04:42 ubuntu mysqld_safe[4907]: 120409 10:04:42  InnoDB: Waiting for the background threads to start
Apr  9 10:04:43 ubuntu mysqld_safe[4907]: 120409 10:04:43 InnoDB: 1.1.8 started; log sequence number 12394944
Apr  9 10:04:43 ubuntu mysqld_safe[4907]: 120409 10:04:43  InnoDB: Starting shutdown...
Apr  9 10:04:43 ubuntu mysqld_safe[4907]: 120409 10:04:43  InnoDB: Shutdown completed; log sequence number 12394944
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 [Note] Plugin 'FEDERATED' is disabled.
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: The InnoDB memory heap is disabled
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: Compressed tables use zlib 1.2.3.4
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: Initializing buffer pool, size = 128.0M
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: Completed initialization of buffer pool
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45 InnoDB: highest supported file format is Barracuda.
Apr  9 10:04:45 ubuntu mysqld_safe[4951]: 120409 10:04:45  InnoDB: Waiting for the background threads to start
Apr  9 10:04:46 ubuntu mysqld_safe[4951]: 120409 10:04:46 InnoDB: 1.1.8 started; log sequence number 12394944
Apr  9 10:04:46 ubuntu mysqld_safe[4951]: 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
Apr  9 10:04:46 ubuntu mysqld_safe[4951]: 120409 10:04:46 [ERROR] Aborting
Apr  9 10:04:46 ubuntu mysqld_safe[4951]:
Apr  9 10:04:46 ubuntu mysqld_safe[4951]: 120409 10:04:46  InnoDB: Starting shutdown...
Apr  9 10:04:47 ubuntu mysqld_safe[4951]: 120409 10:04:47  InnoDB: Shutdown completed; log sequence number 12394944
Apr  9 10:04:47 ubuntu mysqld_safe[4951]: 120409 10:04:47 [Note] /usr/sbin/mysqld: Shutdown complete
Apr  9 10:04:47 ubuntu mysqld_safe[4951]:
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 [Note] Plugin 'FEDERATED' is disabled.
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: The InnoDB memory heap is disabled
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: Compressed tables use zlib 1.2.3.4
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: Initializing buffer pool, size = 128.0M
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: Completed initialization of buffer pool
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47 InnoDB: highest supported file format is Barracuda.
Apr  9 10:04:47 ubuntu mysqld_safe[4972]: 120409 10:04:47  InnoDB: Waiting for the background threads to start
Apr  9 10:04:48 ubuntu mysqld_safe[4972]: 120409 10:04:48 InnoDB: 1.1.8 started; log sequence number 12394944
Apr  9 10:04:48 ubuntu mysqld_safe[4972]: 120409 10:04:48  InnoDB: Starting shutdown...
Apr  9 10:04:49 ubuntu mysqld_safe[4972]: 120409 10:04:49  InnoDB: Shutdown completed; log sequence number 12394944
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 [Note] Plugin 'FEDERATED' is disabled.
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: The InnoDB memory heap is disabled
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: Compressed tables use zlib 1.2.3.4
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: Initializing buffer pool, size = 128.0M
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: Completed initialization of buffer pool
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49 InnoDB: highest supported file format is Barracuda.
Apr  9 10:04:49 ubuntu mysqld_safe[4993]: 120409 10:04:49  InnoDB: Waiting for the background threads to start
Apr  9 10:04:50 ubuntu mysqld_safe[4993]: 120409 10:04:50 InnoDB: 1.1.8 started; log sequence number 12394944
Apr  9 10:04:50 ubuntu mysqld_safe[4993]: ERROR: 1050  Table 'plugin' already exists
Apr  9 10:04:50 ubuntu mysqld_safe[4993]: 120409 10:04:50 [ERROR] Aborting
Apr  9 10:04:50 ubuntu mysqld_safe[4993]:
Apr  9 10:04:50 ubuntu mysqld_safe[4993]: 120409 10:04:50  InnoDB: Starting shutdown...
Apr  9 10:04:51 ubuntu mysqld_safe[4993]: 120409 10:04:51  InnoDB: Shutdown completed; log sequence number 12394944
Apr  9 10:04:51 ubuntu mysqld_safe[4993]: 120409 10:04:51 [Note] /usr/sbin/mysqld: Shutdown complete
Apr  9 10:04:51 ubuntu mysqld_safe[4993]:
Пользователь решил продолжить мысль 09 Апреля 2012, 08:17:23:вернулся на это ядро:
uname -a
Linux ubuntu 3.3.1-030301-generic-pae #201204021435 SMP Mon Apr 2 18:49:49 UTC 2012 i686 athlon i386 GNU/Linux

и все заработало, ну ладно, ну хоть будем знать ))

[victor00000]

Код: [Выделить]

grep -Rs "\[ERROR]" /var/log/?

[coolman]

Код: [Выделить]

grep -Rs "\[ERROR]" /var/log/?

root@ubuntu:~# grep -Rs "\[ERROR]" /var/log/
/var/log/syslog:Apr  9 10:04:46 ubuntu mysqld_safe[4951]: 120409 10:04:46 [ERROR] Aborting
/var/log/syslog:Apr  9 10:04:50 ubuntu mysqld_safe[4993]: 120409 10:04:50 [ERROR] Aborting
/var/log/installer/syslog:Mar  6 20:07:55 mysqld_safe[11796]: 120306 20:07:55 [ERROR] Aborting
/var/log/installer/syslog:Mar  6 20:07:58 mysqld_safe[11838]: 120306 20:07:58 [ERROR] Aborting

[lewka_soad]

service mysql start Так пробовал запускать

[RN3QTB]

Подскажите, чем дело то закончилось? у меня то же самое!!!
В прцессах вроде бы есть, но сам не работает
 mysql start/post-start, process 11311
        post-start process 11312
при попытке остановить, перезапустить - зависает, ничего не пишет