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

Questions tagged [mariadb]

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

1
vote
2answers
60 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
21 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
138 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
114 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
44 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
66 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
349 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
378 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
10 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
62 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
21 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
145 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
29 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
399 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
64 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
847 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
660 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
523 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
330 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
66 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
3k 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
151 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
443 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
117 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
365 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
57 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
46 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
281 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
1k 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
42 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
182 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
778 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 ...
0
votes
0answers
40 views

cannot connect to mariadb by JPDB admin

I'm using ubuntu16.0.4 and mariadb 10.1 with JPDE admin to manage the database. I can access to mariadb by mysql -uroot -p in the command line but I cannot connect to the mariadb at the very first ...
1
vote
2answers
706 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... ...
2
votes
2answers
8k 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
753 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
414 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
231 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
425 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
165 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
85 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
112 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
521 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 ...
0
votes
1answer
529 views

Error in Exporting and importing Database in MariaDb from Ubuntu 14.04 LTS Command Terminal

I am new to Ubuntu. I have installed Xampp on Ubuntu 14.04 LTS. Can you please tell me, what is wrong with this Export database command ? mysqldump - u root -p sachin_copy_db > /home/sachin/...
1
vote
2answers
2k views

Accidentally installed MariaDB over Mysql. How do I recover my Mysql databases?

I installed MariaDB and failed to notice it replaces Mysql. During the install, it moved the Mysql data directory to mysql-5.7. I removed MariaDB and reinstalled Mysql and tried to restore my ...
0
votes
1answer
1k views

Can't install MySQL on Ubuntu 16.04

I installed mariadb-server before installing mysql-server (which I wasn't supposed to do), so I purged mariadb* and removed it from the repos. However, I can't install mysql-server. After sudo apt-...
1
vote
0answers
1k views

Mariadb wont start

Mariadb does not start, no matter what I do. It always looks like: Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job for mariadb.service failed because the control process exited with error ...
0
votes
0answers
59 views

ODBCCreateDataSourceQ4 vs myodbc Discontinuation

I need a DSN to connect to a MariaDB (Ubuntu's replacement for MySQL) database and seem to have run into some confusion about ODBC drivers on Ubuntu (and Linux in general). Specifically, Flora-2 ...
0
votes
1answer
421 views

ubuntu upgrade from mysql to maria db

First a backup all my databases mysqldump -u caiofior -p --all-databases > /home/caiofior/all.sql Then uninstall mysql sudo apt-get purge $(sudo dpkg -l | grep -E 'mysql-(server|client|commom)' |...