Questions tagged [mariadb]
SQL database that can be used as a "drop-in" replacement for MySQL
122
questions
0
votes
0
answers
13
views
mysql - show all users/hosts with privileges to access a certain database [migrated]
Is there a way to list all users/hosts that have been granted access to a database? I know I can do this:
> show grants for someuser;
+---------------------------------------------------------------...
- 111
0
votes
0
answers
40
views
Install of MariaDB hangs. What to do to ensure it proceeds to completion?
My environment: UbuntuMATE 20.04 on Amd64 box
Linux hostname 5.4.0-176-generic #196-Ubuntu SMP Fri Mar 22 16:46:39 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux
Log of attempted install session:
root@...
- 312
0
votes
1
answer
178
views
Waiting for a MySQL or MariaDB server to become ready to perform updates
Is there an universal command/query to issue at the mysql client program to wait for the server to become ready for processing queries and updates, independent of whether the server is MySQL or ...
- 586
0
votes
0
answers
45
views
MariaDB - database folder changed?
I have MariaDB installed via Homebrew on MacOS.
I have local databases in /usr/local/var/mysql but a day or two ago, my local MariaDB now points to /opt/homebrew/var/mysql and does not find any of my ...
- 101
0
votes
1
answer
219
views
Why is MariaDB refusing to start?
MariaDB refused to start with this error:
Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 13 "Permission denied")
I think it may be a permissions error somewhere,. How ...
0
votes
0
answers
41
views
Can't bring back old mysql on mac
Initial problem is when I try to run mysql on terminal it outputs something like this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
I was triying to ...
1
vote
1
answer
42
views
Check Constraint in MariaDB 10.1.48 not working
i have following table:
CREATE TABLE t1 (
a INT,
b INT,
CONSTRAINT a_greater CHECK (a>b)
);
So, a must be larger than b.
When executing this insert, it should not work:
insert into ...
- 131
0
votes
0
answers
61
views
mariadb not allowing connection with only 1 cpu core at 95%
I am inquiring about ways to allow an import and have the database accessible at the same time.
I have tried to do a 60gb mysqldump import and it only uses 1 core so it takes hours. The storage is ...
- 14.2k
1
vote
0
answers
141
views
Are there no error logs for MySQL on Plesk server (Ubuntu)?
I have installed a Plesk server with version 18.0.57 on an Ubuntu 22.04.3 LTS. I am looking for the error logs for MySQL accesses or MariaDB accesses. But I can't find them via SSH.
Where could they ...
- 21
1
vote
1
answer
437
views
Running mariadb on alpine container
I'm attempting to run mariadb on an alpine:latest (asof 20231027; 20230901; 3.18.4) container. Forgive a n00b, but I've always run it on a host system that comes with it pre-installed.
I ran ...
- 13
0
votes
0
answers
232
views
Connect to a remote MariaDB server using VirtualMin
I have a web server but wish to locate a separate server for MariaDB. I'm following this tutorial but there's no "Module Config" under Webmin -> Servers -> MariaDB Database Server. ...
- 1
1
vote
0
answers
533
views
Connect to MariaDb datasource in Power Bi
I have successfully connected to my MariaDb/MySQL datasource in Power Bi Desktop using the Oracle MariaDB ODBC connector.
I use Import mode to be able to model the imported data in Power Bi. So far, ...
- 428
0
votes
1
answer
472
views
mariadb 10.1: Access denied for user, from ipv6 only
Adding an access record with host %, or with host smtp.acme.com does not provide access when accessing via IPv6. Nor does using the specific IPv6 address. I only get 'access denied'.
The SQL server is ...
- 221
1
vote
1
answer
609
views
How can I add 2 missing nodes to a galera cluster that has one node that is accepting reads and writes?
I am running a galera cluster with 3 nodes, having 3TB of data.
Last night due to a short power cut and a faulty UPS I completely lost 2 of the nodes and everything in /var/lib/mysql folder.
At this ...
2
votes
1
answer
1k
views
With DBeaver connecting to MariaDB, how to keep the session alive?
DBeaver uses MariaDB Connector/J, and the driver disconnects after completing the query.
We are trying to use a MariaDB feature that depends on the session, so we need to run the query and keep the ...
- 399