O MySQL não pode reiniciar depois que lower_case_tables_names mudou

1

Estou tentando mudar o lower_case_tables_names para o valor 1 no Ubuntu 17.10, mas quando recebo um erro no mysql start, quando lower_case_tables_name = 1:

-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has finished shutting down.
Oct 31 13:36:12 www-v2 systemd[1]: Starting MySQL Community Server...
-- Subject: Unit mysql.service has begun start-up
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has begun starting up.
Oct 31 13:36:12 www-v2 audit[2657]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2657/status" pid=2657 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Oct 31 13:36:12 www-v2 audit[2657]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2657 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid
Oct 31 13:36:12 www-v2 audit[2657]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2657/status" pid=2657 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=109 ouid=109
Oct 31 13:36:12 www-v2 kernel: audit: type=1400 audit(1509446172.174:86): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2657/status" pid=2657 comm="mysqld" requested_mask="r" deni
Oct 31 13:36:12 www-v2 kernel: audit: type=1400 audit(1509446172.174:87): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=2657 comm="mysqld" requested_mask=
Oct 31 13:36:12 www-v2 kernel: audit: type=1400 audit(1509446172.174:88): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/2657/status" pid=2657 comm="mysqld" requested_mask="r" deni
Oct 31 13:36:14 www-v2 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Quando lower_case_tables_name = 0 o mysql começa correto.

Como mudar o mysql para lower_case_tables_name = 1 no Ubuntu 17.10?

Obrigado!

    
por Arthur Khusntudinov 31.10.2017 / 11:41

0 respostas