Questions tagged [mariadb]

161 questions
34
votes
1 answer

Anyone know a good gui to MariaDB?

I'm using MariaDB instead of MySQL in Slackware 14.1, and I need a graphic manager like MySQL Workbench. Can anyone suggest me something? I tried using MySQL WorkBench but it could not connected with MariaDB.
Patterson
  • 765
  • 3
  • 12
  • 25
15
votes
1 answer

MySQL Workbench warning when connecting to MariaDB

When using MySQL Workbench 6.3 on Kubuntu 15.10 and MariaDB Server version: 10.0.22-MariaDB-0ubuntu0.15.10.1 (Ubuntu), I get the following warning. Is this expected? Incompatible/nonstandard server version or connection protocol detected…
MountainX
  • 17,168
  • 59
  • 155
  • 264
14
votes
1 answer

control-w (delete word) deletes whole line in MariaDB client

I've been using the original MySQL client for "eons" and I'm rather accustomed to using bash-like shortcuts in it. One of my more frequently used ones is to use control-w to delete the word before the cursor (just like you do in bash). Currently,…
dougBTV
  • 2,494
  • 1
  • 17
  • 17
11
votes
4 answers

MySQL max_open_files more than 1024

While starting MariaDB I got [Warning] Could not increase number of max_open_files to more than 1024 (request: 4607) $ sudo systemctl status mysqld ● mysqld.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service;…
user977828
  • 921
  • 4
  • 16
  • 30
9
votes
7 answers

MariaDB - dependency problems - leaving unconfigured

I have tried to install ISPConfig3 on Debian Jessie 8.1, and it couldnt connect to mySQL (mariaDB 10.1). So I CTRL+C to kill the install and I tried to manually login to mySQL, but I failed. It was complaining about the socket. So I purged and…
KingsInnerSoul
  • 404
  • 2
  • 7
  • 20
9
votes
5 answers

What is the default root password for mariadb in Arch Linux?

I install mariadb in arch-linux. but I haven't got access to MySQL. I try this: mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) I see very similar question, and test all of…
Vahid Kharazi
  • 517
  • 4
  • 10
  • 15
8
votes
3 answers

MariaDB client has no prompt in Emacs sql-mode

I just upgraded from an old MySQL client to mariadb-clients-10.0.21-3 on Arch Linux. After the upgrade, I no longer see a prompt when using Emacs's sql-mysql function. It seems mysql is buffering the prompt, because it shows up in the first line of…
cjm
  • 26,740
  • 12
  • 88
  • 84
7
votes
5 answers

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 mariadb * mariadb.service - MariaDB 10.2.20…
BrainStone
  • 3,534
  • 12
  • 32
  • 53
7
votes
2 answers

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 '/var/run/mysqld/mysqld.sock' (2 "No such file or…
Doraemoe
  • 73
  • 1
  • 1
  • 4
7
votes
2 answers

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 on install so I'm going to set it after the…
Forkbeard
  • 597
  • 8
  • 18
7
votes
3 answers

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 for mariadb.service failed because the control…
Zoker
  • 179
  • 1
  • 1
  • 3
6
votes
2 answers

Failed to search for file: Failed to download gpg key for repo 'mariadb-main': Curl error (37)

I installed MariaDB on a computer with CentOS using the instructions given here: MariaDB Package Repository Setup and Usage - MariaDB Knowledge Base The basic command I used was: sudo yum install MariaDB-server MariaDB-client and I did not…
user13267
  • 189
  • 2
  • 12
6
votes
1 answer

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 following packages have been kept back: …
dave559
  • 349
  • 5
  • 19
6
votes
4 answers

unable to launch mysqld in arch linux

I have recently installed Arch Linux x64 and I wanted to install the LAMP stack. Everything worked fine, until I arrived to the MySQL part that I installed but can't launch. The output of sudo systemctl start mysqld gives : Job for mysqld.service…
Mohamed
  • 251
  • 1
  • 3
  • 8
5
votes
3 answers

The following packages have unmet dependencies: mariadb-server

How can I get Mariadb running again? My WordPress site is returning: Error establishing a database connection It seems that my database is down. (I updated Ubuntu 19.04 to 19.10 and have had multiple problems.) I went ahead and checked for MySQL…
MeSo2
  • 317
  • 1
  • 3
  • 11
1
2 3
10 11