i need some help editing the correct file. I like to add "skip-name-resolve=1" to the my.cnf file. I am using centos7 and mariadb 10.5. I found a file in /etc/my.cnf. This is the content: [mysqld] bind-address = ::ffff:127.0.0.1 local-infile=0 datadir=/var/lib/mysql…
So I dropped all the users in mysql.user and restarted the mysql database. Now I can't seem to get into the mysql again or how to reset it as if it was a clean install. I tried uninstalling it with…
I want to update the sort_id for all my users. For example, since there are 10 users, I want to specify sort_id from 0-9 respectively. I can do it using foreach in PHP, but it causes a lot of performance…
I am trying to put a regexp constraint on a field "StaffAdress" such that it should only end with " street". This is my attempt, but it still doesn't seem to be valid. I tried regexp '.*street$' and regexp 'street$'…
So i'm trying to make a old project work again but when i put back my tables to the new database i'm having this issue ERROR 1005 (HY000) at line 777: Can't create table ****.#sql-3f2_45 (errno: 150 "Foreign key constraint…
I got a MariaDB database dump from a colleague, and he asked me to run it in a docker container. So i executed the following: docker pull mariadb:10.4.26 then created the container docker run --name test_smdb -e MYSQL_ROOT_PASSWORD=<some_password> -p 3306:3306…
I want to use BINARY UUIDs as my primary key in my tables, but using my own custom functions that generates optimised UUIDs loosely based on this article: https://mariadb.com/kb/en/guiduuid-performance/ The table structure and two main functions of interest here are:…
Hello i im trying to count the values within each range e.g. between 115000 - 120000 in my DURATION_IN_MS column. my column looks like this: 119631 120689 143498 119798 WITH tab1 AS( SELECT TOP 30 * FROM MACHINE_PROCESSING_DURATION_EVALUATION WHERE START_TIMESTAMP…
I have two tables: restaurant | id | name | | -------- | -------- | | | | food_item | restaurant_id | name | price | | -------- | -------- | ----- | | | | | | | |…
Struggling with a large dataset in my mariaDB database. I have two tables, where table A contains 57 million rows and table B contains around 500. Table B is a subset of ids related to a column in table A.…