The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
1answer
17 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
19 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. ...
0
votes
0answers
11 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
22 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
242 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 ...
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 ...
0
votes
1answer
45 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
55 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 ...
1
vote
1answer
942 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 ...
-1
votes
2answers
108 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 ...
1
vote
1answer
137 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
0answers
99 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
0answers
95 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
242 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 ...
0
votes
1answer
98 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 ...
2
votes
1answer
121 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 ...
3
votes
1answer
5k 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
3answers
432 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 ...
0
votes
1answer
107 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 ...
0
votes
0answers
315 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 ...
0
votes
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
29 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 ...
0
votes
0answers
414 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
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
2answers
41 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 ...
0
votes
1answer
649 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 ...
2
votes
1answer
9k 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 ...
0
votes
1answer
328 views

Disable MySQL startup arch

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 ...
5
votes
2answers
6k 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 ...
3
votes
2answers
528 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 ...
0
votes
1answer
584 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
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 ...
1
vote
2answers
565 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 ...
2
votes
2answers
595 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 ...
6
votes
1answer
21k 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 ...
3
votes
2answers
5k 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) ...