An open-source, relational database management system.

learn more… | top users | synonyms

2
votes
0answers
528 views

MySQL read only error but permissions set and SELinux AFAICT correct

I am new to MySQL and Linux and because I had issues with an old MySQL version (5.1) I used mysqldump and installed MySQL 5.6. I changed the datadir location by copying everything to the new folder ...
3
votes
0answers
489 views

is THP good or bad for MySQL Server?

Linux kernel new feature called Transparent Huge Pages (THP) which is by default enabled on CentOS 6.x and above OS. Is THP good for MySQL DB machine? I am trying following to disabled THP but seems ...
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
1answer
186 views

Appending to a CSV file after obtaining datum from a database

I can [finally] extract data from the MySQL DB my_database_query="SELECT * FROM my_database.database" mysql -uUSER -p'PASSWORD' << EndOfFile $my_database_query EndOfFile How can I append this ...
1
vote
1answer
231 views

Unable to access another server over local network on Digital Ocean

I have two servers. Let's call them A and B. Both are running ubuntu server 14.04. B runs percona server. Now I do not have any firewall set-up on either servers still I am unable to connect to server ...
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 ...
0
votes
1answer
73 views

Rebooting Centos Servers configured with MYSQL Master/Slave Replication

Sometime ago we configured MYSQL replication on our main web server to another CentOS 6 server. All is working perfectly and we can see the replication is working fine. My question is how to safely ...
2
votes
1answer
526 views

Why does logrotate zip a file before it is closed

I'm using logrotate to rotate mysql output. When cron runs logrotate, I get frequently get an e-mail with the following content: error: Compressing program wrote following message to stderr when ...
0
votes
1answer
71 views

Looking for an email server that supports mysql ssl connection

I am trying to secure connections to my MySQL server. I have SSL set up but I am looking for programs that support a SSL connection to MySQL. Specifically I am currently looking for an email server ...
1
vote
2answers
918 views

import .sql file into a remote server from a local machine

I've created a database in the remote machine. Currently, the database is empty and I need to import using a backup(.sql) file. The backup file is in my local machine, it is a 40gb file. And the ...
0
votes
1answer
349 views

Mysql exited with status 1 and restarted every 24 hours? How to debug?

After upgrade, MySQL on Ubuntu 14.04 keeps crashing and is restarted every 24 hours according to the dmesg. I would expect to some reason for the failure in MySQL logs, but all are empty. Any ideas ...
1
vote
1answer
566 views

How do I troubleshoot these SELinux AVC errors?

Background: I have a CentOS 6 LAMP server. Recently the server has started to become unresponsive every few days. Originally, mysqld would throw a nagios alert and I would be unable to even ssh into ...
0
votes
1answer
424 views

How to move mysql database and mysql server to another machine

I am having Ubuntu 14.04 desktop in which i develop software. Due to some reasons my hard disk has developed many bad sectors. I want to move my mysql server software and all the databases to a new ...
2
votes
1answer
265 views

Option --skip-slave-start Not Working with Systemctl

I just started with centos 7. I'm trying to get replication working and am attempting to start mysql without starting the slave (so that I can set the pointers as to where it's supposed to resume ...
0
votes
1answer
431 views

Chromebook crouton LAMP

I'm trying to install a LAMP stack on Ubuntu through crouton on a Chromebook (Acer c720p). I was able to install the following packages apache2 mysql-client mysql-server php5 libapache2-mod-php5 ...
4
votes
1answer
574 views

When saving INTO OUTFILE from mysql on a systemd based system, the output file is grabbed by systemd — why?

I regularly run simple reports from a mysql (actually, mariaDB) database: MariaDB [acts]> SELECT resolution, title FROM acts ORDER BY resolution INTO OUTFILE '/tmp/acts-titles.txt'; Recently I ...
0
votes
0answers
431 views

Installing owncloud8 on CentOS 6

I'm trying to install owncloud 8 on CentOS 6 - the problem is that the default CentOS repos have only php 5.3 - but owncloud 8 requires php 5.4. So following this guy: How to install Owncloud on ...
1
vote
1answer
83 views

Not able to rename root user of MySQL

As part of security hardening, I wanted to remove/rename root user of mysql. While trying I get an error mysql.procs_priv doesn't exist. what is the significance of 'mysql.procs_priv'? Is it ...
1
vote
1answer
606 views

Debian - problems updating mysql 5.6

I just tried to update my dev database that runs on debian 7.8. Unfortunately it's now giving me the folllowing error: ... W: Failed to fetch http://repo.mysql.com/apt/debian/dists/wheezy/Release ...
0
votes
0answers
243 views

can't connect to remote host with MySQL…firewall problem?

I've granted privileges to thufir for remote access through the shell (correct?), but cannot seem to actually connect. The router firewall has SPI to off. I've disable the IPv6 firewall on the ...
0
votes
1answer
5k views

warning: mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623

warning: mysqli::real_connect(): Headers and client library minor version mismatch. Headers:50537 Library:50623 How do I do with it? I think I have a different version between mysql client and ...
1
vote
1answer
148 views

FreeBSD Reinstall postfix with mysql support

I have installed postfix using the ports tree without making modifications to anything. In my main.cf file i can't specify any 'Mysql:/' arguments because postfix does not have mysql support. Now i ...
1
vote
2answers
754 views

How to Subscribe a Bash Script as a MQTT Client

From my understanding: Client can be any device as long as it has an MQTT library running on it, from a microcontroller to a server, but must be connected to an MQTT broker over any network Broker ...
0
votes
1answer
57 views

Having problem with mysql dbdump when password starts with special character

I am trying to take a db backup with a php file that is running from a cronjob. It was running fine when I tested with sample db. But when I used the actual db there was an error. I am using ...
0
votes
1answer
147 views

Combine the output of while loop into tar

I'm trying to create a script that mysqldumps all my databases, creating an individual .sql file for each database and combines the output into backup-DATE.tar.gz. I've gotten as far as being able to ...
1
vote
1answer
233 views

Calculating RAM/Swap Space Requirements [duplicate]

I have been developing a MySQL database that makes some use of BLObs. This has now been transferred on to a virtual machine (VM) in preparation for going fully into the 'cloud'. However some of the ...
0
votes
2answers
275 views

Respawn MySQL on Ubuntu? Server ran out of memory, killed MySQL & Apache, MySQL didn't respawn

Just as above, I increased the RAM (it's a VM), but that doesn't give me a safety net. I was under the impression by default it should respawn, but that doesn't seem to be the case. *Ubuntu 10.04 ...
0
votes
2answers
276 views

MySQL won't start

I'm using a debian system. I could not start my mysql after the partition went full - I received the message "ERROR: The partition with /var/lib/mysql is too full!" I found a recommendation to delete ...
-1
votes
1answer
100 views

replace text in a file

are there any usefull command to replace all text that contain number and remove those number . Ex: myimages-202x250.jpg width="202" heignt="250" replace to myimages.jpg width="217" height="317" ...
0
votes
0answers
1k views

Can't start mysql server on OpenSUSE 13.2

Try to start the server: # service mysql start Output: Job for mysql.service failed. See "systemctl status mysql.service" and "journalctl -xn" for details. Output for "systemctl status ...
0
votes
0answers
298 views

Modifying SELinux settings to allow for MySQL to run on CentOS7

I'm trying to install MySQL 5.6 on Cent OS 7 with SELinux enabled and am trying to get past the error (in /var/log/audit/audit.log): type=AVC msg=audit(1424111345.853:558): avc: denied { execmem } ...
0
votes
2answers
810 views

how do I find the location of mysql drivers on CentOS 7?

MariaDB is installed on a remote CentOS 7 server. How can I find the location of the nearest equivalent to mysql-connector-java-5.0.8.jar in the server's file system? grep seems to only search ...
0
votes
1answer
180 views

Mysql: remote and local access

I have a gentoo where is installed a mysql server. I need a remote access to this server, so I have modified the option bind address in the file /etc/mysql/my.cnf bringing it from bindaddress: ...
0
votes
1answer
174 views

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7

Is there any way to install MySQL 5.1 and PHP 5.3 on Centos 7. I researched a lot but could not find any link which gives step by step procedure. Can someone please give me steps to be followed to ...
0
votes
1answer
229 views

mysql high availablity for LAMP application (ubuntu 14.04)

im trying to achieve HIGH Availability (HA) for a LAMP application(News Portal website) which might be of interest to many unfamiliar users.For files im using Glusterfs (replica) for redundancy ...
1
vote
0answers
19 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 ...
0
votes
2answers
5k views

What does “task mysqld:xxx blocked for more than 120 seconds” mean?

We are troubleshooting a MySQL issue where some queries are taking a very long time complete and I see many of these entry in /var/log/messages: Jan 28 05:52:15 64455-alpha01 kernel: [2529273.616327] ...
0
votes
2answers
10k views

MySQL service doesn't start

I have a CentOS 6.6, on the system there was a working Mysql and a mysql server already installed and a running mysqld service, but i needed a fresh install, so i did the whole removal through yum, ...
0
votes
0answers
412 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" ...
1
vote
1answer
33 views

Tool for migration of service configuration

Is there a tool that handles generic migration of config? For example if I have httpd, postfix, MySQL and users and groups data, is there a tool that can extract the config data for each service so ...
1
vote
1answer
833 views

Iptables rules for remote mysql server

I have a local mysql database on a centos server which causes a lot of load because there are a lot of queries made towards it. I want it hosted on its own server but i dont want every single ...
0
votes
0answers
297 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
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 ...
1
vote
2answers
2k views

Installing MySQL on CentOS throws error that cannot find mysqld.sock

I have yum install mysql in CentOS 6.4. Now, when I use mysql command, it throws the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
129 views

Selectively record commands and output from terminal to MySQL table

In some situations I would like to store complete commands and output from terminal sessions in a MySQL database. Ideally I would just copy the command and output from the terminal to my clipboard ...
0
votes
1answer
197 views

From Mysql query output to retrieve files in the file system and rename the files

I have to call a SQL query from bash that outputs 1000 rows of two columns File_Path (Eg., /opt/files/dest/2.bin) Name_of_the_file (Eg., fax attachment.pdf, invoice.docx... yes, there are spaces). ...
0
votes
0answers
7k 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
1answer
198 views

Apache / php config for production & staging & development

I have a server that has a production server a staging sever and a development server. I maintain code by changing it on the development server testing it. Then staging it and testing it and then ...
1
vote
0answers
196 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 ...
5
votes
6answers
14k views

How to install MySQL Workbench on Fedora 21

Is there an easy way to install MySQL Workbench on Fedora 21? I could not find a RPM package and failed at compiling it from source because I am using MariaDB and therefore was unable to install ...