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:

776 questions
39
votes
3 answers

Increasing nproc for processes launched by systemd on CentOS 7

I have successfully increased the nofile and nproc value for the local users, but I couldn't find a proper solution for the processes launched by systemd. Adding max_open_files to the MariaDB configuration doesn't help. su - mysql to change the…
amq
  • 703
  • 2
  • 6
  • 9
38
votes
6 answers

No mysqld or mysql.server after mariadb-server install

So... likely I'm an idiot, but I'm stuck. I just set up a CentOS 7 on Digial Ocean and I can't seem to get the MariaDB/MySQL server running. Some output [root@hostname ~]# yum list installed |grep maria mariadb.x86_64 …
danneth
  • 995
  • 2
  • 8
  • 10
32
votes
1 answer

Is MariaDB a secure replacement for MySQL?

I've been using MariaDB, "an enhanced, drop-in replacement for MySQL" on my Debian stable servers for years, because of its increased performance. However I've noticed that it appears to lag with relation to security updates in MySQL; for instance,…
artfulrobot
  • 2,627
  • 11
  • 30
  • 56
30
votes
6 answers

MySQL (MariaDB) Not Starting

I am running Arch Linux 4.8.4-1 on a 64bit installation. I installed MariaDB via pacman. When I try to start it with systemctl start mysqld, it gives me Job for mariadb.service failed because the control process exited with error code. See…
Pranav Nutalapati
  • 419
  • 1
  • 5
  • 7
15
votes
4 answers

How to view mariadb log?

I am using new relic to monitor the performance of my server. Recently I noticed a very strange problem where for every 3 hours, the server will be down for 1 minute. And in the new relic report, during the server down time, there were sudden spike…
dev-jim
  • 283
  • 1
  • 2
  • 8
15
votes
1 answer

mariadb.service start stuck at activating

I just installed the mariadb in my ubuntu 19.10 by sudo apt install mariadb-server mariadb-client after when I am trying to start the server by sudo systemctl start mariadb.service shell get freeze I have to use Ctl+c to get shell running. In the…
Sarthak Kumar
  • 253
  • 2
  • 5
14
votes
8 answers

Where is systemd script for mysql.service located?

I am actually using MariaDB (drop-in replacement for MySQL). I'm trying to make some changes to my systemd mysql.service file. I can see it exists because running sudo systemctl lists it and indicates that it is loaded / active / running. The issue…
David Mackey
  • 677
  • 2
  • 13
  • 28
11
votes
3 answers

How to uninstall MariaDB and re-install MySQL? MySQL install turns into MariaDB install

I recently upgraded my CentOS system via the desktop. Mistake! I had MariaDB, phpMyAdmin working just fine before - but after the upgrade they stopped. I frantically googled and tried to follow some tutorials about MariaDB MySQL reinstall until I…
Suma
  • 111
  • 1
  • 1
  • 3
11
votes
1 answer

MariaDB vs Percona server - main differences?

I'm running Mysql in production today but are planning to switch to either MariaDB or Percona server when I move to new servers. The main reason for the switch is to distance us from Oracle, but also to get better performance and new features. It…
Chrille
  • 463
  • 2
  • 5
  • 10
11
votes
2 answers

Why does adding one character to my MySQL password lock me out?

I am able to log in via mysql -u myuser -p mydb -h localhost with this: grant all privileges on mydb.* to myuser@'%' identified by '1234567890123456789012345678901234567890123456789012345678901234567890123456789'; But not after I do this: grant…
Isaac
  • 221
  • 2
  • 6
10
votes
1 answer

Can I copy the entire /var/lib/mysql folder to a different server? (mysql vs mariadb, different versions)

I used to have a Linux system (LMDE) with MySQL. The system used innodb_file_per_table for most of the databases. (not sure about the version, whatever is the "latest" in LMDE) I am now on a new system (Manjaro/Arch) with MariaDB. $ mysql…
donquixote
  • 461
  • 1
  • 4
  • 14
10
votes
4 answers

Has anyone migrated production machines from MySQL to MariaDB?

I'm running MySQL for most of our DBs right now, and would like to get off the Oracle ship before it takes more of a turn. My understanding is that the transition from MySQL->MariaDB should be trivial, but going the other way is not so easy. Has…
Bryan Agee
  • 1,179
  • 2
  • 10
  • 27
9
votes
1 answer

Digital Ocean CentOS7 server, unable to --skip-grant-tables or restart mysql

I set up a Digital Ocean droplet (server) a few days ago and need to access mysql. No password for root is working amongst what I've tried. However this command: service mysql[d] stop Doesn't work. Apparently I am supposed to issue this…
Oliver Williams
  • 276
  • 3
  • 13
9
votes
2 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
  • 1
  • 3
  • 11
9
votes
5 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
  • 1
  • 3
  • 13
1
2 3
51 52