Questions tagged [mariadb]
The mariadb 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 ...
