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