Stack Overflow
Stack Overflow

Questions tagged [mariadb-10.4]

MariaDB 10.4 is an open source database server that offers drop-in replacement functionality for MySQL. Use this tag only when using MariaDB version 10.4.*

MariaDB 10.4 version was released in June 2019. It implements notable features such as instant DROP COLUMN and ordering change in InnoDB tables; Account Locking; User Password Expiry etc.

Complete list of changes and improvements can be seen here: https://mariadb.com/kb/en/library/changes-improvements-in-mariadb-104/

156 questions
2
votes
0 answers

ERROR 2013 (HY000): Lost connection to MySQL server at 'handshake: reading initial communication packet', system error: 11

I've setup 2 separate stacks with each one php + mariadb, via docker-compose. The first one has mariadb listening on 3306 port : ports: - "3306:3306" I use -p flag to build and up the second project so that things don't get mixed-up…
St3an
  • 726
  • 1
  • 6
  • 21
2
votes
1 answer

MariaDB - Data at rest encryption in 10.4.14 Windows 2019

I'm at a loss, and with an extremely tight timeline, I'm rapidly running out of options. Posting here is my last-ditch attempt to get this working. I am trying to get my test environment of MariaDB 10.4.14 completely encrypted for data at rest…
user2337160
  • 41
  • 1
  • 5
2
votes
1 answer

Homebrew MariaDB 10.4.13 not found - forced updated to 10.5.5 and now I cannot start my database

I am unable to find MariaDB version 10.4.13 using brew. After reinstalling by uninstalling and installing (critical mistake) Homebrew upgraded my version to 10.5.5 Now I am getting the following error: 020-08-14 20:33:07 0 [Note] InnoDB: Uses event…
Obi-Wan-Clemobi
  • 145
  • 1
  • 13
2
votes
2 answers

MariaDB root login problem. (can login but, not security)

I have some problem. Install MariaDB success. mysql_secure_installation setting complete. but I login mysql -u root -p Insert Any password can login on linux root user. (not root user has to enter the correct password) This problem does not occur…
MiraiTech
  • 43
  • 4
2
votes
3 answers

How to combine two SQL queries in MySQL with different columns without combining their resulting rows

Context I'm trying to create a "feed" system on my website where users can go to their feed and see all their new notifications across the different things they can do on the website. For example, in the "feed" section, users are able to see if the…
Carson D
  • 81
  • 13
2
votes
0 answers

How can I resolve this error 1241 error that the stored procedure throwing?

In python 3.x, I have a class with this definition def sproc(self, sql, *args): self.__open() self.__session.callproc(sql, args) number_rows = self.__session.rowcount number_columns =…
red8rain
  • 40
  • 5
2
votes
2 answers

Reverse Mysql Query

I have two databases that look like this: | idElement | idClient | idSubClient | idSport | idCategory | idTeam | idParent | |-----------|----------|-------------|---------|------------|--------|----------| | 1 | 1 | -1 | …
cplaiuu
  • 163
  • 4
  • 18
2
votes
1 answer

Hibernate Cannot Instantiate ID Generator

Environment: Spring Boot 2.2.6 Starters: spring-boot-starter-data-jpa, *-thymeleaf, *-web, *-tomcat, *-test Other dependencies: mariadb-java-client 2.6.0, spring-boot-devtools (MANAGED), lombok (MANAGED) DB MariaDB: 10.4 Hibernate Dialect:…
jmarkmurphy
  • 11,030
  • 31
  • 59
2
votes
1 answer

wsl 2 ubuntu mariadb .my.cnf.42' is ignored

So have wsl 2 setup on windows 10, installed ubuntu, imstalled apache. Windows 10 Version 2004(OS Built 19041.21) / Ubuntu 18.04 Now at the next stage and trying to install mariadb. Have installed it following the instructions…
John Smith
  • 1,812
  • 1
  • 16
  • 17
2
votes
0 answers

MariaDB won't start with CIFS share as datadir

I have a rather peculiar problem with MariaDB on Ubuntu Server 18.04 when using a CIFS share as its datadir. The setup is a fileserver hosted at 192.168.4.10 and my MariaDB database server at 192.168.4.8. I now want to store the "hot data" of the…
E. H
  • 53
  • 4
2
votes
2 answers

Upgrade to MariaDB 10 from MariaDB 5.5 via yum fails

I want to upgrade mariadb from 5.5... to 10. But when I run "yum update -y", screen show like below: Upgrading directly from MySQL …
Nam Nguyen
  • 2,438
  • 21
  • 18
1
vote
1 answer

Mysql/mariadb stored procedure set one variable value from selected row through join operation

I have one MySql stored procedure i.e. selecting one row using left join. How can I set one value into OUT parameter from result set. Database table which one I am using as: INSERT INTO `user_pool` (`id`, `pool_id`, `user_id`, `parent_id`,…
priti narang
  • 258
  • 4
  • 18
1
vote
1 answer

MariaDB: get the intersection of two queries results in two tables

So I have two tables, both have the same structure: tableA tableB ID ID 1 1 3 2 5 3 10 5 What I need is to compare tableA.ID and tableB.ID and find out which IDs are free in both table and get the intervals of those free IDs. To…
nopinopa
  • 25
  • 6
1
vote
3 answers

#1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Please use mysql_upgrade to fix this error

I got this message when I try to run query on XAMPP in macOS #1558 - Column count of mysql.proc is wrong. Expected 21, found 20. Created with MariaDB 100108, now running 100421. Please use mysql_upgrade to fix this error I tried to…
Dirga Adi Guna
  • 11
  • 1
  • 3
1
vote
1 answer

How to get non grouped data of last row by datetime with multiple joins?

There is tickets, they always contain some comments (at least one) and table to conect them. All PKs are numeric but randomized, so, timeline based on DATETIME field of ticket/comment table. I need to list of tickets (id, author) with all LAST…
trogwar
  • 216
  • 1
  • 11
  • 26
1
2
3
…
10 11