Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,699 questions
Score of -2
0 answers
31 views
Unable to connect to PostgreSQL database [closed]
Getting this issue: no pg_hba.conf entry for host [IP]
What does this mean and how can I fix it?
Score of 1
0 answers
537 views
Is mariadb-secure-installation still relevant?
I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...
Score of 0
1 answer
114 views
How can I connect a remote database server on SlickStack?
By default, SlickStack installs MySQL locally and connects WordPress to a localhost database. I want to skip that, and connect to a remote (managed) database server instead...
What is the proper way ...
Score of 0
1 answer
4093 views
Where can I download Oracle Database 12c?
I need to install Oracle Database 12c on my local machine, but I’m unable to find a working download link. The official Oracle website seems to have removed or restricted access to older versions.
I’...
Score of 0
0 answers
164 views
MariaDB is not using index
MariaDB 10.3
I am investigating a Wordpress / Woocommerce installation, which is quite slow. I threw the slow log into ChatGPT, which suggested adding indexes to the status column of the ...
Score of 0
1 answer
678 views
always needing innodb_force_recovery = 6
After many attempts I was able to restart a badly corrupted db by adding
innodb_force_recovery = 6
to my.ini
However now, I am unable to start the server at all unless that line is permanently in the ...
Score of 0
0 answers
319 views
SQL ODBC connection fails after activating wireguard tunnel
I have a problem with connecting to my DB while Wireguard VPN is activated. The problem appears both when the DB is on my machine (localhost) and when it's a machine on the same network (using the ...
Score of 0
0 answers
369 views
ERROR 2002 (HY000): Can't connect to local server through socket '/var/run/mysqld/mysqld.sock' (2). Using mariadb on Debian trixie
I'm aware this is a common issue, but none of the other posts helped me solve our issue (1, 2, 3, 4, 5, 6 ).
I installed mariadb using an ansible as part of an openstack installation, and it crashed ...
Score of 0
1 answer
101 views
AWS RDS - SQLSTATE[HY000] [1130] Host 'ec2-ip' is not allowed to connect to this MySQL server
My Laravel(hosted on EC2) app database(Mysql) is hosted in AWS RDS it was working fine but now it gives the error "SQLSTATE[HY000] [1130] Host '172...***' is not allowed to connect to this MySQL ...
Score of 0
0 answers
331 views
Unable to perform unattended installation of Oracle Database 19.3.0 on Windows 10
During an unattended installation of Oracle Database 19.3.0 on Windows 10, the following error occurs:
"SEVERE: PRCZ-1082 : Failed to add Windows user or Windows group "REG-XSPY-NUM12$" ...
Score of 1
0 answers
258 views
High CPU Usage by php-cgi in WordPress Admin Panel
I’m running a WordPress site on a server with AlmaLinux 9 and cPanel. The site itself is fast, but the admin panel is very slow.
When I check the server using htop, I see php-cgi processes consuming ...
Score of 0
0 answers
167 views
Should I stop using text files as data storage in production?
My question is about system design (and not solving a technical hurdle), but it's nonetheless quite specific.
I currently have an application storing big chunks of data in text files. The context of ...
Score of 1
1 answer
149 views
Database appears as garbled characters in phpMyAdmin
I have a website in Arabic, and the website was displaying unreadable characters like رسائل. I managed to fix the issue by changing the settings in MariaDB 10.6.19.
character_set_client ...
Score of 1
1 answer
876 views
MariaDB won't free disk space after drop database
I have Test MariaDb 10.6 database installed in our DEV server.
I set a test analytics database on it, just to TEST how an application's built-in monitoring would work (and it worked).
But, due to the ...
Score of 0
1 answer
176 views
ERROR INSTALLING ZABBIX PROXY 4.4
I am trying to install a zabbix proxy 4.4 using the installation manual:
commands used for installation:
#wget https://repo.zabbix.com/zabbix/4.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.4-1+...