I have a MariaDB query that I am using in my Laravel application and I would like it to return 7 columns. When I dump the resultant array with PHP it seems to only be returning 4. However when I…
I'm trying to get the phpMyAdmin front page to show the "Server Charset" as "UTF-8 Unicode (utf8)". Currently, it is displaying as "cp1252 West European (latin1)". Is there a config.inc.php setting that I need to change to do this? I…
We are on magento 2.3 version. After code change when we run setup:upgrade, our mysql server gets stuck. We noticed there are a lot of alter queries running on db during this. As our table size is large, the DB…
I accidentally removed the DBA privileges of my only user from mariadb and now I can't use my bank and I was also unable to restore the privileges using the Linux SHELL CentOS 7. Command I tried: GRANT ALL PRIVILEGES…
MySQL (mariadb Ver 15.1 Distrib 10.1.44-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2) gave me this error: ERROR 1005 (HY000) at line 129: Can't create table `Houdini`.`stamp` (errno: 150 "Foreign key constraint is incorrectly formed") when trying to create this table:…
I have a working MySQL (MariaDB) Server running on my raspberry pi. It works fine when I want to connect to it from my local network. My specs are as followed: MariaDB [mysql]> SHOW VARIABLES LIKE "%version%"; +-----------------------------------+------------------------------------------+ | Variable_name…
Where can I find mysql config file with all parameters ? I found some config files in /etc/mysql/ directory but there isnt any file with all parameters ! Actually I want my machine's mysql server to be remotely accessed. So…
I had to redo my server (Debian 9) in Proxmox. I updated a package (libc6) and I broke the dependencies (I didn't snapshot it...). One of the affected daemons was MySQL / MariaDB, I could not make a backup from…
I have a table as follows: CREATE TABLE `table` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `cc` int(3) unsigned NOT NULL, `number` int(10) NOT NULL, `name` varchar(64) NOT NULL, `datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB…
This query lists out the distinct order numbers in Woocommerce that have order either of two products, where the orders are in a status called 'wc-on-hold'. The query does work, but if I comment back in the AND COUNT(t1.ID)=2 it…