I am trying to setup sequelize as ORM for my MariaDB. Here is my setup: var sequelize = require('sequelize'); var db= new sequelize('dbname', 'user', 'pass', { dialect: 'mariadb' }); When I r...

This has already been asked, but none of the answers have helped me. This is my configuration. Im running docker-compose with two services, a web app in django and the database in mariadb. I can co...

We encounter an error when we go from 2.7.2 to 3.0.4 MariaDB JDBC driver with setFetchSize(Integer.MIN_VALUE) java.sql.SQLSyntaxErrorException: (conn=27489500) invalid fetch size So we switch to ...

When I try to connect to a server using MariaDB 11's mariadb/mysql cli commands, I get the error "ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it" w...

I have a simple table CREATE TABLE test ( col INT, data TEXT, KEY (col) ); and a simple transaction START TRANSACTION; SELECT * FROM test WHERE col = 4 FOR UPDATE; -- If no results, genera...

I'm trying to set up a DB for user registration and in want to have a column with the registration date in it, which should be the current time by default. I tried running this query: CREATE TABLE...

I am building an Alpine based image of a Django application with MariaDB and I can't figure out which dependency I should add to my Dockerfile so that my app could properly connect to the DB. dja...

A recent Docker update seems to have caused (just some) InnoDB tables in a MariaDB to not be accessible. I get: #1932 - Table 'dbname.SomeTableName' doesn't exist in engine when trying to access ...

in phpMyAdmin I can see all databases and tables. But when clicking on any table I get the error Error #1932 - Table 'mytablename' doesn't exist in engine I tried a lot of solution advises found on...

I am trying to deploy a mariadb image on openshift origin. I am using mariadb:10.2.12 in my docker file. It works ok on local but I get following error when I try to deploy on openshift origin. ...

I have a problem with a new MariaDB 10.5.8 install. STRICT_TRANS_TABLES is set, and when I try to use $sql of: 'INSERT INTO test (flag) VALUES (?)' (where flag is defined as tinyint(1)) with var_d...

As part of our introduction to computer security course, we have a short unit on SQL injections. One of the homework assignments is a basic unsanitized login page. The expected solution is somethin...

I'm trying to make a MySQL database on my Raspberry Pi 4, but it isn't going very well, using localhost instead works perfectly but I want to remote control it from my Windows 10 computer on ...

I tried to install phpMyAdmin on Ubuntu 16.04LTS, for MariaDB and Apache. The problem is that during the setup process, it asks me about 'root' name, but not for root's password, and I end up with ...

I've just installed mariadb on Ubuntu mysql Ver 15.1 Distrib 10.0.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 I can connect to the DB using PHP through a local webserver and ca...

As far as I know, DDEV provides configuration options for phpMyAdmin to comfortably work with containered MySQL/MariaDB databases. But I would rather like to use a different tool like e.g. phpStorm...

I have tried query but there is an error. Does anybody solved the error? MariaDB [mysql]> UPDATE user SET Host='%' WHERE User='root'; ERROR 1356 (HY000): View 'mysql.user' references invalid t...

What is the reason that the following two queries give wildly different results? MariaDB [mydatabase]> SELECT COUNT(DISTINCT(`price`)) FROM `products`; --Good +--------------------------+ | COU...

How can i mysqldump from running container on https://hub.docker.com/_/mariadb/ ? I cant find any useful documentation or data? Any method for backup and restore database. This is my my contina...

I'm currently testing Maxscale with a Galera Cluster of 3 nodes in Read/Write Split mode. By default, Maxscale defines one node as a master and the other as slaves (my configuration says 100% of th...

I've just stumbled on a very weird behaviour: Imagine we have a table customers: MariaDB [connections]> describe customers; +--------------+-------------+------+-----+---------+---------------...

If you try to connect with PHP PDO to the newest Version of mariadb (11.3.2) you will see this error and the client will be unable to connect: SQLSTATE[HY000] [2054] Server sent charset (0) unknown...

I have simple connectionstring to MySql (MariaDB 5.5.5-10.11.0) written in c#: MySqlConnection Database = new MySqlConnection("Server=127.0.0.1; Port=3306; Database=test; Uid=user; Pwd=MyPassw...

I have this column: names John, Mary Joseph Eleanor, Sophia, Dani And I want this output: names John Mary Joseph Eleanor Sophia Dani And it should include the SUBSTRING_INDEX function

I've always been able to dump my remote database using mariadb-dump from the CLI. Starting today, I suddenly got the following error mysqldump: Couldn't execute 'select column_name, extra, g...