The tag has no usage guidance.

learn more… | top users | synonyms

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
23 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
29 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
220 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
32 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
57 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
41 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
49 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 ...
2
votes
0answers
143 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
61 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
88 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 ...
2
votes
1answer
3k 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
326 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
95 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
238 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
1k 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
28 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
53 views

How to access MariaDB on Debian Server from Win Machine on same network

I'm having trouble accessing my MariaDB server from my windows machine on the same network. When I try to create an ODBC connector from within MS Access using the local IP and the correct ...
0
votes
0answers
326 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
13 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
554 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
8k 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
287 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 ...
4
votes
1answer
5k 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 ...
2
votes
2answers
472 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
511 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
519 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
540 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
17k 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
4k 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) ...