An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
3answers
35 views

I can not install MySQL using yum on Centos7

I've installed centos7 recently, but, when I am trying to install MySQL using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
1
vote
2answers
27 views

Centos 7 - Recover mysql db from data files .frm and .ibd

I have migrated my operating system from Windows to Centos 7 without getting backup of mysql through mysqldump. Now I have mysql data files .frm and .ibd . I want to migrate them How can I migrate ...
1
vote
1answer
15 views

Xampp installer Error

I tried to install xampp ver 5.5.24 on Debian using terminal, after setting it to run as executables in permissions with. ./xampp-linux-5.5.24-0-installer.run I get Segmentation fault Then I ...
1
vote
0answers
44 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
2answers
683 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 ...
1
vote
2answers
19 views

How to pass password to mysql command line

I have MySQL password saved on a file foo.php, for example P455w0rd, when I try to use it: $ cat foo.php | grep '$dbpwd=' | cut -d '"' -f 2 | mysql -U root -p mydb -h friendserver Enter password: ...
4
votes
1answer
430 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 ...
1
vote
2answers
1k views

Allow remote MySQL to a specific IP - using CentOS 6.4 [closed]

I've spent a day now trying to find out how to allow remote MySQL to work for my other virtual server. This is proving very difficult so I'm hoping you guys could help me out ;( I've used the ...
1
vote
1answer
756 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 ...
0
votes
1answer
21 views

php server can't connect to the remote mysql server

We have two servers. server 1 and server 2 they are running with Directadmin / CentOS6 my plan: server 1 is running php and html, images...etc. server 2 is running mysql and phpmyadmin They are ...
5
votes
2answers
89 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 | ...
0
votes
2answers
2k views

What caused my CentOS 6.4 box to reboot itself?

I noticed that the MySQL daemon running on my CentOS 6.4 machine was suddenly not running anymore. I checked the MySQL log, but didn't see anything relevant: 121229 22:17:45 mysqld_safe mysqld from ...
2
votes
2answers
520 views

Import single rows from SQLite to MySQL?

I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
0
votes
1answer
44 views

Write permissions inside of shell script

I am using a Debian 7 Server. I created a shell script to be executed by crontab to save a mysqldump every day. mysqldump *database* -u *mysql-user* -p*mysql-password* > ...
0
votes
0answers
9 views

How to store output variable into database field? [migrated]

Here is my php code which runs shell_exec function to run linux based program. I am getting output. But I am not able to store it in to mysql database. Can anybody tell how to store $output variable ...
1
vote
0answers
13 views

Howdo i avoid older mysqlclient versions

i'm running some CentOS servers. PHP and MySQL are installed from 3rd party repos. My problem is that on all servers i always have php mysql clients running their version far behind the actual mysql ...
0
votes
0answers
391 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 ...
1
vote
1answer
927 views

How can I install mysql on an angstrom distribution?

I tried using a different distribution (debian) but the rest of my application did not work. I've tried opkg install mysql-client and opkg install mysql-server however I get the error Unknown package ...
1
vote
1answer
82 views

List available SQL commands at MySQL CLI

Is there a way to list available SQL commands at MySQL CLI? I mean if I type help at MySQL CLI I see various MySQL CLI specific commands like clear(\c) or tee(\T), but it would be handy to see a list ...
0
votes
1answer
29 views

MySQL: connection refused…coudn't find mysqld.service

I am trying to install MySQL onto a Fedora 14 VM. I successfully installed it using yum install mysql mysql-server after which I tried to start it with systemctl start mysqld.service which ...
0
votes
1answer
43 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> ...
-1
votes
0answers
34 views

MYSQL has randomly stopped and will not start, how can I get it back online?

Our Linux web server is Ubuntu that is running VirualMin, it has been up and running for months with very little issues and all of a sudden the MYSQL service will not start. The message being shown ...
3
votes
2answers
3k views

Cannot install mysql-server-5.5/the following packages have unmet dependicies

I'm using ubuntu 14.04. I tried entering mysql with the following command: mysql -u root -p and I got the following message: The program mysql can be found on the following packages: ...
0
votes
2answers
89 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
1k 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, ...
2
votes
2answers
5k views

Problem Starting MySQL on new Centos 6 build

I have a VPS with ChicagoVPS that's running Centos 6. Official version of the build is: Linux RedHat 6.5(Final 2.6.32-042stab078.26 x86_64) I followed this guide to add the repository and ...
2
votes
0answers
80 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 ...
2
votes
0answers
39 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
34 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 ...
1
vote
1answer
37 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 ...
2
votes
2answers
834 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 ...
0
votes
1answer
23 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 ...
2
votes
1answer
41 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
0answers
210 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
40 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 ...
0
votes
1answer
31 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 ...
0
votes
1answer
59 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 ...
0
votes
1answer
71 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
33 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
0answers
81 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 ...
2
votes
1answer
136 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 ...
1
vote
1answer
40 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 ...
0
votes
0answers
201 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
137 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
17 views

MYSQL dump of tables that start with docs_ from one server to another

The headline says it :) I would need script that dumps all tables from 'ads' database on different server(s2) starting with 'docs_' copied to my server(s1). Any hints? The reason that I need script is ...
0
votes
0answers
89 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
461 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 ...
0
votes
1answer
61 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 ...
2
votes
1answer
4k 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 ...
1
vote
1answer
35 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 ...