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
696
votes
11 answers

MySQL: Grant **all** privileges on database

I've created database, for example 'mydb'. CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'myuser'@'%' IDENTIFIED BY PASSWORD '*HASH'; GRANT ALL ON mydb.* TO 'myuser'@'%'; GRANT ALL ON mydb TO 'myuser'@'%'; GRANT CREATE ON…
marioosh
  • 27,328
  • 49
  • 143
  • 192
276
votes
29 answers

ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

I have created tables in MySQL Workbench as shown below : ORDRE table: CREATE TABLE Ordre ( OrdreID INT NOT NULL, OrdreDato DATE DEFAULT NULL, KundeID INT DEFAULT NULL, CONSTRAINT Ordre_pk PRIMARY KEY (OrdreID), CONSTRAINT Ordre_fk…
user3289677
  • 2,761
  • 2
  • 12
  • 3
221
votes
13 answers

Which is faster: multiple single INSERTs or one multiple-row INSERT?

I am trying to optimize one part of my code that inserts data into MySQL. Should I chain INSERTs to make one huge multiple-row INSERT or are multiple separate INSERTs faster?
dusoft
  • 11,289
  • 5
  • 38
  • 44
173
votes
9 answers

Access denied for user 'root'@'localhost' (using password: YES) after new installation on Ubuntu

Today I did a login as root into Ubuntu 14.04.1 LTS ll and then apt-get install mariadb-server (without sudo but as root). With mySQL -h localhost -u root --password= I got Access denied for user 'root'@'localhost' (using password: YES) With…
SQL-Neuling
  • 1,751
  • 2
  • 11
  • 5
152
votes
8 answers

Cast int to varchar

I have below query and need to cast id to varchar Schema create table t9 (id int, name varchar (55)); insert into t9( id, name)values(2, 'bob'); What I tried select CAST(id as VARCHAR(50)) as col1 from t9; select CONVERT(VARCHAR(50),id) as colI1…
Mario
  • 2,303
  • 5
  • 20
  • 21
110
votes
5 answers

Trouble with UTF-8 characters; what I see is not what I stored

I tried to use UTF-8 and ran into trouble. I have tried so many things; here are the results I have gotten: ???? instead of Asian characters. Even for European text, I got Se?or for Señor. Strange gibberish (Mojibake?) such as Señor or…
Rick James
  • 135,179
  • 13
  • 127
  • 222
97
votes
13 answers

What's the default password of mariadb on fedora?

I installed mysql through yum just now and the OS fedora installed mariadb for me. I know mariadb is a new branch of mysql, but I can't understand why it does not ask me for setting the password. I have tried for 123456 and so on, but I failed. My…
Tony
  • 1,209
  • 1
  • 8
  • 11
94
votes
6 answers

#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria

Created a new database but can't create new user account due to this error. Does anyone know how to fix this? I can't find any solution to fix this. 1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria
neph
  • 943
  • 1
  • 6
  • 7
91
votes
12 answers

How to turn on/off MySQL strict mode in localhost (xampp)?

I want to know how to check whether MySQL strict mode is on or off in localhost(xampp). If on then for what modes and how to off. If off then how to on. I already followed http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-full and…
Ipsita Rout
  • 4,945
  • 4
  • 36
  • 40
68
votes
29 answers

How to fix error on Foreign key constraint incorrectly formed in migrating a table in Laravel

When migrating my DB, this error appears. Below is my code followed by the error that I am getting when trying to run the migration. Code public function up() { Schema::create('meals', function (Blueprint $table) { …
Muhammad Tareq
  • 1,238
  • 1
  • 9
  • 10
61
votes
3 answers

Completely remove MariaDB or MySQL from CentOS 7 or RHEL 7

I installed MariaDB on CentOS 7 but I had some problems with some configuration, now it is completely misconfigured. Thus, I wanted to remove the MariaDB with “yum remove mariadb mariadb-server”, after that I reinstalled it with “yum install…
Stack Over
  • 751
  • 2
  • 6
  • 7
59
votes
7 answers

Invalid syntax error "type= MyISAM" in DDL generated by Hibernate

I am getting this error for my Java code Caused by :`com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException`: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB` server version for the right syntax to use…
yogesh meghnani
  • 729
  • 2
  • 6
  • 11
56
votes
4 answers

Difference between utf8mb4_unicode_ci and utf8mb4_unicode_520_ci collations in MariaDB/MySQL?

I logged into MariaDB/MySQL and entered: SHOW COLLATION; I see utf8mb4_unicode_ci and utf8mb4_unicode_520_ci among the available collations. What is the difference between these two collations and which should we be using?
Flux
  • 9,805
  • 5
  • 46
  • 92
51
votes
7 answers

Using python to write mysql query to csv, need to show field names

I have the following: import MySQLdb as dbapi import sys import csv dbServer='localhost' dbPass='supersecretpassword' dbSchema='dbTest' dbUser='root' dbQuery='SELECT * FROM…
Mathnode
  • 965
  • 1
  • 9
  • 15
50
votes
16 answers

SQLSTATE[HY000]: General error: 1835 Malformed communication packet on LARAVEL

Suddenly got SQLSTATE[HY000]: General error: 1835 Malformed communication packet (SQL: select * from tb_users where (username = 121211) limit 1) on Laravel. I already checked this: MySQL: ERROR 2027 (HY000): Malformed packet, but it seems a…
wbhuana
  • 845
  • 1
  • 7
  • 8
1
2 3
…
99 100