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]

The tag has no usage guidance.

1
vote
1answer
14 views

unixODBC: Cannot load libmaodbc.so

I'm working on an embedded platform and I am trying to access a MariaDB through unixODBC. Trying to test the connection with isql I get the response: isql -v mydsn myuser mypw [01000][unixODBC][...
0
votes
1answer
66 views

Getting “ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value” Error using mariadb

While creating a haproxy_check user in MariaDB I am getting error ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value, what I need to do?
1
vote
0answers
64 views

How to enable Persian support in GNOME terminal?

I have Persian character in my MariaDB database, when I select data from tables and show in terminal, Persian is not supported and bad are displayed.
0
votes
1answer
44 views

Only root can log in to Mariadb on Centos 7

I just installed Centos 7 and LAMP stack. However, I only can log in to Mariadb as root even though there is another user. I've been using MySQL for a couple of decades but I can't figure this out. ...
0
votes
0answers
10 views

Reverse incremental search does not work in mariadb

I use mariadb 10.2.8-5 on Centos 7.5.1804. The problem is that the key shortcut Ctrl-r does not work on mariadb shell to search through the history. It works fine on bash. Also, it works on mariadb 5....
0
votes
0answers
20 views

MariaDB 10 unstable work on Debian 9 [duplicate]

I installed debian9 with vesta control panel, it comes with 10.1.37-MariaDB-0+deb9u1 Debian 9.6 and php7. I need php5.6, so I found instruction on how to install PHP-fpm. Everything went well and ...
2
votes
0answers
48 views

Problem restoring Wordpress database

Some months ago I created a Wordpress implementation using NGINX and mariadb (on a Raspberry Pi running Raspbian Stretch). This developed some problems (as a result of a failed attempt to install ...
0
votes
0answers
37 views

mysqladmin generates “error” messages

Some time ago I installed NGINX, php7, mariaDB and Wordpress on my Raspberry Pi running Raspbian. I created a Wordpress database - which is working. Recently I installed ssmtp and mailutils on my ...
1
vote
2answers
51 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
815 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
150 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 ...
3
votes
2answers
742 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
152 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
39 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
59 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
868 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....
1
vote
1answer
36 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
23 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
73 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
264 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
241 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
79 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
981 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
1answer
523 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
100 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
527 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
1answer
352 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
259 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 ...
5
votes
2answers
5k 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
4k 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
2k 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: ...
1
vote
1answer
336 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
2k 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
2answers
4k 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
5k 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
81 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
567 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
496 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
229 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
3answers
4k 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
335 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
984 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
1k 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
933 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
268 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
330 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
107 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
305 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
874 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 ...