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 817 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 3431 kali

18
OKT

How can I disable MySQL Strict Mode?

Posted by easystem sql query mysql

This is enabled by default, but you can disable it in one of a couple ways. First, verify which mode(s) MYSQL is running with: $ mysql -u root -p -e "SHOW VARIABLES LIKE 'sql_mode';" You'll need to replace root with whatever username has superuser permissions on your server (but, it's usually just root). You'll also be prompted for the password. This will print out something like this (but much prettier): sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_D ...

18 Oktober 2018 Dibaca 2558 kali

07
JUN

MySQL alter table add column with primary key

Posted by easystem mysql

ALTER TABLE t_dataDROP PRIMARY KEY,ADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id); if not a primary key ALTER TABLE t_dataADD COLUMN id INT NOT NULL AUTO_INCREMENT FIRST,ADD PRIMARY KEY (id); ...

07 Juni 2018 Dibaca 1447 kali

15
MAR

Reset the MySQL OR MariaDB Root Password

Posted by easystem mysql cmd sql query

To change the MySQL/MariaDB root password, follow these steps: Ensure that the MySQL/MariaDB server is running. Open a new Linux terminal. Use the mysqladmin command-line utility to alter the MySQL/MariaDB password, using the following syntax: mysqladmin --user=root password "newpassword"OR ALTER USER root@localhost IDENTIFIED VIA mysql_native_password USING PASSWORD("verysecret") ...

15 Maret 2018 Dibaca 2079 kali

15
MAR

MySQL: ERROR 1040: Too many connections

Posted by easystem mysql cmd sql query root

This basically tells that MySQL handles the maximum number of connections simultaneously and by default it handles 100 connections simultaneously. These following reasons cause MySQL to run out connections. Slow Queries Data Storage Techniques Bad MySQL configuration I was able to overcome this issues by doing the followings. Open MySQL command line tool and type, show variables like "max_connections"; This will return you something like this. +-----------------+----- ...

15 Maret 2018 Dibaca 1985 kali

20
FEB

How To Backup Databse mysql In terminal Ubuntu Work 100%

Posted by easystem ubuntu mysql

1. Access the MySQL shell mysql -u root -pmysql > showdatabases;CTRL +C2. super user sudo sumysqldump -u root -p namedatabase > namedatabase.sql OR mysqldump -u root -p namedatabase > /mnt/namedatabase.sqlenter password and enter ...

20 Februari 2018 Dibaca 1398 kali

05
AGU

Tutorial Membuat VIEW di Mysql

Posted by easystem mysql tutorial

...

05 Agustus 2017 Dibaca 1535 kali