Recently my web host decided to switch to MariaDB from MySQL. Since then, I get the following error whenever a page tries to connect to the database. "Versions of MySQL prior to 5.6 are not currently supported". I'm using ASP.NET…
hello i'm new in stack overflow, codeigniter 4 and dont have enough experience on mysql. I have a problem when i inserted data for the first time the data show on the table like it should be, but when i…
I'm new to MariaDB galera cluster load balancing and I'm trying to use HAProxy to do the load balancing. I have set up the MariaDB Galera cluster and it works perfectly. In Haproxy, I have created a VIP for the…
Hello dear Stackoverflow users, I'm working on a database to add to my project. But I'm having struggles figuring out properly making relations in MySQL using PHPmyadmin. I have written the following: CREATE TABLE Orders ( OrderID int(255) NOT NULL,…
I am developing an android studio project and would like to be able to access data from a database sitting on the pc which I am programming from. I would like to use a MySQL database as I have worked…
I would like to access mariadb in the db container from the app container with the following folder configuration, but it does not work with an error. directory structure . ├── app │ └── Dockerfile ├── db │ └── Dockerfile…
I get Access denied! when I'm trying to navigate to this URL http://localhost/phpmyadmin/ (using XAMPP). This happened today. It worked fine yesterday and I didn't change anything in the xampp folder since then. Below is my mysq.log file output. 2022-03-21…
I have one table. But in phpmyadmin; Something stuck in my head while creating the index. When you select and create more than one column, a single index is created for 3 columns. How is this different from creating indexes…
I have a problem. So I have a task that runs every time when a user writes a chat message on my discord server - it's called on_message. So my bot has many things to do in this event, and…
I have the following query, which currently takes about 0.3s to load, causing a heavy load on my Wordpress site. SELECT SQL_CALC_FOUND_ROWS wp11_posts.ID FROM wp11_posts WHERE 1=1 AND ( wp11_posts.ID NOT IN ( SELECT object_id FROM wp11_term_relationships WHERE term_taxonomy_id IN…