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
15
votes
3 answers

phpmyadmin : Depends: php-twig (>= 2.9) but 2.6.2-2 is to be installed. WHAT?

I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I install phpmyadmin : debian@XXX:~$ sudo apt-get install phpmyadmin Reading package…
Kanarpp
  • 149
  • 2
  • 2
  • 11
15
votes
3 answers

django.db.utils.OperationalError: (2002, "Can't connect to MySQL server on 'db' (115)")

This has already been asked, but none of the answers have helped me. This is my configuration. Im running docker-compose with two services, a web app in django and the database in mariadb. I can connect normally to my local db with this exact…
Joel David Hernández Cruz
  • 227
  • 1
  • 2
  • 9
15
votes
4 answers

How can I connect to mariadb using java?

I've used: Connection connection = DriverManager.getConnection( "jdbc:mysql://localhost:3306/test", "username", "password" ); Statement stmt = connection.createStatement(); stmt.executeUpdate("CREATE TABLE a (id int not null primary key, value…
ALEENA JOHN
  • 527
  • 1
  • 5
  • 15
15
votes
1 answer

MySQL – Simultaneous float increment and assignment in SELECT breaks prior to 5.6

Why do queries like SELECT (@sum:=(@var:=@sum)+some_table.val)... automatically cast (@var:=@sum) to integer in MySQL ≤5.5 for DECIMAL-type some_table.val and floor it for DOUBLE/FLOAT? What feature was changed to allow for the expected behaviour in…
concat
  • 3,107
  • 16
  • 30
15
votes
2 answers

MySQL Cluster or MariaDB Galera

I'm considering implementing a cluster server. I have currently used MySQL for my application for the past few years but I've read a lot of uncertainty over the past year on what is going to be happening with MySQL and also the advantages and…
Benjamin Oman
  • 1,654
  • 1
  • 17
  • 19
15
votes
1 answer

Using MariaDB in C

I'm trying to connect to a MariaDB database in a C script and I can't find the necessary documentation. I installed libmariadbclient-dev, but I couldn't find any accompanying documentation such as a man page. There's a basic description and limited…
Mike
  • 1,569
  • 2
  • 14
  • 20
14
votes
1 answer

Mysql Server 5 vs 6 vs MariaDB

Have a simple question here. I've a database with around 1 billion records, a server with 200GB of ram to handle it. What do you suggest for best performances? Mysql 5, Mysql 6 or MariaDB?
cedivad
  • 2,544
  • 6
  • 32
  • 41
14
votes
1 answer

AWS RDS - Access denied to admin user when using GRANT ALL PRIVILEGES ON the_db.* TO 'the_user'@'%'

When we try to GRANT ALL permissions to a user for a specific database, the admin (superuser) user of database receives the following error. Access denied for user 'admin'@'%' to database 'the_Db' After looking other questions in stackoverflow I…
Omar Alvarado
  • 1,304
  • 2
  • 12
  • 16
14
votes
2 answers

Why mysql explain analyze is not working?

Besides having mariadb 10.1.36-MariaDB I get following error. EXPLAIN ANALYZE select 1 MySQL said: Documentation 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to…
Hrushikesh Vartak
  • 143
  • 1
  • 4
14
votes
3 answers

Docker Alpine: Error loading MySQLdb module

I am building an Alpine based image of a Django application with MariaDB and I can't figure out which dependency I should add to my Dockerfile so that my app could properly connect to the DB. django.core.exceptions.ImproperlyConfigured: Error…
zar3bski
  • 2,773
  • 7
  • 25
  • 58
14
votes
3 answers

MariaDB - cannot login as root

I am trying to setup MariaDB (10.0.29) on Ubuntu (16.04.02). After I installed it and started the process (sudo service mysql start), I cannot login as root even though I originally set the password to blank. Ie mysql -u root will deny me access. I…
emihir0
  • 1,200
  • 3
  • 16
  • 39
14
votes
1 answer

Doctrine default value vs null insert

There is something that bothers me. I've tried to find one clear answer but no luck so far. I'm using Symfony3 and Doctrine2 and MariaDB. Let's assume that I've created something like this in my entity: /** * @ORM\Column( * name="status", * …
Robert
  • 1,206
  • 1
  • 17
  • 33
14
votes
4 answers

Mysql works with sudo, but without not. (ubuntu 16.04, mysql 5.7.12-0ubuntu1.1)

I have Ubuntu 16.04, and Mysql 5.7.12-0ubuntu1.1. When I type: sudo mysql -u root I can login into mysql console, but when I type it without sudo: mysql -u root I obtain error: ERROR 1698 (28000): Access denied for user 'root'@'localhost' My…
Daniel
  • 7,684
  • 7
  • 52
  • 76
14
votes
3 answers

InnoDB error on mariadb oficial docker image

I’m having a very strange error. I have been able to pin it down to a very simple case and I don’t know if I have found a bug or if I’m missing some point. The thing is I need a mariadb container and I can run it perfectly with the following…
Miquel Adell
  • 1,132
  • 3
  • 11
  • 24
14
votes
2 answers

Why the auto_increment id does not increase one by one, how to set it?

I have a MariaDB Galera Cluster(3 nodes), I set uid to increase automatically and be the primary key of the table as `uid | int(11) | NO | PRI | NULL | auto_increment`. MariaDB [hello_cluster]> select uid from table order by uid…
Haifeng Zhang
  • 30,077
  • 19
  • 81
  • 125
1 2 3
…
99 100