Comments - Mariadb start fail

Can't Create Test File contains mechanisms for changing ownership of the datadir.

If this is a RHEL/SLES or other selinuxed enabled distribution restore the SELinux file context with sudo restorecon -Rv /var/lib/mysql.

If neither of these work, include ls -laZ /var/lib/mysql.

Note #2

When I looked where my datadir was in "/etc/mysql/mysql.conf.d/mysqld.cnf", it showed me this path : "/data/mysql".

I've then checked the permissions there but I don't see any problem either. I send the "ls -laZ /data/mysql" to you in case that is important.

drwxr-xr-x 7 mysql mysql ? 4096 déc. 7 19:11 . Folder

drwxr-xr-x 5 root root ? 4096 nov. 29 13:50 .. Folder

-rw-r----- 1 mysql mysql ? 56 juin 23 2023 auto.cnf

-rw-r----- 1 mysql mysql ? 201 août 31 00:00 binlog.000072

-rw-r----- 1 mysql mysql ? 201 sept. 1 00:00 binlog.000073

-rw-r----- 1 mysql mysql ? 201 sept. 2 00:00 binlog.000074

-rw-r----- 1 mysql mysql ? 201 sept. 3 00:00 binlog.000075

-rw-r----- 1 mysql mysql ? 201 sept. 4 00:00 binlog.000076

-rw-r----- 1 mysql mysql ? 201 sept. 5 00:00 binlog.000077

-rw-r----- 1 mysql mysql ? 201 sept. 6 00:00 binlog.000078

-rw-r----- 1 mysql mysql ? 201 sept. 7 00:00 binlog.000079

-rw-r----- 1 mysql mysql ? 201 sept. 8 00:00 binlog.000080

-rw-r----- 1 mysql mysql ? 201 sept. 9 00:00 binlog.000081

-rw-r----- 1 mysql mysql ? 201 sept. 10 00:00 binlog.000082

-rw-r----- 1 mysql mysql ? 201 sept. 11 00:00 binlog.000083

-rw-r----- 1 mysql mysql ? 201 sept. 12 00:00 binlog.000084

-rw-r----- 1 mysql mysql ? 201 sept. 13 00:00 binlog.000085

-rw-r----- 1 mysql mysql ? 201 sept. 14 00:00 binlog.000086

-rw-r----- 1 mysql mysql ? 201 sept. 15 00:00 binlog.000087

-rw-r----- 1 mysql mysql ? 201 sept. 16 00:00 binlog.000088

-rw-r----- 1 mysql mysql ? 201 sept. 17 00:00 binlog.000089

-rw-r----- 1 mysql mysql ? 201 sept. 18 00:00 binlog.000090

-rw-r----- 1 mysql mysql ? 201 sept. 19 00:00 binlog.000091

-rw-r----- 1 mysql mysql ? 201 sept. 20 00:00 binlog.000092

-rw-r----- 1 mysql mysql ? 201 sept. 21 00:00 binlog.000093

-rw-r----- 1 mysql mysql ? 201 sept. 22 00:00 binlog.000094

-rw-r----- 1 mysql mysql ? 201 sept. 23 00:00 binlog.000095

-rw-r----- 1 mysql mysql ? 201 sept. 24 00:00 binlog.000096

-rw-r----- 1 mysql mysql ? 201 sept. 25 00:00 binlog.000097

-rw-r----- 1 mysql mysql ? 201 sept. 26 00:00 binlog.000098

-rw-r----- 1 mysql mysql ? 201 sept. 27 00:00 binlog.000099

-rw-r----- 1 mysql mysql ? 180 sept. 27 16:56 binlog.000100

-rw-r----- 1 mysql mysql ? 180 sept. 27 16:58 binlog.000101

-rw-r----- 1 mysql mysql ? 404 sept. 27 16:58 binlog.000102

-rw-r----- 1 mysql mysql ? 201 sept. 28 00:00 binlog.000103

-rw-r----- 1 mysql mysql ? 201 sept. 29 00:00 binlog.000104

-rw-r----- 1 mysql mysql ? 201 sept. 30 00:00 binlog.000105

-rw-r----- 1 mysql mysql ? 180 sept. 30 14:46 binlog.000106

-rw-r----- 1 mysql mysql ? 560 sept. 30 00:00 binlog.index

-rw------- 1 mysql mysql ? 1705 juin 23 2023 ca-key.pem

-rw-r--r-- 1 mysql mysql ? 1112 juin 23 2023 ca.pem

-rw-r--r-- 1 mysql mysql ? 1112 juin 23 2023 client-cert.pem

-rw------- 1 mysql mysql ? 1705 juin 23 2023 client-key.pem

-rw-r--r-- 1 root root ? 0 juin 23 2023 debian-5.7.flag

-rw-r----- 1 mysql mysql ? 196608 sept. 30 00:00 '#ib_16384_0.dblwr'

-rw-r----- 1 mysql mysql ? 8585216 sept. 27 16:58 '#ib_16384_1.dblwr'

-rw-r----- 1 mysql mysql ? 4181 sept. 30 14:46 ib_buffer_pool

-rw-r----- 1 mysql mysql ? 12582912 sept. 30 14:46 ibdata1

drwxr-x--- 2 mysql mysql ? 4096 sept. 27 16:58 '#innodb_redo' Folder

drwxr-x--- 2 mysql mysql ? 4096 sept. 30 14:46 '#innodb_temp' Folder

drwxr-x--- 2 mysql mysql ? 4096 sept. 27 16:58 mysql Folder

-rw-r----- 1 mysql mysql ? 30408704 sept. 27 16:58 mysql.ibd

-rw-r----- 1 mysql mysql ? 6 sept. 27 16:58 mysql_upgrade_info

drwxr-x--- 2 mysql mysql ? 4096 juin 23 2023 performance_schema Folder

-rw------- 1 mysql mysql ? 1705 juin 23 2023 private_key.pem

-rw-r--r-- 1 mysql mysql ? 452 juin 23 2023 public_key.pem

-rw-r--r-- 1 mysql mysql ? 1112 juin 23 2023 server-cert.pem

-rw------- 1 mysql mysql ? 1705 juin 23 2023 server-key.pem

drwxr-x--- 2 mysql mysql ? 4096 juin 23 2023 sys Folder

-rw-r----- 1 mysql mysql ? 16777216 sept. 27 17:00 undo_001

-rw-r----- 1 mysql mysql ? 16777216 sept. 27 17:00 undo_002

Thank you !!

Note : /var/lib/mysql has "0755/drwxr-xr-x" as permissions and belongs to www-data:www-data and "/var/lib/mysql/mysql" has "0700/drwx------" as permissions and I tried to change it to 0755 but it didn't work with that either.

Hello,

Thank you very much for your quick help and answer, I appreciate it !

I've tried what you suggested me but it doesn't seem to work, unfortunately.

I include the "ls -laZ /var/lib/mysql" as you suggested me but I am not sure how to read it and understand it to resolve the problem. I guess this is related to a permission problem but I am not sure if this is the "mysql" folder that should have different permissions or otherwise.

Do you or does anyone have an idea of what I should do to resolve the issue based on this information ? Any help would be greatly appreciated.

drwxr-xr-x 6 www-data www-data ? 4096 déc. 7 15:55 .

drwxr-xr-x 52 www-data www-data ? 4096 janv. 4 16:57 ..

-rw-rw---- 1 www-data www-data ? 417792 déc. 7 17:05 aria_log.00000001

-rw-rw---- 1 www-data www-data ? 52 déc. 7 17:05 aria_log_control

-rw-rw---- 1 www-data www-data ? 9 déc. 7 15:55 ddl_recovery.log

-rw-r--r-- 1 www-data www-data ? 0 nov. 22 16:27 debian-11.1.flag

-rw-rw---- 1 www-data www-data ? 17333 déc. 7 15:55 ib_buffer_pool

-rw-rw---- 1 www-data www-data ? 12582912 déc. 7 15:55 ibdata1

-rw-rw---- 1 www-data www-data ? 100663296 déc. 7 15:55 ib_logfile0

-rw-rw---- 1 www-data www-data ? 12582912 déc. 7 15:55 ibtmp1

drwx------ 2 www-data www-data ? 4096 nov. 23 17:39 krysknhs_* Folder

-rw-r--r-- 1 www-data www-data ? 14 sept. 30 14:46 mariadb_upgrade_info

-rw-rw---- 1 www-data www-data ? 0 sept. 30 14:46 multi-master.info

drwx------ 2 www-data www-data ? 4096 sept. 30 14:46 mysql Folder

drwx------ 2 www-data www-data ? 4096 sept. 30 14:46 performance_schema Folder

drwx------ 2 www-data www-data ? 12288 sept. 30 14:46 sys Folder

-rw-rw---- 1 www-data www-data ? 10485760 déc. 7 15:55 undo001

-rw-rw---- 1 www-data www-data ? 10485760 déc. 7 15:55 undo002

-rw-rw---- 1 www-data www-data ? 10485760 déc. 7 15:55 undo003

Thank you in advance for your help and have a beautiful day.

Kind Regards, ml25