Questions tagged [mariadb-10.5]
100 questions
1
vote
2 answers
are mysql_* functions of PHP 5.6 compatible when we upgrade database from mysql 5.7.42 to mariadb 10.5?
My client wants to upgrade all his websites script from PHP 5.6 to PHP 8 and mysql 5.7.42 to mariadb 10.5. We want to upgrade one by one website. Now the problem is we can choose different PHP version for each domain and subdomain but for the…
Swati Patel
- 21
- 5
1
vote
1 answer
Order subquery results and return first row per ID
I have a MySQL DB with a person table, where I store the personal details of users. Each user belongs to a group, so I have another member_group table where I store their user ID against their group ID, along with their in_group_begin date and…
Eamonn
- 1,338
- 2
- 21
- 53
1
vote
1 answer
Cannot save emojis in utf8mb3 tables… Overnight, since MariaDB 10.6 update and switching to nd_mysqli
Before, using MariaDB 10.5 and mysqli, I had plenty of old WordPress website on utf8mb3 tables where I can successfully save a wide range of Emojis in the database.
Now since I switched to MariaDB 10.6 and nd_mysqli, if the database and tables are…
1
vote
0 answers
MariaDB not responding to PDO connections
I'm using MariaDB slave(Read only) for my web server and other services. Which works fine for few weeks and suddenly MariaDB stops responding to pdo requests. Web servers also start running at high CPU usage(100%) at the same time. MariaDB serving…
Jack
- 11
- 1
1
vote
1 answer
SQL issue with SELECT WHERE subquery in a CASE WHEN statement
I'm trying to classify my SKU's and I'm almost there. The desired outcome…
golabs
- 169
- 1
- 11
1
vote
1 answer
(mariadb) SQL error 1064 when creating table
I'm trying to create a discord bot with python and need a database Table for listing member warnings.
but when I'm trying to make a table in the database I get this error:
Traceback (most recent call last):
File…
Seyedmahdi moosavyan
- 79
- 6
1
vote
1 answer
mariadb 10.5 server: ERROR 1356 (HY000): View 'mysql.user' references invalid table(s)
I've a newly installed debian 11.1 with mariadb-server-10.5 (1:10.5.15-0+deb11u1) where I created a new user and dropped it:
#something like that:
create user 'testuser1'@'localhost' identified by 'pw';
use mysql;
delete from user where name =…
user2194805
- 1,201
- 1
- 17
- 35
1
vote
0 answers
How use results of stored procedure by another one - MariaDB
I need execute sql query by python script. I've created two MariaDB stored procedures. First AbonamentStart and MonthlyTransfer. Procedure AbonamentStart should return DATE variable. Second procedure MonthlyTransfer should return SUM of column…
Edyward
- 56
- 1
- 6
1
vote
2 answers
how long takes mariadb memory to stabilize?
5.13
We made tweaks on my.cnf according to mysql tuner, and tuning primer,
but i can't really figure out when the memory will be stabilize usage of mariadb.
Here mysql tuner result -
------- Performance Metrics…
Danco
- 11
- 3
1
vote
0 answers
MariaDB 10.5 changing sql_mode in .cnf does not change @@sql_mode, why?
Fedora Desktop 35 running MariaDB 10.5, completely fresh install from about a month ago.
Why is my change to /etc/my.cnf/mariadb-server.cnf sql_mode changing @@GLOBAL.sql_mode but not @@sql_mode?
I'm trying to remove STRICT_TRANS_TABLES from my…
Neek
- 7,181
- 3
- 37
- 47
1
vote
2 answers
Disable root login without password with MariaDB 10.5
I'm trying to disable root login without password with the new version of MariaDB.
Usually, I set the auth plugin for root to "". But it's not working anymore
ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or…
guillaumearnx
- 142
- 3
- 12
1
vote
1 answer
mariadb state wise where case clause inside view
I created below view in collaboration table
CREATE VIEW contents(
id,
title
)
AS
select
mytable.id as id,
mytable.title as title
from mytable
where mytable.owner = substring_index(user(), '@', 1);
Is there any way to detect current…
Helen
- 45
- 5
1
vote
1 answer
Couldn't login without sudo on MariaDB 10.5
For some unknown reason when I installed mariadb (currently ver 10.5 on my Manjaro linux). it wouldn't let me login without sudo. So i investigated (and i used that that authentication plugin unix_socket and mysql_native_password etc thing; to no…
Adeel Raza Azeemi
- 571
- 5
- 16
1
vote
1 answer
How to use ServiceStack to store POCOs to MariaDB having complex types (objects and structs) blobbed as JSON?
I've got following setup: C#, ServiceStack, MariaDB, POCOs with objects and structs, JSON.
The main question is: how to use ServiceStack to store POCOs to MariaDB having complex types (objects and structs) blobbed as JSON and still have working…
martin
- 125
- 1
- 7
1
vote
1 answer
MariaDB crashes when using large WHERE IN
I have an old project that I am trying to upgrade to a newer version of SQL. It is currently running MySql 5.5 and is working just fine. I have migrated som test data to MariaDB 10.5.9, but when I try running a query (which works fine on MySql 5.5),…
Sinnbeck
- 617
- 4
- 20
- 56