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

learn more… | top users | synonyms

0
votes
0answers
36 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
125 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 ...
0
votes
0answers
22 views

How to reset root pass when the db multi-master sync replication cluster is setup in MySQL Galera Cluster

I have installed MariaDB Galera Cluster in ubuntu 14.04. Multi-master sync replication cluster is setup but we have misplaced the root password. Would really appreciate if somebody could help ...
2
votes
1answer
29 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
0answers
15 views

Debian Mysql and MariaDB installing

I'm researching over the internet about how to have 2 instances of databases like Mysql and Mariadb, actually there's one resource on MariaDB URL but it is for Centos. I need one step by step focus ...
-1
votes
1answer
83 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
368 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 ...
0
votes
1answer
2k 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(...
0
votes
0answers
57 views

Transparent Encryption on MariaDB on RHEL7

I have a RHEL7 server running the latest mariadb MariaDB-server.x86_64 10.1.9-1.el7.centos I am trying to set up transparent encryption on MariaDB and I have a number issues: How can I test that ...
0
votes
1answer
32 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
69 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 ...
2
votes
3answers
7k 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 ...
13
votes
3answers
7k 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
107 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
2k 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
169 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
2k 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
453 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
263 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
4k 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
454 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: ...
1
vote
1answer
3k 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....
1
vote
0answers
108 views

Is there any harm in using the MariaDB client to connect to a MySQL server?

I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it. It seems like although the client command is mysql, the version is ...
0
votes
1answer
1k views

Can't install Galera on Ubuntu 12.04

I'm not very experienxed with Debian/Ubuntu. I follow this guide: https://mariadb.com/kb/en/installing-mariadb-deb-files/ And this one for adding the required repositories (I don't install MariaDB!!!)...
1
vote
0answers
174 views

Unable to install MariaDB on Debian 7

I'm trying to install MariaDB on my Debian 7 development machine and I've hit a problem. Following this tutorial, and this workaround, I enter this command: sudo apt-get install mariadb-server-5....