Stack Exchange Network

Stack Exchange network consists of 175 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]

SQL database that can be used as a "drop-in" replacement for MySQL

1
vote
0answers
13 views

Why does MySQL decide to check tables?

I've looked through a lot of MariaDB/MySQL documentation for an answer to this but have yet to find one. I am running MariaDB version 10.2.22 and have a bunch of MyISAM tables. I understand that the ...
0
votes
0answers
12 views

Select query to select all questions that particular user liked

i want to select that questions that particular user liked from(not sql keyword from) username tables are following tbl_users CREATE TABLE `queryit`.`tbl_users` ( `user_id` int(11) NOT NULL ...
0
votes
1answer
15 views

Root user from another VM (local network) on Mysql 5.7 while using plugin auth_socket

I have one virtual machine for my website, and one for my databases (mysql 5.7). The VMs are on debian 9 I would like to connect to mysql from my website VM. I install everything using ansible so it ...
0
votes
2answers
23 views

De-duping a table based on an expression using one field

Mariadb: mysql Ver 15.1 Distrib 10.3.8-MariaDB I have a table built as a union of queries from several other tables. This table looks something like- +-------------+--------------+------+-----+-----...
0
votes
1answer
25 views

“character encoding hell”- Configuring mariadb for utf8 end to end

Mariadb: "mysql Ver 15.1 Distrib 10.3.8-MariaDB" OS: Windows 10 64 bit I've been wrestling with getting a csv data file that contains "high 8 bit" characters such as the micron character and em dash ...
0
votes
0answers
18 views

In the principle of containerization, should I share a MySQL container or have separate containers?

I'm playing around with docker to install services on my (home) server. I already have a wordpress site installed. Now I want to also install NextCloud and Piwigo. I'm sure others will follow in the ...
0
votes
0answers
9 views

Filter the entries shown upon SELECT in MariaDB [migrated]

I have entries in a certain mariadb table with values in a column named code like: ABC-SI-GR-0 ABC-SI-NAV-0 ABC-GO-NAV-0 ABC-SI-NAV-3P ABC-GO-GR-0 ABC-GO-GR-3P ... ... and so on now I want to ...
0
votes
0answers
4 views

How do i figure out the location of binary logs for MariaDB versions less than 10.1.6?

MariaDB supports the LOG_BIN_BASENAME variable which can be queried as follows to get the location of binary logs. MariaDB [(none)]> select @@GLOBAL.LOG_BIN_BASENAME; +-----------------------------...
1
vote
0answers
22 views

MariaDB ColumnStore & Ubuntu 14.04

I see at mariadb.com that MariaDB ColumnStore isn't available to download for Ubuntu 14.04. Is there any way to achieve that?
0
votes
0answers
39 views

Cannot autostart mysqld from systemd on Debian Stretch after update

Problem with starting mariadb (mysqld 10.1.37-MariaDB-0+deb9u1) over systemd on Debian Stretch after latest update. Linux 4.9.0-8-amd64 #1 SMP Debian 4.9.130-2 (2018-10-27) x86_64 GNU/Linux Syslog: # ...
1
vote
0answers
47 views

XAMPP upgrade MARIADB 10.1 to 10.3

I use XAMPP v7.3 on my linux computer. This XAMPP version implement MariaDB 10.1.37 but I need the last version : 10.3. I tried to install it separately with this tuto. The installation was a success ...
0
votes
2answers
140 views

How to create a service to start my mariadb?

I installed mysql and mariadb in the same pc(win10).Port 3306 binded with mysql, 3307 with mariadb. net start mysql #start mysql server. Start mariadb server. F:/mariadb-10.3\bin\mysqld --...
0
votes
1answer
46 views

Where are the MySQL status messages/log are stored?

When I am running service mysql status I get: mariadb.service - MariaDB 10.1.33 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled) Drop-In: /etc/systemd/system/mariadb....
1
vote
1answer
494 views

MariaDB on Linux Mint: trouble setting root password

I don't know whether this is the right Stack Exchange Q+A for this... I just installed MariaDB in Linux Mint Cinnamon (18.1). mysql --version gives: mysql Ver 15.1 Distrib 10.0.34-MariaDB, for ...
0
votes
1answer
66 views

Unable to insert with blank value in MariaDB not in strict mode

I've just setup a new dev environment on Debian 9 and mariadb: 10.1.26-MariaDB-0+deb9u1 Debian 9.1 Previous environment was Debian 7 with mysql: 5.6.38-1~dotdeb+7.1 (Debian) value for sql-mode is: ...
0
votes
1answer
674 views

MYSQL service error & cannot start

My MySQL service & databases seem to be offline on my own VPS. It has had no problem over the past months, so I am unsure as to what caused this. The last thing I did was disable strict mode on ...
0
votes
1answer
140 views

Accessing GnuCash sql from Linux doesn't work anymore

I have a GnuCash database on a mariadb-server, which was set up with a copy of GnuCash from an Ubuntu 16.04 client, and all has been working well. Then I decided to test GnuCash from a Windows 10-...
1
vote
1answer
297 views

mysqldump: specify per-user db name in ~/.my.cnf

I'm running a shared server with multiple users. Each user has their own database in MySQL and associated credentials. I've created a template systemd timer & service (ie. sitetasks@.timer & ...
0
votes
1answer
37 views

MariaDB automatic back-up mode

I like having automatic backups, and I would like one for my MariaDB databases. I want it so in the event the MariaDB gets killed(e.g. OOM Killer during a DoS attack), there's a backup mode that ...
0
votes
0answers
223 views

Docker MariaDB instance not starting after update

I am getting the following errors from my log. I only updated the image and restarted. Could a recent change in the image have caused these errors? My host has plenty of space, so I’m not sure why I’m ...
0
votes
1answer
148 views

How do I start the mariadb service on NixOS?

On my NixOS 17.09 system, I've installed mariadb, by listing the package in my /etc/nixos/configuration.nix and nixos-rebuilding. The binaries now seem to be present, but the mariadb database service ...
1
vote
0answers
102 views

MediaWiki with MariaDB on Docker

I have 2 containers with 2 different MediaWiki running and I want to know. Do I need to create 2 containers with 2 MariaDB or just 1 container with MariaDB and two different DB inside? What is the ...
3
votes
2answers
6k views

Setup a Docker container to work with a local database

I'm trying to setup a Docker container to work with a local database. The image is this one https://hub.docker.com/r/tuxgasy/dolibarr/ and it suggests to also create a mariadb container, and link it ...
0
votes
1answer
2k views

Install phpmyadmin with MariaDB

I have a raspberry that I use as a development web server. The other day I had to reinstall the OS and when I tried to reinstall everything I have some problems. When I installed MySql I saw that I ...
0
votes
1answer
56 views

How to configure MariaDB to accept any username/password combination?

I have MariaDB running on my development workstation. The service is bound to localhost and cannot be remotely accessed. I would like to adjust MariaDB so all username and password combinations get an ...
2
votes
2answers
6k views

Can't setup/clean reinstall MariaDB/MySQL on Debian Stretch 9

While I NEVER experienced any problems with this on several Debian 8 machines and even Windows, I now simply can't manage to get a working installation of MariaDB/MySQL on my fresh installation of ...
1
vote
2answers
2k views

debian stretch upgrade - mariadb removed libmysqlclient.so.18 - how to get it back?

I upgraded to debian stretch from jessie. My mysql database migrated and I can read it. I have a django project that relies on libmysqlclient.so.18 to access mysql. i have mariadb-server and ...
0
votes
1answer
441 views

Not able to install SNMP on CentOS

I am trying to install SNMP utility on my CentOS. I have Mysql pre-installed on the machine. I am getting following error : yum install net-snmp Loaded plugins: fastestmirror, langpacks Loading ...
1
vote
1answer
2k views

Connect MySQL Workbench on PC to remote MariaDB server

MySQL Workbench operates on my PC at home with IP 1.2.3.4 and MariaDB is located on my server with IP 4.3.2.1. https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ ...
1
vote
1answer
950 views

MariaDB root user

Good day, I logged into mariadb with the skip grant tables option. Then I set password for the localhost root user. Then I flushed the privileges. However, I can still log in with the following ...
1
vote
0answers
62 views

Quickly Setup Nginx, mariadb, centos, redis and cpanel in AWS? [closed]

I need to setup my magento site AWS. for that I need centos , Nginx , Maria DB and Redis. is there any quick way to do that ? please recommend any documentation or any tutorial. Currently I have used ...
1
vote
1answer
2k views

mariadb server broken after failed package update

So I had a problem the other day when mariadb's server package failed to update correctly and would not longer run. Log started: 2016-07-19 04:00:34 Setting up mariadb-server-10.1 (10.1.16+maria-1~...
0
votes
1answer
787 views

Mariadb failed remove / install on Ubuntu 14.04

So I was messing around with mariadb installation on my machine and now am in a soup. I now can't either install or remove it. When I try to install: ~# apt-get install mariadb-server Reading ...
2
votes
1answer
404 views

How to display key to a file using OpenSSL?

I'm a newbie at encryption so I could do with some help: I'm trying to follow a tutorial on the MariaDB website to create an aes-256-cbc key to encrypt my data at rest. The line which it tells me to ...
0
votes
1answer
1k views

MySQL and MariaDB instances on the same server

Is there any way to install correctly MariaDB and update MySQL 5.5 to any superior version,without altering my production database? I'm told MariaDB could be installed on the same server but I need ...
0
votes
1answer
2k views

installing mariadb 5 on centos 7 Unit mariadb.service failed to load: No such file or directory

I try to install mariadb on centos 7 using official documentation https://mariadb.com/kb/en/mariadb/yum/ I have installed these packages: Installed Packages MariaDB-server.x86_64 5....
1
vote
1answer
13k views

How to uninstall MariaDB 5.5 completely (including configurations) from CentOS 7

I tried command yum remove mariadb mariadb-server It removed the client but failed to remove the server. error reading information on service mysql: No such file or directory error: %preun(MariaDB-...
0
votes
1answer
90 views

Do I need RAID1 in a galera cluster?

I have a 3-node galera cluster that supposedly performs synchronous write replication across the entire cluster. I am trying to figure out if it is a good idea to use a software RAID1 3-HD on these ...
1
vote
0answers
118 views

Wordpress + MariaDB installation becoming unstable [closed]

I have a wordpress installation on a CentOS machine using MariaDB as database server. This MariaDB is installed in another linux machine. Wordpress runs alone within httpd. About 7 days ago the ...
20
votes
7answers
84k views

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

I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked ...
33
votes
4answers
40k views

Can't reset MySQL (MariaDB) root password

Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why. I ...
1
vote
1answer
630 views

Can't change MySQL/MariaDB server collation option

I am trying to change the server's collation_server variable default option from latin1_swedish_ci to utf8_general_ci by adding it into the /etc/my.cnf.d/mariadb-server.cnf config file under a ...
1
vote
2answers
5k views

MySQL connection works on CLI, but not on Workbench

Fedora release 20 (Heisenbug) 3.19.3-100.fc20.x86_64 Packages: mysql-workbench-community.x86_64 6.1.7-1.fc20 mariadb.x86_64 1:5.5.41-1.fc20 mariadb-libs....
1
vote
1answer
422 views

MySql service start fails without anything meaningful (CentOS 7)

[root@myserver my.cnf.d]# service mysql start Starting MySQL. ERROR! And this is all I get. I tried checking the logs but couldn't find anything related to this. The database worked perfectly fine ...
0
votes
0answers
3k views

Can't start mariadb in centos 7

in the systemctl status it shows: systemctl status mariadb.service mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled) Active: failed (...
2
votes
1answer
648 views

apt-get wants to remove MariaDB on Debian Wheezy

I've set up my server to use MariaDB and used the installation instructions on the web page. It worked quite well. Now, if I want to dist-upgrade, apt-get wants to replace MariaDB with MySQL: The ...
0
votes
2answers
305 views

MariaDB Galera on Ubuntu 12.04.4 LTS trying to overwrite /usr/bin/mysqld

This morning I noticed that there was an available update for MariaDB, from 5.5.35 to 5.5.36. So I decided to upgrade one of the three nodes in our MariaDB cluster. However the update failed: root@${...
2
votes
1answer
5k views

Can't start MySQL on Fedora 20

I'm a newbie with Fedora and MySQL. I just installed Fedora 20 (virtual), then installed Apache and started it and then installed MySQL. When I tried to start MySQL using this command: sudo service ...
0
votes
1answer
508 views

Issues installing MariaDB (5.5.34) on Debian 7 (Wheezy)

When attempting to install MariaDB (5.5.34) on Debian 7 (Wheezy) apt-get outputs the following: Setting up mariadb-server-5.5 (5.5.34+maria-1~wheezy) ... [ ok ] Stopping MariaDB database server: ...
3
votes
1answer
7k views

Unable to install MariaDB on Centos 6.5 server - “No package available” in yum although Repo is present?

I've hit upon a strange issue with a new installation of CentOS 6.5 while trying to install MariaDB. I've included the following information and created a MariaDB.repo file inside the /etc/yum.repos....