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]

The tag has no usage guidance.

1
vote
2answers
16 views

Remove MariaDB in non-interactive mode

When I want to remove MariaDB from the system, I run # apt remove --purge mariadb*, but then I get a prompt like this one: Is there a way for me to skip this prompt specifying a value for yes or no? ...
3
votes
1answer
233 views

Debian: apt-get upgrade says “The following packages have been kept back” for various mariadb packages

I am running Debian 9 (stretch) and have just tried to run apt-get update and apt-get upgrade in order to update my (test) webserver as part of regular maintenance. apt-get upgrade says: The ...
1
vote
0answers
36 views

Failed to start mariadb server

starting mariadb server as a systemd service (systemctl start mariadb-server.service) fails with error message: Incompatible header in messagefile '/usr/share/mysql/english/errmsg.sys'. Probably ...
2
votes
1answer
162 views

systemd status=127 for /usr/bin/install when trying to start MariaDB

I just upgraded my MariaDB installation to 10.2. When I now try to start the service, it tells me it failed an checking the status shows me this rather strange message: root@server # systemctl status ...
3
votes
1answer
58 views

Debian 8 Jessie errors on all MariaDB mirrors : Signature by key 199369E5404BD5FC7D2FE43BCBCB082A1BB943DB uses weak digest algorithm (SHA1)

I've inadvertently stepped into "update hell". I updated a number of dependencies trying to install the Gerbera media server. In the process several existing services stopped running, including ...
0
votes
0answers
34 views

Is there a phpmyadmin equivalent for nginx?

I've installed LEMP (w/ Mariadb) on a Debian 9 (Stretch) on a Raspberry Pi. I've only had experience with Apache before this and phpmyadmin to manage the databases. I can't find tutorials to add ...
1
vote
0answers
19 views

MySQL - query to show guests with same last_name + booking_date [closed]

I have a guest table and a booking table and I am attempting to query how to find guests who share the same last names with the same booking date. The result should output their last_name and ...
1
vote
1answer
26 views

mysqldump on mariadb 10 extremely slow [closed]

I'm running a MariaDB 10.1.34 instance on AWS RDS. Instance specs are as follows: Instance Class: db.t2.large Storage: 100GiB gp2 DB Size: 1.2 GiB I'm trying to create a mysqdump from an EC2 ...
1
vote
3answers
198 views

How to install php + mysql on Fedora?

I'm trying to install wordpress locally. I've installed mysql (MariaDB) and php-mysqli. I have user created and database from mysql console and I have this 3 files: $ cd /etc/php.d/ $ cat 30-mysqli....
0
votes
0answers
27 views

Migrating a Mysql 5.1 db on Centos6 to a Mariadb 5.5 on Centos7

I have a huge application that I need to migrate. It is currently running on an old Centos6, with MySQL 5.1. The next version of Centos use MariaDB 5.5, and according to the documentation, I should ...
0
votes
0answers
34 views

MariaDB Galera Cluster on Ubuntu 16.04 does not start after rebooting

I've installed a MariaDB Galera Cluster on Ubuntu 16.04 in 2 nodes. Here the info from node1: root@localhost:~# sudo more /etc/mysql/conf.d/galera.cnf [mysqld] binlog_format=ROW default-storage-...
1
vote
1answer
30 views

How to DROP database with different case in the name

I tried to drop this kind of database name in MariaDB : MariaDB [(none)]> DROP DATABASE `db_IRP_rec` ; ERROR 1008 (HY000): Can't drop database 'db_irp_rec'; database doesn't exist It seems mysql ...
0
votes
0answers
22 views

MariaDB Clusters in Ubuntu 16.04

I've installed MariaDB Clusters in Ubuntu 16.04 I've Restarted the MariaDB service on the primary Linode, with the --wsrep-new-cluster flag: sudo mysqld --wsrep-new-cluster but it seems that the ...
1
vote
2answers
24 views

How to drop a database with metacharacters in the name

How to drop database with metacharacters in the name. The database name is #mysql50#lost+found. I'm connecting in mysql as root user. I tried to put backslashes like in a shell command: MariaDB [(...
-1
votes
2answers
168 views

Unable to set-up MariaDB on Arch Linux / Permission Denied on mysql_install_db

Having trouble setting-up MariaDB. I'm following Arch Linux | MariaDB I installed MariaDB on Arch Linux sudo pacman -S mariadb I've created a new folder /mnt/local/int001/MEDIA/Personal/DB with ...
0
votes
2answers
135 views

haproxy pass origin IP in galera cluster db

We have one galera cluster, mariadb version 10.3 and haproxy. We want the users to connect like this client->haproxy->galera_cluster. The user we create in the database we allow the IP to the client....
0
votes
0answers
53 views

Setting MySQL/MariaDB data directory to a directory in `home`, how can I make sure the `/home` is mounted before mysql daemon starts at boot time

On openSUSE Leap 15, I install MariaDB by: > sudo zypper in mariadb Right after installing MariaDB and right before starting it, I add this line to /etc/my.cnf, to set the MariaDB data directory ...
0
votes
1answer
482 views

Problem installing mariadb

I want install mariadb but i get this error [root@wslb_206]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@wslb_206]# yum install mariadb-server mariadb --> Finished ...
0
votes
0answers
29 views

Zenbership Install Fails with Error: SQLSTATE[HY000] [2002] No such file or directory

I recently installed Zenbership to our sandbox. It was a smooth and easy install process, set folder permissions, create a DB & user, it connected to MariaDB and established the DB, no problem. I ...
0
votes
0answers
120 views

Deploying both Django and MySql Server to one CentOS 7 Server Conflicts

I'm trying to deploy a Django App with MySQL server to a CentOS 7 server, but I'm having issue with installing MySQL server and mysqlclient on the same server. I first had MariaDB installed and ...
0
votes
1answer
334 views

problem starting mariadb

When I tried to start mariadb, I got: [root]# systemctl start mariadb Failed to start mariadb.service: Unit not found. And I also got this message: Package 1:mariadb-5.5.56-2.el7.x86_64 is ...
1
vote
0answers
88 views

Is changing the system hostname on a server with a running MySQL / MariaDB service harmful?

I want to change the hostname of a running CentOS 7 server which is running MySQL (mysql Ver 15.1 Distrib 10.0.33-MariaDB, for Linux (x86_64) using readline 5.1). Although I can't find any sources ...
0
votes
0answers
419 views

Mariadb can't be installed on my Debian, why?

Because I like to have my own DB, I tried to install MariaDB. Here are the steps I used: apt-get remove mysql-server mysql-client # Just to be safe that mysql isn't there apt-get autoremove apt-get ...
0
votes
0answers
99 views

mariadb monitoring with monit

please explain me how can I this scenario. I have three servers MariaDB. I want to monitor all server mariadb with monit tools. In that case, if the service failed or stopped, start MariaDB again, ...
0
votes
1answer
242 views

Why has MySQL-python package been removed as part of the removal of MariaDB?

Recently I removed some MariaDB packages in order to install a new version from an RPM file. yum remove mariadb mariadb-server mariadb-libs And as part of the process yum also removed MySQL-python ...
1
vote
1answer
191 views

Installed MariaDB 5.5.52 from RPM, MariaDB 5.5.59 gets installed

I have a database server with MariaDB 5.5.52: [root@sql01 ~]# yum list installed|grep 5.5.52-1.el7 Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast mariadb.x86_64 ...
0
votes
0answers
29 views

Galera cluster as mysql slave

I need to migrate a large database from a standalone mysql 5.5 server to my galera cluster. As this database is quite large - arround 80 Gb -, I can't use the proper way : mysqldump and restore, as ...
5
votes
2answers
3k views

Debian 9: After upgrade from 8, MySQL (MariaDB) does no longer work

I just upgraded from Debian 8 to 9. Apparently, it breaks everything database related. I now can't start MySQL, the error is: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/...
2
votes
1answer
3k views

MySQL/Maria Database not loading: /var/run/mysqld/mysqld.sock (2 “No such file or directory”)

Setup Server computer Distro: Raspbian GNU/Linux 8 Kernel: 4.9.35-v7+ armv7l (32 bit) My MySQL database is not loading admin@Xroklaus:~ $ sudo systemctl status mysql ● mysql.service - LSB: Start ...
2
votes
1answer
1k views

MariaDB won't start, even after reinstalling

I've been reinstalling, update, upgrade but still didn't solve the problem. Been searching for answer on google but the problem persists. Here's the output when i ran systemctl status mariadb.service: ...
0
votes
0answers
42 views

Changing export folder of mySQL (MariaDB) in Raspbian OS

My understanding is that exporting a file (e.g. csv) from MariaDB is restricted to specified folders by default. Thus, I have been accessing my exported files at the tmp folder so far. I wanted to ask ...
0
votes
0answers
447 views

Mariadb won't start: Failed Registration of InnoDB as a Storage Engine

I've installed mariadb on my PC. But it won't start the service. The command sudo systemctl mariadb.start return the error- Job for mariadb.service failed because the control process exited with ...
1
vote
1answer
236 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
2answers
970 views

What is MariaDB's default password on CentOS 7?

I installed the mariadb-server package on CentOS 7 with the command: sudo yum install mariadb-server The installation completed successfully, but I can't seem to log in to the server. Usually, a ...
6
votes
1answer
3k views

MariaDB accepts any password

Running MariaDB 10.1.23-MariaDB-9+deb9u1 on Debian 9.1. Fresh OS installation, installed MariaDB with apt-get install mariadb-server mariadb-client Apparently MariaDB doesn't ask for a root password ...
2
votes
2answers
3k views

Failed to start MariaDB database server after upgrade to debian 9

After upgrade to debian 9, I get this issue, when trying to do a apt-get upgrade: Failed to start MariaDB database server Here is the log: Setting up mariadb-server-10.1 (10.1.23-9+deb9u1) ... Job ...
1
vote
0answers
69 views

Mariadb cluster doesn't start on reboot

I make cluster for mariadb on 3 VMs(called controller1, controller2, controller3), them works fine. But however, after I reboot the VMs, the mariadb is not start: [root@controller1 ~]# rabbitmqctl ...
1
vote
1answer
477 views

“SSL certificate validation failure” when verifying wildcard server certificate in MariaDB 5.5

I've been trying to move from using a self-signed certificate to using a wildcard certificate from a well-known CA to reduce maintenance overhead and improve security. The certificate has already been ...
1
vote
0answers
457 views

1 FastCGI sent in stderr: "PHP message: PHP Fatal error: session_start(): Failed to initialize storage module:

I installed phpMyAdmin on my Arch Linux box. I then created a sym link named phpmyadmin in my /usr/share/nginx/html/ to /usr/share/webapps/phpMyAdmin/. When I visit http://127.0.0.1:8080/phpmyadmin/ ...
1
vote
1answer
189 views

How can I rebind shortcut for mysql client? — or: How to replace editline with readline for mysql client?

I am using the msyql-client, and I open a mysql prompt on a terminal via: $ mysql -h localhost -uuser -ppassword mysql> I use the msql client version: Ver 14.14 Distrib 5.7.17, for Linux (...
4
votes
2answers
3k views

mariadb service is not starting after boot, CentOS 7

I defined the service for mariadb on: /etc/systemd/system/mariadb.service [Unit] Description=start and stop MySQL(MariaDB) Server After=syslog.target After=network.target [Service] Type=simple User=...
1
vote
1answer
229 views

Unable to find the OUTFILE of mysql query

I have an MySql query from which i generate a OUTFILE (.csv) which i save it in /tmp . Please find the query below : SELECT 'Artifact ID' id, 'Related Links' new_value UNION select CONCAT(si....
1
vote
2answers
834 views

upgrade mariadb 10.0.29+maria-1~jessie failed [closed]

using debian 8 with mariadb repository, apt-get dist-upgrade command failed for Mariadb Packages. Lecture des listes de paquets... Fait Construction de l'arbre des dépendances Lecture des ...
0
votes
1answer
977 views

How do I install and use Galera and MariaDB 10.1 on RHEL or CentOS with SELinux Enabled

How do I install and use Galera and MariaDB >= version 10.1 with TLS on RHEL 7 or CentOS 7 and keep SELinux enabled in enforcing mode without using SCL (software collections)?
0
votes
1answer
839 views

unmet dependencies with mariadb: mariadb-client-10.0 conflicts with mysql-client-core-5.5

How to solve the issue below? $ sudo apt-get purge [sudo] password for massa: Reading package lists... Done Building dependency tree Reading state information... Done You might want to run '...
1
vote
1answer
256 views

Antergos MariaDB problems

I've just installed the mariadb package and doesn't work (doesn't start), I've these outputs: systemctl status -l mariadb.service ● mariadb.service - MariaDB database server Loaded: loaded (/...
0
votes
1answer
312 views

What replaces mysql-*-5.6?

I'm following these instructions to get MythTV set up on a Raspberry Pi 3. One of the steps is to install mysql (both server and client): sudo apt-get install mysql-server-5.6 ntp libicu55 libqt5sql5-...
1
vote
0answers
102 views

unixODBC and iODBC installed at the same time?

Is there any conflict with having unixODBC and iODBC installed at the same time? (It seems that some programs might depend on one or the other, at least if I try to uninstall iODBC, it also wants ...
1
vote
1answer
190 views

Where is “an appropriate place” for jar files on Debian, e.g. for a MariaDB JDBC connector?

I'm trying to install a JDBC Connector for MariaDB in the form of a JAR archive. The instructions say to put the jar file in "an appropriate place". Where should I put the jar file on Debian?
1
vote
2answers
738 views

Error connecting to AWS RDS mariadb instance

I have just created an AWS EC2 Ubuntu instance and an RDS mariadb instance to go with it. (I'm using the free tier at the moment). I have turned off the public access to the RDS so that it only is ...