An open-source, relational database management system.

learn more… | top users | synonyms

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

Can't use my old my.cnf from MySQL 5.5.38 in newer 5.6.19

Ok so I have been trying to upgrade MySQL 5.5 to 5.6. I have been given this set my.cnf file (see below). I was able to uninstall the MySQL 5.5 rpms and install the 5.6. When I reload the back up ...
2
votes
1answer
97 views

Linux Heartbeat options possibilities

I would like to understand if my below scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup for ...
1
vote
1answer
102 views

Cacti/rrdtool error -> Poller[0] ERROR: SQL Row Failed!, Error:'1033'

I have cacti working flawlessly on a centos 7.0 machine but I need it working on a centos 6.3 machine. I download the same version of cacti as what is on the 7.0 and I installed rrdtool from yum. ...
1
vote
1answer
108 views

How to set up Cron to run mysqlauditgrep command for 11AM on Friday

I am trying to set up cron to run the mysqlauditgrep command (its the MySQL 5.6 Utilities package). The mysqlauditgrep command is in bash. The command I am looking to run is: mysqlauditgrep ...
1
vote
1answer
582 views

phpmyadmin doesn't work after installing php5-mysqlnd

I am currently running into some problems with phpMyAdmin. I set everything up correctly and made sure everything worked. Then later after some developing on some pages I noticed I couldn't execute ...
1
vote
1answer
449 views

postfix: save all incoming Mails in MySQL DB and have all addresses Verified for big servers

I am new to all that server based stuff. New to Postfix and new to Ubuntu. I have an Ubuntu v-server with Postfix, PHP and MySQL installed. Also I have an own domain. So far, I managed to receive any ...
1
vote
1answer
94 views

Can anybody help me with MYSQL not starting

Here is a my error log file [localhost:local/mysql-5.5.15-osx10.6-x86_64/data] root# sudo localhost.err localhost1.err 130911 14:16:24 mysqld_safe Starting mysqld daemon with databases from ...
1
vote
1answer
83 views

MySQL 3.23 on Centos 6?

Don't ask why, just is it possible to install old mysql 3.23 on new CentOS 6.4 i386 or x64 version (same to me)?
4
votes
0answers
49 views

MySQL has over 95,000 connections but processlist is empty?

I have a server that is running mysql and it's using a lot of memory. I run: mysql > show status like '%onn%'; +--------------------------+-------+ | Variable_name | Value | ...
4
votes
0answers
379 views

I get the Error “mysqld dead but pid file exists”

I get the Error mysqld dead but pid file exists This happens every couple of hours. If I restart it works fine and then goes down again. [root@ip-10-0-0-149 log]# df -h Filesystem Size Used Avail ...
2
votes
0answers
375 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
43 views

Unable to install Mysql

When I install mysql on my Centos, I get the following error: Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile Could not retrieve mirrorlist ...
2
votes
0answers
147 views

mozilla sync server and mysql auth

Recently I updated my debian squeeze to wheezy. Unfortunately my firefox sync server (weave) stopped working. I saved the config files and downloaded the new version via hg. I already fixed some ...
2
votes
0answers
94 views

No communication services enabled following startup

I recently installed Parsix (Debian) on my system, and I've been struggling to figure out how to autostart my services. Of the list of services that don't run and should run are: ssh apache mysql ...
2
votes
0answers
1k views

MySQL socket and PHP (and other languages)

Background info I'm currently running CentOS (or Red Hat?). uname -a gives (I edited out my domain name) Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
0answers
10 views

Finding out the script causing MySQL failed connections

I see lot of lines in mysql.log Connect Access denied for user 'M'@'localhost' (using password: NO) I am sure I don't have such a user on my system. I need to figure out what script is ...
1
vote
0answers
42 views

I Need Find A Mac Address from a client connected to my Teamspeak

I have a dedicated server and from it I am running a teamspeak 3 server. In teamspeak server there is a client who need to be banned. I have banned him from teamspeak but if you change your windows ...
1
vote
0answers
58 views

How to debug the network issue in case of blocked database connections

I am trying to understand if my analysis of the below information is correct. For all the 3 scenarios listed here, port 80, port 3306 and port 22 are open in the server's firewall. Also, for all the 3 ...
1
vote
0answers
32 views

Ubuntu with LAMP+Mediawiki suffering spikes

I'm sorry if this question is off topic, but I'll give it a shot: I have a VPS running Ubuntu 12.04, a LAMP stack, and Mediawiki. After installing Mediawiki I noticed that my wiki site was spiking, ...
1
vote
0answers
2k views

mysqld dead but pid file exists

Webserver was running fine for weeks then suddenly: I can access, but I am unable to log into Webmin I can access Magento, a php-based storefront application, but I am no longer able to log in and ...
1
vote
0answers
47 views

Mysql user privileges : Only CREATE table

I am trying to create a user who will be able to manage all databases without the right to CREATE and DROP databases. I have been using the following link : ...
1
vote
0answers
121 views

Data loss prevention ( or recovery) in a MySql db in embedded systems

I have a little ( big ) problem with a MySql application that write on a SD card or a Compact Flash. After a data loss ( a power failure , for example) , if I try to retrieve the data of my db , it ...
1
vote
0answers
330 views

Amazon EC2 MySQL Failed to Start

I'm having issues starting MySQL after it randomly stopped working a few minutes ago. I'm getting this error while trying to connect: Connect failed: Can't connect to local MySQL server through ...
1
vote
0answers
253 views

Force mysqldump encoding

I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same : $ mysql -h right_server -NBe "SHOW ...
1
vote
0answers
1k views

Fedora Failed to get D-Bus connection

I have a VPS with fedora 16 installed. I have setup mysql and it was working a couple of days ago. Now suddenly when I try to start mysql I get the error: Failed to get D-Bus connection: Failed to ...
1
vote
0answers
537 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
0
votes
0answers
10 views

put second instance of mysql in autostart

System: Debian GNU/Linux 6.0.10 I have two instances of MySQL running on my Server. The default one is (probably) already set in autostart, since there are some files in the /etc/rc.X named S03mysql ...
0
votes
0answers
10 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
0answers
29 views

open Mysql connection for long time to execute queries in block

I am writing one script which execute bunch of queries in block. here block means version number, each version have different different queries. I write two shell script. 1 version.sh version.sh ...
0
votes
0answers
49 views

/usr/include/mysql/my_config_x86_64.h:653:2: error: #error <my_config.h> MUST be included first!

Hi I am trying to install this software on Cent OS. I am getting the following error. [root@localhost root-master]# make bin/rmkdepend -R -fsql/mysql/src/TMySQLServer.d -Y -w 1000 -- -pipe -m64 ...
0
votes
0answers
35 views

hooking up dovecot/postfix to mysql on CentOS 7

On a CentOS 7 web server, a java web application with a mysql database needs to be able to process incoming email. This means that each email message received by a specific email address needs to be ...
0
votes
0answers
96 views

completely clean re-install of mysql on CentOS 7

I have encountered problems with a mysql installation on CentOS 7. All the data is backed up, so I just want to completely erase every remnant of mysql on the machine and then do a clean install. My ...
0
votes
0answers
66 views

writing mysql output to file in CentOS 7

I am trying to run the following command from inside the mysql command line client in the CentOS terminal: SELECT Concat('TRUNCATE TABLE ',table_schema,'.',TABLE_NAME, ';') FROM ...
0
votes
0answers
29 views

Sharing MySQL data between Windows and Linux?

I'm trying to share my MySQL database files between a Windows and a Linux distro (Mint). I have a dual boot plus a separate data partition (NTFS). I've tried mounting the partition with ownership on ...
0
votes
0answers
67 views

How to properly install Apache, MySQL, and PHP on Ubuntu 10.4

I have followed a guide on how to install Apache, MySQL, and PHP on my laptop running Linux (Ubuntu 10.4) It appears I have it installed correctly but when I am not sure. I followed this guide here: ...
0
votes
0answers
34 views

How to get ids from xml file into mysql?

I've got 8 xml files and need to do some work on these records in mysql. What is a good way to get these IDs into mysql? <?xml version="1.0" encoding="utf-8"?> <Records> <Record> ...
0
votes
0answers
50 views

Updating data sets from Online databases/Webservice

I want to have an idea as to how to update the data regularly from the source, if its stored locally in your server or local machine.Lets say MySQL database. Source:It will be a webservice data ...
0
votes
0answers
80 views

Installing MySQL 5.6 Validate password plugin

So I have installed MySQL 5.6.19 Enterprise Edition and have installed the validate_password.so plugin. My question I have is, Does the MySQL password policy notify the user of what the requirements ...
0
votes
0answers
488 views

Running MySQL in a Docker container

So my ultimate end goal is to run a MySQL Docker container (say tutum/mysql from the public registry) and then link a Gitlab Docker container (say sameersbn/gitlab) to it, where both containers use ...
0
votes
0answers
82 views

Why does “Connection Failed: 2002” display randomly on my PHP/MySQL website?

I'm running CentOS 6 with Apache/PHP/MySQL. PS. I'm sort of a novice at Linux, but I did my best to gather info before coming here. I'm now a bit stuck. I recently upgraded PHP to version 5.5.12. I ...
0
votes
0answers
41 views

In Ubuntu, what is the folder in which MySQL's UDF should be installed?

I am using Ubuntu 14.04. I wonder where should I install binary UDF for MySQL. Is there any way to discover the path of the UDF directory? Is there a standard for this in Ubuntu?
0
votes
0answers
35 views

Mysql Cluster Data node not started

I am working on Mysql Cluster in Fedora. I have three Fedora virtual machine. One is Management node and other two are Data node. My Management node started but my Data nodes are not started. When ...
0
votes
0answers
45 views

MySQL Failing Randomly

I have a problem with my MySQL database. consider this scenario: [/] remorseful:root> mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) ...
0
votes
0answers
35 views

MySQL is running out of cache

I installed MySQL Workbench on Linux Mint 17. When I enter the i character from keyboard MySQL runs out cache in MySQL query display. Then MySQL shuts down. I would appreciate it if you could help.
0
votes
0answers
31 views

If a buggy application underperforms, it it possible server tuning could have no affect?

To set the stage, imagine if you will: A read-heavy Tomcat Application with MySQL on Red Hat Enterprise Linux with some problematic Java Class files which resulted in the application performing a ...
0
votes
0answers
196 views

MySQL 5.1.73 in Oracle LINUX : Which is the correct mysql configuration file?

I have installed MySQL 5.1.73 manually by RPM on Oracle LINUX 5. When I searched configuration file - my.cnf I run below command and get list of multiple configuration files. $ locate *.cnf ...
0
votes
0answers
76 views

Send data from file to rsyslog local0 facility

Is any possibility for logger to permanently get data from file - and send it to local0 facility? Why - I want to collect all data in database. For this - I'm use rsyslog-mysql. In it - I have ...
0
votes
0answers
360 views

Sending emails from AutoMySQLBackup from Linux Mint

I have set AutoMySQLBackup on a Linux Mint machine and I want to have the backups sent to an email, but I cannot make it work. I'm new to Linux environment and don't understand it very much. I ...
0
votes
0answers
131 views

Failure to install MySQL

I attempted to install MySQL using Synaptic but it failed to start on update with the following output: Selecting previously unselected package mysql-client. (Reading database ... 131143 files and ...