PHP dan Mariadb Acces Denied Ga Mau Konek di Almalinux

Pesan **SELinux AVC denial** ini menunjukkan bahwa **PHP-FPM** (dengan konteks `httpd_t`) diblokir oleh SELinux saat mencoba terhubung ke socket MySQL (`/var/lib/mysql/mysql.sock`). Ini terjadi karena konteks keamanan SELinux tidak mengizinkan proses PHP-FPM untuk mengakses socket MySQL. Berikut adalah langkah-langkah untuk memperbaiki masalah ini: --- ### 1. **Periksa Konteks SELinux**Periksa konteks SELinux untuk socket MySQL:```bashls -Z /var/lib/mysql/mysql.sock```Contoh output:```srwxrwxrwx ...

View More
  Dibaca 182 kali

Apa yang harus dijawab dalam perintah mysql_secure_installation yang Benar

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MariaDB to secure it, we'll need the current password for the root user. If you've just installed MariaDB, and haven't set the root password yet, you should just press enter here. Enter current password for root (enter for none): OK, successfully used password, moving on... Setting the root password or using the unix_socket ensures that ...

View More
  Dibaca 1639 kali

mariadb ketika import error gini Row size too large (> 8126) solusinya ?

Solusi Ke 1 : The error message Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. means that the row size of a table in MySQL is larger than the maximum row size of 8126 bytes. This can happen if the table has a lot of columns, or if the columns are of a data type that takes up a lot of space, such as VARCHAR or TEXT. To fix this error, you can try the following: Change some columns to TEXT or BLOB.&nb ...

View More
  Dibaca 2501 kali