Questions tagged [mariadb]
The mariadb tag has no usage guidance.
110
questions
0
votes
1answer
42 views
Ubuntu MySQL Failing install with Apt-Get
I previously had MariaDB installed and I'm wanting to install MySQL 5.7 on my server. I purged all files with mariadb and mysql. Though when I install MySQL-Server-5.7 I get the following error. (When ...
1
vote
0answers
18 views
Debian (Buster) Nextcloud Error While Trying To Create Admin User - Access Denied
I am performing a manual installation of Nextcloud on my personal machine running Debian (Buster).
I've followed all of the steps of the instructions, up to the point where it wants me to complete ...
0
votes
0answers
91 views
Unable to start mariadb
I'm not able to start mariadb getting following error while starting db service.
root@server_name:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.3.9 database server
Loaded: ...
0
votes
1answer
39 views
Ubuntu 18.04 mariadb access error
I'm on ubuntu 18.04, i have installed maria-db,
maria-db is running with the command:
sudo service mysql status
but when i write this command:
sudo mysql -u root -p
ERROR: i get this error:
...
1
vote
0answers
25 views
How I can detect whether the database layer is either mysql or mariadb using only netcat
Sometimes on docker entrypoint files I need to detect whether the database layer is either mysql or mariadb in order to provide the correct configuration for my application whilst I develop docker ...
0
votes
0answers
63 views
Accessing to Mariadb database with telnet from LAN
System is Debian 10 upgraded from Debian 9.
MariaDB version is mariadb Ver 15.1 Distrib 10.1.41-MariaDB
Server machine running telnet command responds like this
telnet localhost 3306
Trying ::1...
...
0
votes
0answers
22 views
Mysql master/slave promotion of resources with Pacemaker not working
I'm trying to get a master/slave setup working with Pacemaker. However, I ran into a few problems. For some things I found a solution. I would like to have some feedback on this, because the official ...
1
vote
2answers
91 views
Installing MariaDB 10.4 on Centos 7
I am experiencing some trouble with installing MariaDB 10.4 on Centos 7. The official mariaDB guide says that a new repo file MariaDB.repo should created in /etc/yum.repos.d/ with the contents of:
# ...
0
votes
2answers
46 views
Python to IPTables safest way of altering
Does anybody know what the safest way is to alter IPTables from Python?
For a schoolproject we're building a simple captive portal. When the user is authenticated (via python & mariadb) on the ...
1
vote
1answer
722 views
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 ...
0
votes
1answer
91 views
Connect to a mariadb running on host from docker
I am trying to install nextcloud on a pi. So i installed the docker container, and i can access the first visit page. So i want to use mariadb as database backend.
Then i typed:
host: 192.168.178.62:...
1
vote
2answers
120 views
How to find a package name and version by its library name and version using a shell command?
Is there a command that could give me a package name and version for a library?
For example, I want to get mariadb-libs version for libmysqlclient_r.so.16 library that is currently not installed, but ...
1
vote
0answers
19 views
Running multiple mariaDB instances in a safe-to-update way?
On a certain server, multiple instances of 'mySQL/mariaDB' have to be ran.
Using mysql-multi or other methods, one can define multiple mySQL instances. Each runs on its own port.
As such, this ...
1
vote
1answer
975 views
sudo apt-get update errors: how do I clean up my MariaDB installation?
Linux Mint 18.3 (based on Ubuntu Xenial).
I have looked at the other questions here, but I still don't know where to start about cleaning up my package lists and specifically MariaDB. Any links to ...
0
votes
1answer
149 views
InstantWP Alpine Linux - repository tag for world dependency 'apk-tools@edge' does not exist
I am using InstantWP which installs a virtual server running Alpine Linux. InstantWP is for running a local version of Wordpress. It has MariaDB 10.1 installed, which isn't the latest version of ...
1
vote
0answers
43 views
How can I separate MariaDB's mysqld from MySQL 8's mysqld process to solve A mysqld process already exists error?
My goal is to have MariaDB 10.1 and MySQL 8 on the same Ubuntu 18.04 server.
I was able to setup MySQL 8 successfully, and got stuck almost at the end while setting up MariaDB following this guide:
...
0
votes
1answer
21 views
How can I purge a mysql setup
I installed mariadb-server-10.0 and php-mysql with the following.
sudo apt install mariadb-server-10.0 php-mysql
I setup with sudo mysql_secure_installation
I created a database for WordPress with
...
1
vote
1answer
278 views
MySQL&PHP - Aborted connection to db: (Got an error reading communication packets)
PHP version 5.6
I have a PHP program (running in CodeIgniter 'CI_VERSION', '2.1.3') looping through 100 items to process.
Apache (via Codeigniter) will give me 500 Error and no indication anywhere ...
0
votes
1answer
85 views
SElinux configuration of symlinked /etc/my.cnf -> /app/program/my.cnf
Please advise me of whether it is possible to configure SElinux context in a way that MariaDB would pick it up.
current configuration:
ls -lZ /etc/my.cnf
lrwxrwxrwx. root root system_u:object_r:...
1
vote
1answer
90 views
mariadb.service - linking unit aliases mysql.service & mysqld.service - (why) is it necessary
I cannot find the originally site I found how to set up MariaDB on linux.
Dependend on that tutorial I wrote an ansible playbook. While refactoring my playbooks I found those two tasks.
- name: ...
1
vote
1answer
446 views
Manjaro MySQL - mariadb.service fails when trying to start
When trying to start MariaDB with systemctl status mariadb, I get:
● mariadb.service - MariaDB 10.3.15 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor ...
0
votes
0answers
30 views
Mariadb running out of memory
I have an old web server that's been running for some time, with regular updates. For the last month it's been crashing every few days. I tracked it down to:
$ dmesg
Out of memory in UB 136: OOM ...
0
votes
2answers
33 views
Why is MariaDB rejecting my SQL Backup?
I had to rebuild my Linode to Debian 9 since I couldn't get the sources from my previous question to work.
I used this setup guide to reconfigure and reinstall everything to the new Debian ...
1
vote
1answer
190 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
618 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
211 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
96 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
11 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
63 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 ...
1
vote
0answers
179 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
162 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? ...
6
votes
1answer
4k 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
530 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 ...
4
votes
4answers
3k 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
399 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
47 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
1answer
110 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
2k 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
91 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 ...
1
vote
2answers
339 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
495 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
457 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
99 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
2k 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
809 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 ...
2
votes
0answers
194 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
654 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
507 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
358 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 ...
