Stack Overflow
Stack Overflow

Questions tagged [mariadb]

MariaDB is an open source database server that offers drop-in replacement functionality for MySQL.

MariaDB is an open source database server that offers drop-in replacement functionality for .

This MySQL fork has been made by its own original developers, triggered by doubts over the future management of MySQL after its acquisition by Oracle (through Sun Microsystems) in 2009. MariaDB is now released under the , and maintained by the community with the intent to maintain a high compatibility with MySQL APIs and commands.

Supported Storage Engines:

  • ARCHIVE
  • Aria
  • BLACKHOLE
  • Cassandra (added in 10.0)
  • CONNECT (added in 10.0)
  • CSV
  • FederatedX (drop-in replacement for Federated)
  • InnoDB
  • MEMORY
  • MERGE
  • Mroonga (added in 10.0)
  • MyISAM
  • OQGRAPH
  • S3 (added in 10.5.4)
  • SEQUENCE (added in 10.0)
  • SphinxSE
  • Spider (added in 10.0)
  • TokuDB (added in 5.5)
  • XtraDB (DEFAULT, drop-in replacement for InnoDB)

Legacy storage engines:

  • Federated (still provided, but FederatedX is recommended instead)
  • IBMDB2I (removed in 5.5)
  • PBXT (removed in 5.5)

Resources:

Related tags:

13893 questions
49
votes
7 answers

How to format uuid string from binary column in MySQL/MariaDB

In MySQL/MariaDB the most efficient way to store uuid is in a BINARY(16) column. However, sometimes you want to obtain it as a formatted uuid string. Given the following table structure, how would I obtain all uuids in a default formatted…
Lilleman
  • 7,392
  • 5
  • 27
  • 36
48
votes
0 answers

Galera 10 cluster node dropping queries

We are encountering an error on Node 1 of a 5-node cluster. Queries to Node 1 seem to succeed from a client perspective but are failing to insert. We are seeing a lot of autoinc errors even though autoinc shouldn't be involved in the update…
Derek Warner
  • 481
  • 3
  • 5
48
votes
7 answers

MySQL - SELECT * INTO OUTFILE LOCAL ?

MySQL is awesome! I am currently involved in a major server migration and previously, our small database used to be hosted on the same server as the client. So we used to do this : SELECT * INTO OUTFILE .... LOAD DATA INFILE .... Now, we moved the…
ThinkCode
  • 7,841
  • 21
  • 73
  • 92
47
votes
11 answers

mysql service fails to start/hangs up - timeout (Ubuntu, MariaDB)

I set up my first Ubuntu Server with Ubuntu 16.04, nginx, php7.0, MariaDB, nextcloud and external DynDNS using this tutorial here: Install Nextcloud 9 on Ubuntu 16.04 Everything worked fine but since I restarted the server the next day, nextcloud…
Lw Bi
  • 549
  • 1
  • 4
  • 8
43
votes
4 answers

How can I change MariaDB to MySQL in XAMPP?

A. First things first: Mr. Google hasn't helped me to found any reply to my question above Yes, I have read a solution to the opposite question here How to upgrade MySQL to MariaDB in XAMPP in 5 minutes on Windows (and it hasn't helped me: MySQL…
Mike
  • 595
  • 1
  • 5
  • 10
41
votes
5 answers

Mysql (MariaDB 10.0.29): Set root password, but still can login without asking password?

I want to secure mysql by setting root password. I reset root password successfully: MariaDB [(none)]> select Host, User, Password from mysql.user; +-----------+------+-------------------------------------------+ | Host | User | Password …
thanhpt
  • 531
  • 1
  • 5
  • 7
41
votes
7 answers

Update xampp from maria db 10.1 to 10.2

I am looking for solution on how to update mariadb on xampp 32 bit on window system but not found any article on that.I just found this link. Please help me how to update. I want JSON support that's why I am looking for update from V10.1 to V10.2.…
silentcoder
  • 992
  • 3
  • 9
  • 21
38
votes
7 answers

phpMyAdmin allow remote users

I need to modify the file /etc/httpd/conf.d/phpMyAdmin.conf in order to allow remote users (not only localhost) to login # phpMyAdmin - Web based MySQL browser written in php # # Allows only localhost by default # # But allowing phpMyAdmin to…
Germano Massullo
  • 2,572
  • 11
  • 40
  • 55
38
votes
2 answers

PDO and MariaDB

I've been using PDO in PHP for a while now utilizing MySQL. However, recent developments have made me think that MySQL will start fading out in replacement of MariaDB especially since MariaDB: Consider themselves many developer years ahead of…
HenchHacker
  • 1,616
  • 1
  • 10
  • 16
37
votes
3 answers

How to rename a column name in maria DB

I am new to SQL, I was trying to change column name in my database's table. I am using 'xampp' with 'maria DB' (OS - Ubuntu 18.04) I tried all of the followings: ALTER TABLE subject RENAME COLUMN course_number TO course_id; ALTER TABLE subject…
Kaveen Hyacinth
  • 495
  • 1
  • 4
  • 10
36
votes
4 answers

What is the MariaDB dialect class name for Hibernate?

In Hibenate I am using MariaDB but I couldn't find the dialect class name of MariaDB . In Hibernate, MySQL5 dialect's name is org.hibernate.dialect.MySQL5Dialect For Oracle 10g
Bijaya Bhaskar Swain
  • 893
  • 1
  • 11
  • 16
36
votes
9 answers

Database corruption with MariaDB : Table doesn't exist in engine

I'm in an environement setup, running OSX with MariaDB 10.0.12-MariaDB Homebrew I've screwed up the installation so I did completely removed MySQL and MariaDB from my setup and started again. After finishing installing MariaDB, I've reimported my…
sf_tristanb
  • 8,725
  • 17
  • 74
  • 118
32
votes
4 answers

Spring is losing connection to the DB and does not recover or reconnect

I have a spring-boot application on the same host as the Maria DB and both are running fine for some time. But between 12 hours and 2 days it seems that the spring boot application looses the connection to the database (stacktrace) and does not…
Vad1mo
  • 5,156
  • 6
  • 36
  • 65
32
votes
7 answers

mysql_config not found when installing mysqldb python interface for mariadb 10 Ubuntu 13.10

After I installed Mariadb 10 the Mysql workbench and JPDB client both connect and work fine so next step was get programming with Python (using SQLAlchemy) which seems to require MySQL-python so I went to update that and got: "mysql_config not…
dartdog
  • 10,432
  • 21
  • 72
  • 121
30
votes
8 answers

Installing MariaDB - Unmet dependencies, mariadb-server-5.5

I'm attempting to install MariaDB on Ubuntu 12.04 LTS. I've followed the instructions provided at https://askubuntu.com/questions/64772/how-to-install-mariadb and from MariaDB.org that appear when you choose the download. The last step is sudo…
Courtney Miles
  • 3,756
  • 3
  • 29
  • 47
1
2
3
…
99 100