Почему не запускается mysql?
Не запускается mysql. Уже по форумам лазил ответа не нашел, горит.
OS: Ubuntu
~# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
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(8) utility, e.g. start mysql
start: Job failed to start
~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Логи почему-то не доступен, файл сокета есть, удалил новый создал, не помогает
dmesg | grep mysql
[ 7.027970] type=1400 audit(1424753284.708:11): apparmor=«STATUS» operation=" profile_load" name="/usr/sbin/mysqld" pid=1171 comm=«apparmor_parser»
[ 7.157868] type=1400 audit(1424753284.836:17): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=1241 comm=«apparmor_parser»
[ 7.263419] init: mysql pre-start process (1207) terminated with status 1
[ 129.654859] type=1400 audit(1424753407.381:18): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2204 comm=«apparmor_parser»
[ 129.663277] init: mysql pre-start process (2199) terminated with status 1
[ 228.496572] type=1400 audit(1424753506.245:19): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2520 comm=«apparmor_parser»
[ 228.505539] init: mysql pre-start process (2515) terminated with status 1
[ 335.065495] type=1400 audit(1424753612.837:20): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2961 comm=«apparmor_parser»
[ 335.073773] init: mysql pre-start process (2956) terminated with status 1
[ 339.946226] type=1400 audit(1424753617.721:21): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3000 comm=«apparmor_parser»
[ 339.956350] init: mysql pre-start process (2995) terminated with status 1
[ 424.921841] type=1400 audit(1424753702.713:22): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3426 comm=«apparmor_parser»
[ 424.929737] init: mysql pre-start process (3421) terminated with status 1
[ 476.123236] type=1400 audit(1424753753.925:23): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3563 comm=«apparmor_parser»
[ 476.131195] init: mysql pre-start process (3558) terminated with status 1
[ 512.187754] type=1400 audit(1424753789.997:24): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3602 comm=«apparmor_parser»
[ 512.198887] init: mysql pre-start process (3597) terminated with status 1
[ 522.306080] type=1400 audit(1424753800.121:25): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3624 comm=«apparmor_parser»
[ 522.314537] init: mysql pre-start process (3619) terminated with status 1
[ 662.607542] type=1400 audit(1424753940.453:26): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3974 comm=«apparmor_parser»
[ 662.617058] init: mysql pre-start process (3969) terminated with status 1
[ 667.804558] type=1400 audit(1424753945.649:27): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=4026 comm=«apparmor_parser»
[ 667.815854] init: mysql pre-start process (4021) terminated with status 1
[ 678.444050] type=1400 audit(1424753956.293:28): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=4109 comm=«apparmor_parser»
[ 678.453641] init: mysql pre-start process (4104) terminated with status 1
[ 1077.515441] type=1400 audit(1424754355.453:29): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=5771 comm=«apparmor_parser»
[ 1077.523565] init: mysql pre-start process (5766) terminated with status 1
[ 1125.823664] type=1400 audit(1424754403.769:30): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=5948 comm=«apparmor_parser»
[ 1125.833320] init: mysql pre-start process (5943) terminated with status 1
[ 1457.960510] type=1400 audit(1424754735.981:31): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=6971 comm=«apparmor_parser»
[ 1457.969377] init: mysql pre-start process (6966) terminated with status 1
[ 2667.304728] type=1400 audit(1424755945.589:32): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=12067 comm=«apparmor_parser»
[ 2667.312601] init: mysql pre-start process (12062) terminated with status 1
[ 3085.746746] type=1400 audit(1424756364.125:33): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=14443 comm=«apparmor_parser»
[ 3085.754586] init: mysql pre-start process (14438) terminated with status 1
[ 9273.197805] type=1400 audit(1424762552.941:34): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=22105 comm=«apparmor_parser»
[ 9273.491185] init: mysql pre-start process (22100) terminated with status 1
[ 9285.657012] type=1400 audit(1424762565.401:35): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=22216 comm=«apparmor_parser»
[ 9285.665429] init: mysql pre-start process (22211) terminated with status 1
OS: Ubuntu
~# /etc/init.d/mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
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(8) utility, e.g. start mysql
start: Job failed to start
~# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Логи почему-то не доступен, файл сокета есть, удалил новый создал, не помогает
dmesg | grep mysql
[ 7.027970] type=1400 audit(1424753284.708:11): apparmor=«STATUS» operation=" profile_load" name="/usr/sbin/mysqld" pid=1171 comm=«apparmor_parser»
[ 7.157868] type=1400 audit(1424753284.836:17): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=1241 comm=«apparmor_parser»
[ 7.263419] init: mysql pre-start process (1207) terminated with status 1
[ 129.654859] type=1400 audit(1424753407.381:18): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2204 comm=«apparmor_parser»
[ 129.663277] init: mysql pre-start process (2199) terminated with status 1
[ 228.496572] type=1400 audit(1424753506.245:19): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2520 comm=«apparmor_parser»
[ 228.505539] init: mysql pre-start process (2515) terminated with status 1
[ 335.065495] type=1400 audit(1424753612.837:20): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=2961 comm=«apparmor_parser»
[ 335.073773] init: mysql pre-start process (2956) terminated with status 1
[ 339.946226] type=1400 audit(1424753617.721:21): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3000 comm=«apparmor_parser»
[ 339.956350] init: mysql pre-start process (2995) terminated with status 1
[ 424.921841] type=1400 audit(1424753702.713:22): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3426 comm=«apparmor_parser»
[ 424.929737] init: mysql pre-start process (3421) terminated with status 1
[ 476.123236] type=1400 audit(1424753753.925:23): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3563 comm=«apparmor_parser»
[ 476.131195] init: mysql pre-start process (3558) terminated with status 1
[ 512.187754] type=1400 audit(1424753789.997:24): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3602 comm=«apparmor_parser»
[ 512.198887] init: mysql pre-start process (3597) terminated with status 1
[ 522.306080] type=1400 audit(1424753800.121:25): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3624 comm=«apparmor_parser»
[ 522.314537] init: mysql pre-start process (3619) terminated with status 1
[ 662.607542] type=1400 audit(1424753940.453:26): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=3974 comm=«apparmor_parser»
[ 662.617058] init: mysql pre-start process (3969) terminated with status 1
[ 667.804558] type=1400 audit(1424753945.649:27): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=4026 comm=«apparmor_parser»
[ 667.815854] init: mysql pre-start process (4021) terminated with status 1
[ 678.444050] type=1400 audit(1424753956.293:28): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=4109 comm=«apparmor_parser»
[ 678.453641] init: mysql pre-start process (4104) terminated with status 1
[ 1077.515441] type=1400 audit(1424754355.453:29): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=5771 comm=«apparmor_parser»
[ 1077.523565] init: mysql pre-start process (5766) terminated with status 1
[ 1125.823664] type=1400 audit(1424754403.769:30): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=5948 comm=«apparmor_parser»
[ 1125.833320] init: mysql pre-start process (5943) terminated with status 1
[ 1457.960510] type=1400 audit(1424754735.981:31): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=6971 comm=«apparmor_parser»
[ 1457.969377] init: mysql pre-start process (6966) terminated with status 1
[ 2667.304728] type=1400 audit(1424755945.589:32): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=12067 comm=«apparmor_parser»
[ 2667.312601] init: mysql pre-start process (12062) terminated with status 1
[ 3085.746746] type=1400 audit(1424756364.125:33): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=14443 comm=«apparmor_parser»
[ 3085.754586] init: mysql pre-start process (14438) terminated with status 1
[ 9273.197805] type=1400 audit(1424762552.941:34): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=22105 comm=«apparmor_parser»
[ 9273.491185] init: mysql pre-start process (22100) terminated with status 1
[ 9285.657012] type=1400 audit(1424762565.401:35): apparmor=«STATUS» operation=" profile_replace" name="/usr/sbin/mysqld" pid=22216 comm=«apparmor_parser»
[ 9285.665429] init: mysql pre-start process (22211) terminated with status 1
Похожие публикации
как проверить работоспособность мускул сервера
Проблема с базой?
MySQL: как при удаленном запросе получить данные о результатах выполнения как при локальном запросе?
ошибка при загрузке дампа БД
Что это за ошибка innodb?
Нет комментариев