Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [mariadb]

MariaDB is a drop-in replacement for Oracle(R) MySQL(TM).

MariaDB is based on MySQL and is available under the terms of the GPL v2 license.

It's developed by the MariaDB community with Monty Program Ab as its main steward.

MariaDB is kept up to date with the latest release from the same branch.

In most respects will work exactly as MySQL: all commands, interfaces, libraries and APIs that exist in MySQL also exist in MariaDB. There is no need to convert databases to switch to MariaDB. MariaDB is a true drop in replacement of MySQL! Additionally, MariaDB has a lot of nice new features that you can take advantage of.

See the MariaDB FAQ for more information.

See also:

867 questions
9
votes
4 answers

MariaDB refuses remote connections

I've gone through a lot of tutorials and questions and I still can't get it to work. I've been to: MariaDB official docs for remote access MySQL: Allow both remote AND local connections Mysql through ssh often can't connect or timeout I installed…
CoderGuy123
  • 321
9
votes
6 answers

Can't Install MariaDB - Dependency Error?

I'm running Ubuntu 14.04 on a Digital Ocean VM. I'm trying to install MariaDB 10.1. When doing so, I get the following error: Setting up mariadb-server-10.1 (10.1.8+maria-1~trusty) ... dpkg: error processing package mariadb-server-10.1…
Zach Russell
  • 277
7
votes
2 answers

mariadb mad file take all space in hard drive

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (50G out of 110G) from log: [Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting for someone to free space I execute the service…
Guillermo
  • 73
3
votes
1 answer

After mariaDB 10.0 to 10.1 upgrade, mysql can no longer write tmpdir

I ordered a new server that came with mariaDB 10.0 installed. I edited /etc/my.cnf to change the tmpdir to /home/mysql_tmp_dir (owned by mysql:mysql). All worked fine. Did upgrade to mariaDB 10.1.37 and the tmpdir can no longer be written…
vicos
  • 31
3
votes
1 answer

MariaDB: Host '127.0.0.1' not privileged

My Ghost instance want to conntect to my MariaDB, but the error is: Message: 'ER_HOST_NOT_PRIVILEGED: Host '127.0.0.1' is not allowed to connect to this MariaDB server' Here my my.cnf: [server] skip-name-resolve innodb_buffer_pool_size =…
gummipunkt
  • 31
3
votes
4 answers

mariaDB can't connect from remote host

MariaDB [(none)]> show variables like '%skip_networking%'; +-----------------+-------+ | Variable_name | Value | +-----------------+-------+ | skip_networking | OFF | +-----------------+-------+ 1 row in set (0.00 sec) When I try mysql -uroot…
Koda
  • 57
2
votes
1 answer

The target table user of the INSERT is not insertable-into MariaDB 10.4.11

I did a wonderful thing of deleting all root users from mysql by accident. That kind of a day. However before I panic I figured I would use this method here from searching online that didn't seem so bad. "Add 'skip-grant-tables' to my.cnf under…
gstlouis
  • 119
2
votes
0 answers

Maria DB slow query log not writing anything

For some reason, the Maria DB (version 10.1) slow query log is not writing anything. I've enabled slow query logging: select @@slow_query_log, @@slow_query_log_file, @@long_query_time, @@log_output; | 1 | /var/log/mysql/mariadb-slow.log | 3.000000…
rich remer
  • 489
1
vote
1 answer

Why two two users with same username and different hostnames are considered different accounts?

As I understand in mariadb two users with same username and different hostnames are considered two different accounts? create user employee@192.168.1.2; create user employee@192.168.1.3; Does it create two different accounts? And what is the…
anon
1
vote
2 answers

MariaDB: mysql_install_db problems

I just install MariaDB on a clean Debian 7 machine. When I want to run mysql_install_db, I get this set of errors: 150329 18:01:27 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150329 18:01:27 [Note] InnoDB: The InnoDB memory heap is…
WMRKameleon
  • 75
1
vote
2 answers

disk full because of tmpdir, safe to restart?

My disk is full, an .MAD file in tmpdir takes up all the space on the file system (179G out of 189G) from log: [Warning] mysqld: Disk is full writing '/var/tmp/#sql_b6f_0.MAD' (Errcode: 28). Waiting for someone to free space Can I stop mariadb, or…
FelixHJ
  • 135
1
vote
2 answers

List all users of a MariaDB

How can I list all users in my MariaDB? Teh Internet is full of SELECT user FROM mysql.user; in all its variations, but this does not work on MariaDB (I'm on version 10.5.19 if that matters), rather it produces the error (run with root…
H. Weirauch
  • 21
1
vote
1 answer

mariadb: ERROR 1286 ... Unknown storage engine 'ndbinfo' when turning on encrypt_binlog

mariabdb version: 10.4.12-MariaDB-1:10.4.12+maria~buster-log operating system: Debian 10 I'm trying to enable binlog encryption on a mariadb server, which is running as master in a replication configuration. Per the instructions at…
David
  • 111
0
votes
0 answers

mysqldump generating inconsistent dumps

I cannot get mysqldump to generate a dump that will properly restore. The dump is being generated to setup a new slave, but whenever the slave starts up, it gets foreign key constraint failures. I'm generating the dump with slave positions and as a…
Rich Remer
  • 205
  • 2
  • 8
0
votes
1 answer

Upgraded Mysql 5.6 to MariaBD 10.3 - error in log

I upgraded Mysql 5.6 to MariaDB 10.3 and now I have this line in error log, when I restart server: [ERROR] mysqld: Plugin 'innodb' already installed Server is running on Ubuntu 14.04 LTS. MariaDB is working, but I would like to get rid of this…
AtLeT
  • 1
1
2