SQL database that can be used as a "drop-in" replacement for MySQL
Questions tagged [mariadb]
116 questions
41
votes
4 answers
Can't reset MySQL (MariaDB) root password
Today, I wanted to create a database in PMA. It said: "Cannot log in to the MySQL server". I tried via a terminal, same problem, and it is because my password is wrong. And I can't understand why.
I tried the usual method to reset the root password…
Morgan Touverey Quilling
- 1,131
- 1
- 9
- 11
27
votes
6 answers
mysql (mariadb) ERROR 1698 (28000): Access denied for user 'root'@'localhost'
I'm working on Xubuntu 15.04. I already installed the MariaDB-Server on various systems and was always asked for a root password during installation. This time, however, I don't remember being asked for the password. When I try to login without a…
d72b617c
- 299
- 1
- 3
- 6
20
votes
4 answers
Setup a Docker container to work with a local database
I'm trying to setup a Docker container to work with a local database.
The image is this one https://hub.docker.com/r/tuxgasy/dolibarr/ and it suggests to also create a mariadb container, and link it to that.
I would like to configure the Dolibarr…
Sekhemty
- 9,166
- 18
- 60
- 97
13
votes
1 answer
How to expose Linux socket file from Docker container (MySQL, MariaDB, etc.) to host
Disclaimer: I am not looking for a way to configure MySQL/MariaDB to use TCP connections. I am aware of that option and the question is not about that aspect.
I am having trouble binding a socket file from inside a container to the host file system.…
Torque
- 339
- 1
- 3
- 10
7
votes
2 answers
How to fix MariaDB when it gets stuck during shutdown (Waiting for page_cleaner)?
I am running MariaDB (v 10.3.13) on Arch Linux (Manjaro). It worked normally for the last months but now there are some issues.
When I try to reboot the computer, it gets stuck at
A stop job is running for MariaDB 10.3.13 database server
The time…
jost21
- 697
- 2
- 9
- 25
4
votes
1 answer
How to recover and restore a MariaDB database from a broken CentOS 7 system?
In a Virtual Box VM I had CentOS 7 server installed in a VDI HDD and for some reason “Something I did obviously…” I cant boot the machine with the messages bad magic number you need load the kernel
First, I have tried some things like clean the…
denn0n
- 303
- 4
- 12
4
votes
1 answer
Why !includedir means import file?
cat /etc/mysql/mariadb.cnf
# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/ …
showkey
- 89
- 4
- 16
- 40
4
votes
3 answers
debian stretch upgrade - mariadb removed libmysqlclient.so.18 - how to get it back?
I upgraded to debian stretch from jessie.
My mysql database migrated and I can read it. I have a django project that relies on libmysqlclient.so.18 to access mysql.
i have mariadb-server and libmariadbclient18 packages installed.
what should i do to…
jakethedog
- 786
- 8
- 18
3
votes
1 answer
Unable to install MariaDB on Centos 6.5 server - "No package available" in yum although Repo is present?
I've hit upon a strange issue with a new installation of CentOS 6.5 while trying to install MariaDB.
I've included the following information and created a MariaDB.repo file inside the /etc/yum.repos.d/ folder:
# MariaDB 5.5 CentOS repository list -…
mickburkejnr
- 1,487
- 5
- 28
- 38
2
votes
1 answer
apt-get wants to remove MariaDB on Debian Wheezy
I've set up my server to use MariaDB and used the installation instructions on the web page. It worked quite well. Now, if I want to dist-upgrade, apt-get wants to replace MariaDB with MySQL:
The following packages will be REMOVED:
…
The Wavelength
- 538
- 1
- 8
- 23
2
votes
1 answer
Can't start MySQL on Fedora 20
I'm a newbie with Fedora and MySQL. I just installed Fedora 20 (virtual), then installed Apache and started it and then installed MySQL. When I tried to start MySQL using this command:
sudo service mysqld start
I get this:
Redirecting to…
asedsami
- 123
- 1
- 7
2
votes
0 answers
Is there any harm in using the MariaDB client to connect to a MySQL server?
I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it.
It seems like although the client command is mysql, the version is MariaDB:
$ mysql --version
mysql Ver 15.1 Distrib…
Murat Ayfer
- 121
- 2
2
votes
1 answer
Why is MariaDB using localhost when using TCP?
I installed MariaDB via Nix and I am having trouble connecting via TCP.
I have users such as:
MariaDB [(none)]> SELECT User, Host FROM mysql.user;
+---------------+-----------+-------------------------------------------+
| User | Host …
steinybot
- 131
- 7
2
votes
1 answer
Can not start MariaDB service on windows 10 machine although I have full admin rights
At work I have to use Windows 10 for the first time and I am having a hard time starting a service.
I downloaded the latest version of MariaDB as a .zip from the official homepage at: https://downloads.mariadb.org/mariadb/10.4.8/
Via a command line…
Nic.Star
- 21
- 1
- 2
2
votes
2 answers
MariaDB is not running, but PID file exists
I have an issue with MySQL. Although it looks like MySQL is able to start on my server:
service mysql start
Starting MariaDB.190930 03:56:09 mysqld_safe Logging to '/var/log/mysqld.log'.
190930 03:56:09 mysqld_safe Starting mysqld daemon with…
koren ber
- 31
- 1
- 4