Ask Ubuntu
Ask Ubuntu

Questions tagged [mariadb]

MariaDB is a community-developed branch of the MySQL relational database management system.

MariaDB is intended to be a free, mostly backwards compatible drop-in replacement for MySQL.

It is a fork of Oracle's MySQL database and its initial release was kept up to date with the MySQL release of the same version. With MariaDB release 10.0 the developers team deliberately broke with the versioning scheme to make transparent there are some incompatibilities from there on.

See the MariaDB FAQ for more information and MariaDB versus MySQL - Compatibility for information on incompatibilities.

MariaDB home page

254 questions
190
votes
3 answers

What is the difference between "systemctl start" and "systemctl enable"?

I installed MariaDB server to my machine. While setting up, I was met with the problem of whether I should have it enabled all the time, as the documentation I follow suggests with these steps: sudo yum install mariadb mariadb-server sudo systemctl…
Chathurika Senani
  • 2,029
43
votes
9 answers

How to install MariaDB?

What is the most stable/safest way to install MariaDB?
john
  • 533
28
votes
4 answers

Why does mariadb keep dying? How do I stop it?

I am running MariaDB 10.0.23-0 on Ubuntu 15.10 as a LAMP server. Running sudo /etc/init.d/mysql start results in: Job for mariadb.service failed because a timeout was exceeded. See "systemctl status mariadb.service" and "journalctl -xe" for…
T.J.L.
  • 707
27
votes
4 answers

how to check if a database is mysql or mariadb

I have some problems with a database. I think it might be mysql, my own database is probably mariadb. How can I check that?
Jos
  • 636
22
votes
2 answers

Remove MariaDB (MySQL) Databases

How do I completely remove MariaDB so I can reset the root password?
SteamPunk_Devil
  • 323
  • 1
  • 2
  • 4
19
votes
2 answers

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different way to do this than to export all data and then…
Andreas Hartmann
  • 2,783
16
votes
1 answer

Open port on ubuntu 16.04

I cannot access my db remotely, The only thing i found out is the port 3306 is open for 127.0.0.1, I want it open globally. The error i receives on accessing db is No connection could be made because the target machine actively refused it. I have…
Comrade
  • 215
14
votes
2 answers

Not prompted to input the root password when installing mariadb-server on Ubuntu 16.04 LTS

I just had a fresh install on my pc the Ubuntu 16.04 LTS. When I tried to install MariaDB by typing: sudo apt-get install mariadb-server The installation went smoothly but during the process I was not prompted to input the password for the mysql…
user6133116
  • 143
11
votes
3 answers

Mariadb not working just after install on Ubuntu 16.04

Hi I have installed MariaDB server and mariaDB client, php7.0-mysql on my fresh Ubuntu 16.04 VPS, but after installation I cant login using PhpMyAdmin, when I am trying to login using PHPMyAdmin its always give Access denied for user…
Mi2
  • 113
11
votes
4 answers

Installing MariaDB when Apt reports MariaDB has unmet dependencies or broken packages

I have tried everything to install MariaDB on this clean Ubuntu installation but I keep getting this error, Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the…
Andreas
  • 223
10
votes
5 answers

Installing Mysql Workbench on ubuntu 14.04

I have installed MariaDb as its supported by Ubuntu community , mentioned in release note of latest LTS. After that I tried to install Mariadb-client , that too installed successfully, after that its good to have GUI tool So decided to install…
Sukupa91
  • 3,067
8
votes
1 answer

Can't login to MySQL as root anymore?

It looks like I can not login to MySQL (actually MariaDB) as root user anymore in Ubuntu 15.04 (I upgraded from 14.04 via 14.10) I already tried to reset the password. What is working, is sudo mysql - but I want to login as root from an other user…
Alex
  • 1,062
8
votes
3 answers

How do I uninstall MariaDB on Ubuntu 14.04 (Trusty Tahr)?

I have installed MariaDB from source and now I need to uninstall it. I used these commands to install it: wget http://mirrors.hustunique.com/mariadb/mariadb-10.0.14/source/mariadb-10.0.14.tar.gz tar -zxvf mariadb-10.0.14.tar.gz cd…
Mojtaba Hosseinzadeh
  • 83
8
votes
2 answers

security concerns of executing mariadb-dump with password over ssh

I need to make backups of the remote machine mariadb database. My plan is to run ssh user@remoteip 'mariadb-dump -uuser -ppass --all-databases > backup.sql' from my local machine. I found that remote machines history is not being populated with the…
sanjihan
  • 257
7
votes
3 answers

MariaDB killed by OOM Killer every couple days

my MariaDB server is being killed every couple days. × mariadb.service - MariaDB 10.6.12 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Active: failed (Result: oom-kill) since Wed 2023-04-19…
Johnathan Nguyen
  • 71
1
2 3
…
16 17