17
votes
Accepted
MariaDB accepts any password
The answer: https://www.percona.com/blog/2016/03/16/change-user-password-in-mysql-5-7-with-plugin-auth_socket/:
Apparently the mysql-server installation on 16.04 (or any 5.7
installation?) allows ...
- 657
15
votes
Accepted
Debian 9: After upgrade from 8, MySQL (MariaDB) does no longer work
For some reason you don't have the file /etc/mysql/debian-start, which is the error given:
16:55:25 doraemoe systemd[6859]: mariadb.service: Failed at step EXEC spawning /etc/mysql/debian-start: No ...
- 16.5k
10
votes
Debian: apt-get upgrade says "The following packages have been kept back" for various mariadb packages
You can find a package’s changelog by going to its package page (“https://packages.debian.org/packagename”), and looking for a link to the “Developer Information” on the right-hand side. (There’s also ...
- 481k
8
votes
Failed to start MariaDB database server after upgrade to debian 9
In the tutorial you should install mariadb-server in place of mysql-server.
I've got the same problem on DEBIAN 9 install and these command worked for me :
sudo apt purge 'mysql*'
sudo apt purge '...
- 1,480
8
votes
Accepted
The following packages have unmet dependencies: mariadb-server
I found this post and used aptitude in place of apt-get or apt, and it finally looks like there is some hope...
Instead of using
sudo apt install mariadb-server
I used
sudo aptitude install ...
- 317
8
votes
Failed to search for file: Failed to download gpg key for repo 'mariadb-main': Curl error (37)
TelcoM's comment answers the root cause of this:
Apparently you have the PackageKit-command-not-found RPM package installed. It adds a special customization to the shell's "command not found&...
6
votes
The following packages have unmet dependencies: mariadb-server
It looks like you fixed it, but I'm guessing the original problem was that not all the necessary packages were purged.
apt-get remove --purge mysql*
only removes packages that start with "mysql". ...
- 161
5
votes
systemd status=127 for /usr/bin/install when trying to start MariaDB
This happened to me, the problem was that systemd was not updated to a version compatible with the mariadb.service configuration. I updated systemd to 241 and it started working.
- 51
5
votes
systemd status=127 for /usr/bin/install when trying to start MariaDB
in my case
systemctl daemon-reexec
then
service mysql start
- 151
5
votes
MariaDB & Amazon Linux 2: ERROR: ld.so: object '/usr/lib64/libjemalloc.so.1' from LD_PRELOAD cannot be preloaded
I was in the same situation.
To fix, I installed the jemalloc package: sudo yum install jemalloc
Symptoms:
sudo find / -name "libjemalloc*" returned nothing, telling me there was no ...
- 151
4
votes
Accepted
MariaDB won't start, even after reinstalling
Delete the file /var/lib/mysql/tc.log reboot the system and start maria db again. Also ensure there is enough space in /var and /tmp if you're using separate partition for them.
I think once your /...
- 2,136
4
votes
Accepted
How do I start the mariadb service on NixOS?
NixOS option services.mysql.enable works for starting either MySQL implementation (mysql-* or mariadb). Which one gets started is determined by services.mysql.package.
So in your /etc/nixos/...
- 439
4
votes
Accepted
How to drop a database with metacharacters in the name
Use backticks for the object name; not backslashes to escape single characters:
mysql> drop database `#really-bad+name`;
Query OK, 0 rows affected (0.00 sec)
- 79.2k
4
votes
Error while installing mariadb-server on Kali Linux
Okay so according to the error, you are missing a file. What you can do is download and extract the package and insert the missing file and then resinstall the package.
First, download the package by ...
- 1,470
4
votes
Accepted
Why do we misnomer MariaDB as a "mysql-server"?
Shouldn't the general, umbrella package be called "default-sql-server"?
Definitely not. MariaDB, MySQL are far from being the only or the "default" SQL server. There's important ...
- 51.4k
3
votes
Problem installing mariadb
mariadb is part of the base repo in CentOS 7 and should already be installed. The incompatibilities are probably due to additional repos (e.g. IUS, EPEL) you configured.
Disable the third-party ...
- 32.4k
3
votes
Accepted
What is MariaDB's default password on CentOS 7?
There is no default password. But it does appear as though one might require a password when attempting to connect to a process that is not running.
Is a mysql process running?
ps aux | grep mysql
...
- 16.3k
3
votes
What is the default root password for mariadb in Arch Linux?
The wiki says you should be able to log in with an empty password for root like so:
$ mysql -u root -p
However, you may still get an error when you use an empty password:
ERROR 1698 (28000): Access ...
- 131
3
votes
MariaDB - dependency problems - leaving unconfigured
I just got this error. For those new here.
The problem was from mysql database missing. Because I deleted the folders /var/lib/mysql/ and /etc/mysql/.
I just executed sudo mysql_install_db. Then ...
- 139
3
votes
MariaDB client has no prompt in Emacs sql-mode
If adding to .emacs, do so as follows:
(require 'sql)
(sql-set-product-feature 'mysql :prompt-regexp
"^\\(MariaDB\\|MySQL\\) \\[[_a-zA-Z]*\\]> ")
The (require 'sql) is needed for sql-...
- 907
3
votes
systemd status=127 for /usr/bin/install when trying to start MariaDB
The only command that worked for me was using aptitude this takes a look at all necessary dependencies etc. when installing new packages.
sudo aptitude install mariadb-server
Another problem you may ...
- 131
3
votes
Accepted
How can I get MariaDB to resume action?
You need to find out why MariaDB isn't starting. Check out this page of troubleshooting advice on the MariaDB website.
It says:
The reason for the failure will almost certainly be written in the ...
- 46
3
votes
Accepted
Why can I not transfer a db from one container to another?
I try to transfer the database from one to another via a pipe
so you need to use a pipe (|) rather than a redirection (>):
docker exec 799f2226367f mysqldump -u magento -pmagento magento | docker ...
- 481k
2
votes
"SSL certificate validation failure" when verifying wildcard server certificate in MariaDB 5.5
The MariaDB client libraries did not support wildcard certificates until MariaDB 10.1.23.
Percona-Server's client library started supporting wildcard in Percona Server 5.7.18-16 and Percona Server 5....
- 121
2
votes
MariaDB - dependency problems - leaving unconfigured
I had a very similar issue installing MariaDB server 10.0 on Ubuntu 16.04 upgraded from Ubuntu 14.04.
Setting up mariadb-server-10.0 (10.0.31-0ubuntu0.16.04.2) ...
dpkg: error processing package ...
- 121
2
votes
What is MariaDB's default password on CentOS 7?
I faced the same problem when I did a reinstall of mariadb, I was not able to logon. I found that when I removed the /var/lib/mysql directory and then installed MariaDB again, I was able to connect as ...
- 306
2
votes
Accepted
MySQL/Maria Database not loading: /var/run/mysqld/mysqld.sock (2 "No such file or directory")
Your MySQL DB is corrupted.
Backup your /var/lib/mysql first.
Then do:
sudo mysqld --skip-grant-tables &
or for Debian
mysqld_safe --skip-grant-tables &
While running it, do:
$ mysql
...
- 58k
2
votes
Debian 8 Jessie errors on all MariaDB mirrors : Signature by key 199369E5404BD5FC7D2FE43BCBCB082A1BB943DB uses weak digest algorithm (SHA1)
The key did change between Jessie and Stretch. For Stretch, you would use:
sudo apt-get install software-properties-common dirmngr
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com ...
- 121
2
votes
Accepted
How to install php + mysql on Fedora?
Your PHP configuration appears correct.
Strangely, with httpd and a few other services, it seems that sometimes systemctl restart doesn't actually appear to do anything. But systemctl stop followed ...
- 9,088
Only top scored, non community-wiki answers of a minimum length are eligible