Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Make your voice heard. Take the 2019 Developer Survey now

Questions tagged [mariadb]

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

0
votes
0answers
6 views

How to know query for MariaDB replication failed?

I have configured MariaDB master-slave replication using ubuntu 16.04, The problem is that I want to know what is the main reason to failed master-slave replication and query for that, Please suggest ...
0
votes
1answer
8 views

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Recently, i was trying to make a slave working by dumping via ssh the databases. I had discart percona-xtrabackup because i liked to select which databases i'de like to sync. For make the slave work,...
3
votes
1answer
26 views

Migration from MariaDB to MySQL

The question is simple: Which is the painless way to migrate from MariaDB to MySQL? I was thinking about make a complete dump of the databases and import it on the new DB, but having the possibility ...
0
votes
0answers
30 views

How to update MariaDB version in XAMPP on Ubuntu

I am running Ubuntu 18.04 LTS and I'm using XAMPP to run a local server on my computer. I want to upgrade MariaDB version from 10.1.3 to 10.3 in XAMPP in order to support new instructions (EXCEPT and ...
0
votes
0answers
48 views

MariaDB dependency Issues

I have looked through a ton of different answers for this and still cannot seem to fix this issue. I did a apt-get update and apt-get upgrade this morning and it seems to have broken my MariaDB ...
-1
votes
0answers
55 views

Facing issue with MySQL slowness while inserting data with Ubuntu 18.04 LTS [duplicate]

I have installed all the supported MySQL 5.7.X versions on Ubuntu 18.04 but facing issue while inserting data. Same MySQL versions 5.7.X are installed on Ubuntu 16, it is working fine. No ...
0
votes
0answers
239 views

DataGrip MySQL connection: user/password combination is rejected

In DataGrip, I have this error when I try to test the connection to my local MariaDB instance: The specified database user/password combination is rejected: [28000][1045] Access denied for ...
1
vote
2answers
161 views

No root user password for MariaDB

I've gone through the process of installing MariaDB several times now, and it has never asked me to create a root password. The upshot of this is I can't get in and create the database. Obviously I'...
0
votes
0answers
192 views

Remove Mariadb 10.3 and Mysql completely from Ubuntu

I have been trying to remove all the package. apt-get remove --purge mysql* apt-get remove --purge mysql apt-get remove --purge mariadb apt-get remove --purge mariadb* apt-get --purge remove mariadb-...
0
votes
1answer
442 views

MariaDB installation error: Unable to correct problems, you have held broken packages

I am trying to install MariaDB following the official site but I keep getting errors. First step: $ sudo apt-get install software-properties-common Reading package lists... Done Building dependency ...
0
votes
2answers
480 views

'Can't connect to local MySQL server through socket '/path/mysql/mysqld.sock' (2 “No such file or directory”)'

After I have changed the datadir of my MariaDB (Ubuntu 16.04), I cannot restart mysql anymore. I changed the path of the data directory in the /etc/my.cnf file. But if I try to start MariaDB with ...
1
vote
0answers
80 views

No config files for mysql / mariadb-server

I have a problem on one server running Ubuntu 18.04. I have no idea, but the server does not generate config files for the mariadb-server. The /etc/mysql directory does not exist after the ...
0
votes
0answers
72 views

MariaDB error on a fresh install of Ubuntu 16.04

Yesterday I installed Ubuntu 16.04 on a real machine, not a virtual one. And right away installed mariaDB from: apt install acl apache2 composer fping git graphviz imagemagick libapache2-mod-php7.0 ...
0
votes
2answers
752 views

Remove and reinstall mysql

I unfortunately messed up my mysql installation, when I thought I could just install mariadb next to it. Now I am not even able to remove and re-install it. As I have a lot of other things set up in ...
0
votes
1answer
946 views

Impossible to find socket of mysql ( MariaDb installed)

I have the following error, but when I try to find the socket file there is in fact nothing ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No ...
0
votes
0answers
14 views

Enable Mariadb, symlink to another script, skipped!

I diabled maraidb once on my computer (sudo systemctl disable mariadb). Now i want to enable it back. But i get en errormessage. $ sudo systemctl enable mariadb Synchronizing state of mariadb.service ...
0
votes
0answers
78 views

Why is the apt sources different between a minimal and desktop install?

I was banging my head not being able to install mariadb and python3-pip in a minimal install of Ubuntu 18.04. Every web search showed pages with the expected apt install package commands. When I ...
0
votes
0answers
25 views

Accidentally Removed mysql-server-core-5.7

I was Removing mysql to get a fresh start,I added mysql-server-core-5.7 to my apt remove stack and however i try,it doesn't install anything related to mysql! this is the output: apt install mysql-...
0
votes
0answers
193 views

How to upgrade mariadb 10.1 to 10.2 xampp-7.2 in ubuntu 16.04?

I am using Xampp Version 7.2.7 in Ubuntu 16.04. My current Mariadb version is 10.1.34-MariaDB. But I want to upgrade 10.1.34-MariaDB version to 10.3.8 Please can you help me how I upgrade mariadb ...
0
votes
0answers
37 views

Switching between MariaDB and MySQL

In the process of moving to Ubuntu 18.04, I've been installing MariaDB instead of MySQL. My machine at work is running RHEL 7 which has MariaDB, so I want to use the same code base at home. However, ...
3
votes
1answer
516 views

Why isn't MariaDB 10.2 in Ubuntu 18.04 LTS (Bionic)?

I'm just trying to understand the release process here, Ubuntu 18.04 had a Debian feature freeze on 2018-03-01. MariaDB 10.2 has a general release on 2017-03-23 That means the General Release for ...
0
votes
0answers
93 views

cannot change mariadb root password

trying to change mariadb root password. works find till restart the database to start. using this command sudo kill `/var/run/mariadb/mariadb.pid but the result says no such file or directory ...
0
votes
0answers
1k views

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

alhelal@VimLaTeX:~$ mysql -u root -p Enter password: ERROR 1698 (28000): Access denied for user 'root'@'localhost' alhelal@VimLaTeX:~$ sudo mysql -u root -p [sudo] password for alhelal: Enter ...
0
votes
2answers
1k views

How to forcefully remove MySQL and MariaDB with unmet dependencies, when apt-get and dpkg do not help?

I had installed mysql-server on my Ubuntu 16.04 LTS and it worked like a charm. Next I installed mariadb-server and mariadb-client. There ware some conflicts with MySQL so I decided to forcefully ...
0
votes
0answers
731 views

Errors trying to install mariadb on Ubuntu 18.04 (Bionic Beaver)

I run the following and get these error messages: sudo apt update sudo apt upgrade sudo apt install mariadb-server mariadb-client Configuration file '/etc/mysql/debian-start' ==> Deleted (by you ...
0
votes
1answer
620 views

Ubuntu upgrade 17.10 to 18.04 moved my MariaDB database to folder /var/lib/mysql-10.2 and downgraded MariaDB from 10.2 to 10.1

[This is more of a How-To-Post] Ubuntu upgrade process to 18.04 had a window asking me what I wanted to do with my MariaDB install -- install MariaDB in Debian, or keep my install (a working MariaDB ...
1
vote
0answers
399 views

Installing MariaDB Alongside MySQL

I want to install MariaDB alongside MySQL. Under Windows install it is very easy because it only needs to change the port. While under Ubuntu it's a different story. I did the following steps for ...
1
vote
1answer
87 views

lubuntu - mariadb ignores correct password

This is a problem I got today when upgrading my Lubuntu version to 18.04. After the update, the system deleted my MariaDB packages. When I tried to installing them again the installer said the will ...
1
vote
2answers
4k views

Install MariaDB on Bionic

For the life of me, I can not figure out why I am unable to install mariadb-server 10.2 on my new install of Ubuntu Mate 18.04. I've done this twice on two computers running 16.04 without incident. I'...
0
votes
2answers
203 views

After duplicating failing drive, mysql and mariadb refuse to run

I had a hard drive that was failing, and cloned the disk to keep my server running. I noticed mysql wouldn't run, and tried to purge mysql, tried to install mariadb, tried purging that and ...
0
votes
1answer
697 views

mysqldump “Access denied” error on ubuntu with mariadb (login informations are correct)

I use Ubuntu with a mariadb database. I want to make a mysqldump of my sql databases, but i get allways the following error: mysqldump: Got error: 1045; "Access denied for user 'db_user-backups'@'...
0
votes
1answer
118 views

7 Day Owncloud Install Ubuntu Server LTS . Mariadb uninstall/reinstall & pkg issues for Owncloud install

Ive been installing owncloud for a little over a week. My issue Trying to install Owncloud, but it gave me errors with mariadb. So i was attempting to uninstall/reinstall mariadb when i got all this. ...
0
votes
0answers
394 views

MariaDB Change bind-address but not affected

I have Ubuntu 16.04 with "Ver 15.1 Distrib 10.0.34-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" I want to open port 3306 for remote connections. I changed "bind-address = 127.0.0.1" to ...
2
votes
0answers
76 views

Mariadb-bin log grows 100 MB per hour

Since several days ago the MySQL log is growing at 100 MB per hour rate. I discovered it because my server run out of space and the database crushed. I deleted the logs and everything is OK now except ...
0
votes
0answers
48 views

Accidentally installed MySQL on a server which has MariaDB - How do I undo this?

I have a server that has MariaDB installed which hosts my Wordpress website. I accidentally did sudo apt-get install mysql-server thinking I was on another machine, and now my website isn't visible, ...
0
votes
1answer
365 views

MariaDB 10.0.33 Configuring MariaDB for Remote Client Access

I just keep verbatim the instructions in MariaDB docs but it does not work at all, and I wast a great ammount of time. MariaDB docs does not take into account this version in its documentation. ...
1
vote
1answer
2k views

unknown variable 'bind-address=ip'

I was trying to run some mysql command, but then when I run it, this happens mysql: unknown variable 'bind-address=[ip]' Stuff looks different in my.cnf: [mysqld] bind-address = [ip] port = 3306 ...
0
votes
0answers
47 views

How to remove LAMPP packages? [duplicate]

Used this question to install LAMPP: What's the easiest way to set up a LAMP stack? Several problems have cropped up and I want to start over. How can I remove everything? Tried the suggestions ...
1
vote
0answers
190 views

Do I have two or more different setups of MySQL/MariaDB?

I've had a kind of annoying problem quite a while now. I run a Ubuntu 16.04 LTS Server for my own company at my own home. I also run a mariadb-server on this server, but a big problem is that when I ...
1
vote
1answer
879 views

Mariadb-server is not installed but cannot install it.

I user Ubuntu 16.04 and I updated to mariadb. I installed the package the following way sudo apt-get install mariadb-server mariadb-client. Then I tried to use sudo systemctl start/stop mariadb but I ...
1
vote
2answers
811 views

Cannot update nor remove mariadb [duplicate]

I made a mistake. I had to update mariadb from 10.0 to 10.2 So did: $ sudo apt-get install mariadb-server Reading package lists... Done Building dependency tree Reading state information... ...
3
votes
2answers
11k views

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?
0
votes
1answer
887 views

I can't install or remove mariadb

Recently I've installed Ubuntu 17.04. I was trying to install mariadb, so I installed all the packages. I don't know what happened, but whenever I install anything, try to connect to the Internet with ...
0
votes
0answers
453 views

MySQL service failure after installing mariadb-server

I am installing Openstack on Ubuntu 16.04, after: Installing mariadb-server; Creating 99-openstack.cnf with [mysqld] section and saving it. I have executed service mysql restart as per ...
0
votes
1answer
245 views

apt-offline for either offline or online system (mariadb 10.2 install)

I have a case where a product update may be done on either an internet-connected or non-internet connected 14.0.4 system. As part of the product update, it needs to switch from mysql to mariadb, ...
0
votes
0answers
497 views

Problem while setting up default system tables Mysql/Mariadb (Instalation of system tables failed!)

Im fairly new to ubuntu and I currently need some help understanding this error. As of now, Im working on a server with which to host a WordPress sites using this tutorial: https://deliciousbrains....
0
votes
0answers
179 views

Problem in removing MySql from ubuntu

I want to completely remove mysql from ubuntu and decided to follow some steps found in link : I executed the following commands in order: sudo -i service mysql stop killall -KILL mysql mysqld_safe ...
0
votes
1answer
92 views

What went wrong with my Mysql to MairiaDB migration fail ubuntu 16.04

This is on a 16.04 Mythbuntu (upgrade from 14.04, 12.04, 10.04) backend ( I have five systems already running MariaDB) with guidance from MariaDB Foundation (interactive) Downloads Setting up MariaDB ...
0
votes
1answer
123 views

Database lost ! MariaDB fresh installation

I'm using an Ubuntu VM with VirtualBox (Ubuntu 16.04.1) and i'm learning MySQL and SQL commands in command line in general. So i had a database created with the basics mysql installed on Ubuntu. ...
0
votes
0answers
563 views

Ubuntu 16.04 LTS install mysql-workbench with mariadb 10

I have tried all the solutions that i found here but still facing the same problem i even purged everything and installed mysql-server and got the same error i tryed to install mysql-workbench.deb ...