The tag has no usage guidance.

learn more… | top users | synonyms

10
votes
1answer
24k views

Anyone know a good gui to MariaDB? [closed]

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 ...
5
votes
2answers
7k views

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:...
3
votes
2answers
580 views

MySQL different database location [duplicate]

I do not have enough space on my root partition to store the database. $ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/ManjaroVG-ManjaroRoot 29G 21G 6.4G ...
3
votes
1answer
45 views

Automating Master/Master replication setup and configuration on two servers

I'm in the middle of writing a script to automate configuring MySQL replication between two servers (Master/Master replication), and was looking for some advice on a few things related to MySQL. The ...
3
votes
1answer
6k views

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 ...
3
votes
2answers
6k views

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) ...
3
votes
3answers
521 views

Installing Postfix conflicts with MySQL-server package

I had to install MySQL Server community on our server (team lead did not want MariaDB due to support or something). Therefor I removed MariaDB which in turn also removed Postfix. Now I need to ...
2
votes
1answer
31 views

Unable to apt-get upgrade mariadb but dist-upgrade works? why is this?

Unable to sudo apt-get update && sudo apt-get upgrade mariadb on debian 8.4, I have used this way of updating always, and this is the first time I see this message: The following packages ...
2
votes
1answer
2k views

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 ...
2
votes
1answer
10k views

Start Mysql/Mariadb in Fedora failed

failed to start mysql in Fedora 17. I am using root account to run the below commands and selinux is disabled. service mysqld start Redirecting to /bin/systemctl start mysqld.service Job for mariadb....
2
votes
2answers
621 views

How do I install postfix with MariaDB 10.1? …Or mailserver…?

I'm using CentOS 7 x64. Log: There isn't mariadb-libs for 10.1, not that I'm aware of. There is MariaDB-compat which as I found out seems to provide the same functionality and I have it installed, but ...
2
votes
0answers
16 views

PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) [duplicate]

I am getting this error message when trying to access a php page: PDOException: SQLSTATE[HY000]: General error: 23 Out of resources when opening file xxxx.MYD' (Errcode: 24) How can I solve this ...
2
votes
1answer
161 views

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 ...
1
vote
1answer
199 views

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 ...
1
vote
1answer
180 views

Reducing Number of MariaDB/MySQL Threads

So I'm running a MariaDB 10 database on a single core server; not super powerful, but then my needs aren't huge either. However, one thing I've noticed is that if I look in htop I have around 28 ...
1
vote
2answers
585 views

Using YUM for CentALT packages

Since CentALT isn't available anymore I can't upgrade some of my packages. Sure I can use a mirror for CentALT to get it working, but it only lists 'older' packages since it's not updated anymore. I ...
1
vote
1answer
73 views

How to install Software in redhat 7.2 using downloaded rpm?

Take MariaDB for an example. Package management tools like yum is good solution to install software and handle the dependencies issue for you. But in a primitive situation, without internet access, ...
1
vote
0answers
107 views

Can't MariaDB and Mysql install on the same machine?

I have to install Mysql as a metastore for the cloudera HUE. But on that machine, it seems MariaDB is on that machine. I use yum to install yum install mysql-community-server I got this error. ...
1
vote
0answers
146 views

Debugging Slow Queries in MariaDB/MySQL

I've set up a MariaDB server and everything is running well, with most queries executing in well under 20 milliseconds, but every so often a query will take half a second or longer (sometimes several ...
1
vote
0answers
321 views

MariaDB Dependencies issue after isntall/remove

I tried to "upgrade" MySQL 5.5 to MariaDB by removing MySQL altogether. Then I installed MariaDB 10.1 as follows: sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --...
1
vote
1answer
123 views

Can't start mysqld (mariadb) on Fedora, if put a backup into /var/lib/mysql

After some terrible actions, I had to reinstall my Fedora (was 20, became 22). Unfortunately, I was unable to made mysqldump, so I backuped /var/lib/mysql folder. Now, I'm trying to put in on the ...
1
vote
0answers
2k views

Error starting MySQL in a MariaDB Galera cluster in CentOS 7

I'm trying to setup a MariaDB Galera cluster following this tutorial exactly as it is, and I'm stuck in the Step 7– Initialize the first cluster node, I'm doing so with sudo /etc/init.d/mysql start --...
1
vote
0answers
31 views

Mariadb replaced by MySQL by Yum Ugrade

Yum Upgrade is replacing installed mariadb Server with MySQL Community Server in CentOS 7 (after the usual "is it OK?" question if "Y" is selected) While CentOS 7 installation is forced to install ...
1
vote
2answers
3k views

How do I install Exim and Horde on Centos 7 with MariaDB 10?

I can't find a guide for this (they are old and don't work) and I can't seem to manage to install it. I can't install Postfix because of its dependencies, so I'm going with Exim, which I installed ...
0
votes
1answer
365 views

Disable MySQL startup in Linux

I have KDE, and it has software to manage startup packages. But, I don't see any mysql, mariaDB or mysqld service. How can I disable or prevent the mariaDB and mysql daemons from starting ...
0
votes
2answers
34 views

MySQL Server monitor_20000 on node1 'not running' - HA Cluster - Pacemaker - Corosync - DRBD

I get this Error after finishing configuring cluster. And after trying to fail-BACK from node2 mysql_service01_monitor_20000 on node1 'not running' (7): call=20, status=complete, exitreason='none' ...
0
votes
1answer
135 views

MySQL logs are not working due to permissions

I am having a issue regarding permissions in MariaDB (MySQL) log files. I had setup logs files to be on /var/log/mysql but any time I restart the MariaDB server I can see the following messages logged ...
0
votes
1answer
14 views

Different DB Package Installation Calls

I've read/seen various DB installation tutorials and one thing often perplexes me... sometimes I see people install both mysqldb & mysqldb-server, or only one or the other. My question is: are ...
0
votes
1answer
700 views

MySQL (MariaDB) too many connections that don't close?

I have recently acquired my first VPS to run a mysql server for my minecraft server, I have setup MariaDB, it's using the default settings at present. I tested it last night with one plugin (...
0
votes
1answer
30 views

Can’t build and start docker container with mariadb

Host OS: Ubuntu 16.04 x86_64 Docker OS: Alpine Linux Edge Docker version: 1.11.0, build 4dc5990 MariaDB version: 10.1.13 I try to install MariaDB via Dockerfile and start it on entrypoint (...
0
votes
0answers
46 views

no MariaDB logs in journalctl

With jounralctl I see no logs for MariaDB, but for puppet every run. # journalctl -u mariadb -- Logs begin at Mon 2016-02-29 06:26:34 CET, end at Mon 2016-04-04 18:23:00 CEST. -- # systemctl status ...
0
votes
0answers
376 views

mariadb.service: main process exited, code=exited, status=1/FAILURE(Centos7)

I am using mariadb for my openstack (using CentOS 7). It was working well for almost a month. And it survived many reboots of my server. But last week there was an outage in server and since then I ...
0
votes
1answer
81 views

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 ...
0
votes
0answers
80 views

Creating users for RainLoop?

I have following this tutorial, and I am all set. I logged into to the Admin panel, and changed my admin password. I go to example.com/rainloop/ and cannot login. I guess I do not fully understand how ...
0
votes
0answers
356 views

HAProxy with Roundrobin working only on 2 of 3 MySQL servers, why?

Good day. I'm following this article to configure HAProxy to balance with roundrobin between 3 MySQL servers (db1, db2, db3) in a MariaDB Galera cluster (working perfectly). However I have a problem....
0
votes
0answers
515 views

Disabling strict mode does not take effect from the config file

I am trying to disable the MySQL/MariaDB strict mode in the variable sql_mode. But it doesn´t work. My my.cnf in section [mysqld] got this line: sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" ...
0
votes
2answers
42 views

MariaDB installation is showing random letters

So I want to setup MariaDB with nginx and I have in the past but for some reason on my debian 7 machine the MariaDB is all glitched out and shows random letters. Any idea why? Thanks http://prntscr....
0
votes
1answer
626 views

Moving from InnoDB to TokuDB

I'm running MariaDB 10.0.x and I would like to move from InnoDB to TokuDB. When using ALTER TABLE <> ENGINE=TokuDB; everything goes fine for the Wordpress websites. Unfortunately the Magento ...
-1
votes
2answers
173 views

MariaDB: Create and grant a new user using unix sockets plugin (passwordless)

I just installed MariaDB on Kubuntu 15.10. I am able to log in with the root user via the plugin that authenticates the user from the operating system. (This is new to me, so I am learning about it ...