Tags: mysql - PT EASYSTEM SMART TECH

30
JAN

PHP dan Mariadb Acces Denied Ga Mau Konek di Almalinux

Posted by easystem selinux almalinux mysql mariadb

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 ...

30 Januari 2025 Dibaca 306 kali

01
OKT

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

Posted by easystem mysql 8126 mariadb

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 ...

01 Oktober 2023 Dibaca 2694 kali

23
JUL

Tutorial Smarty - WSYIWYG Menggunakan TinyMCE

Posted by Admin tutorial xampp mysql php

...

23 Juli 2020 Dibaca 1155 kali

23
JUL

Tutorial PHP Smarty - WYSIWYG Menggunakan Ckeditor

Posted by Admin tutorial mysql xampp php

...

23 Juli 2020 Dibaca 853 kali

23
JUL

Tutorial Smarty PHP Template Engine - Import File Ke Dalam Database

Posted by Admin tutorial aplikasi mysql php

...

23 Juli 2020 Dibaca 711 kali

25
AGU

MySQL Bin Files Memakan Banyak Space Hardisk Server

Posted by Admin mysql ubuntu

Disable MySQL binlogging If you are not replicating, you can disable binlogging by changing your my.ini or my.cnf file. Open your my.ini or /etc/my.cnf (/etc/mysql/my.cnf), enter:# vi /etc/my.cnfFind a line that reads “log_bin” and remove or comment it as follows: #log_bin = /var/log/mysql/mysql-bin.log You also need to remove or comment following lines: #expire_logs_days = 10 #max_binlog_size = 100M Close and save the fi ...

25 Agustus 2019 Dibaca 1200 kali

19
AGU

Tutorial Smarty PHP Template Engine - Hapus Data

Posted by Admin mysql xampp komputer tutorial windows blog website aplikasi oop php phpmyadmin

...

19 Agustus 2019 Dibaca 874 kali

19
AGU

Tutorial Smarty PHP Template Engine - Edit Data

Posted by Admin komputer tutorial windows website aplikasi blog xampp oop php phpmyadmin mysql

...

19 Agustus 2019 Dibaca 932 kali