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