New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
no i mean, even if i DONT login into mysql, and just do service mysql restart its there that error "[Note] Access denied for user 'root'@'localhost' (using password: NO)" after few lines where it says mysql starting etc etc ...
i am like wtf now really
reinstalled mysql and now:
Apr 12 17:46:02 xxx audit[12883]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12883/status" pid=12883 comm="mysqld" requested_mask="r" denied_mask="r" fsui
Apr 12 17:46:02 xxx audit[12883]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=12883 comm="mysqld" requested_mask="r" denied_mask="
Apr 12 17:46:02 xxx audit[12883]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12883/status" pid=12883 comm="mysqld" requested_mask="r" denied_mask="r" fsui
Apr 12 17:46:02 xxx kernel: audit: type=1400 audit(1492011962.106:8423): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12883/status" pid=12883 comm="mysqld" requ
Apr 12 17:46:02 xxx kernel: audit: type=1400 audit(1492011962.106:8424): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=12883 comm="mysql
Apr 12 17:46:02 xxx kernel: audit: type=1400 audit(1492011962.106:8425): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/12883/status" pid=12883 comm="mysqld" requ
Apr 12 17:46:02 xxx systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE
Disable apparmor, problem solved.
service apparmor stop
after mysql restart:
Apr 12 20:02:56 xxx audit[9838]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=9838 comm="mysqld" requested_mask="r" denied_mask="r"
Apr 12 20:02:56 xxx audit[9838]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/9838/status" pid=9838 comm="mysqld" requested_mask="r" denied_mask="r" fsuid=1
Apr 12 20:02:57 xxx kernel: audit: type=1400 audit(1492020176.998:533): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/9838/status" pid=9838 comm="mysqld" request
Apr 12 20:02:57 xxx kernel: audit: type=1400 audit(1492020176.998:534): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=9838 comm="mysqld"
Apr 12 20:02:57 xxx kernel: audit: type=1400 audit(1492020176.998:535): apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/proc/9838/status" pid=9838 comm="mysqld" request
Apr 12 20:02:57 xxx systemd[1]: mysql.service: Main process exited, code=exited, status=2/INVALIDARGUMENT
Now getting a lot of those
mysql is crap above fixed now getting those
ERROR 1808 (HY000): Schema mismatch (Table has ROW_TYPE_DYNAMIC row format, .ibd file has ROW_TYPE_COMPACT row format.)
i tried to swith that into compact at first run, the error was the same but switched like wtf
before
ERROR 1808 (HY000): Schema mismatch (Table has ROW_TYPE_COMPACT row format, .ibd file has ROW_TYPE_DYNAMIC row format.)
now
ERROR 1808 (HY000): Schema mismatch (Table has ROW_TYPE_DYNAMIC row format, .ibd file has ROW_TYPE_COMPACT row format.)
I never thought I'd suggest BTrieve, but you should look into that.