An open-source, relational database management system.

learn more… | top users | synonyms

-1
votes
0answers
25 views

Why configure doesn't search for mysql socket with --with-mysql=mysqlnd option?

I was building php-5.3 on arch linux recently. And one of the problems I encountered was that it didn't work with mysql right away: $ ./php -r 'var_dump(mysql_connect("localhost", "<USER>", ...
0
votes
3answers
48 views

Run an SQL script to create a Database via Linux Terminal

I am logging into my web server remotely using SSH and I'm wondering if there is a way that I can execute an sql script I have residing in a directory on that server in order to create a new database, ...
0
votes
2answers
45 views

Bash Mysql Command Substitution Login Failure

Bash and MySQL versions: GNU bash, version 4.2.25(1)-release (x86_64-pc-linux-gnu) mysql Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.2 I have a bash script that tries ...
0
votes
3answers
38 views

mysqld is not starting up anymore due filled disk [duplicate]

How to clean logs or find largest files and reduce the space? also i do not understand 1.7T is not even used in this critical moment. Mysqld is not running because 99% is used. # df -h Filesystem ...
1
vote
2answers
117 views

How to uninstall all related packages to a specific one? / Ubuntu

Recently I asked to my hosting provider to reload the OS to Ubuntu 12.04 64 bit minimal assuming minimal would have the minimum required packages installed, but I realized that mysql was installed so, ...
2
votes
1answer
25 views

Creating an SSH tunnel from a linux VPS to a web server database

I'm creating a server application that clients will connect to. The server application is running on an Ubuntu Server 14.04.1 VPS. The server needs to be able to connect to a MySQL database hosted on ...
1
vote
1answer
34 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. ...
3
votes
1answer
69 views

Can't start the MySQL service on a recently upgraded VM

I have a VM running Ubuntu server which I just upgraded to 14.04. The VM provides access to a MySQL database. However, after upgrading, the database refuses to start and I don't know enough about it ...
1
vote
1answer
60 views

How to configure the MySQL APT repo on Ubuntu, on a non-interactive shell?

I want to install MySQL 5.7 on Travis CI, which runs Ubuntu 12 virtual machines. I'm willing to use the official MySQL APT repo: wget ...
0
votes
1answer
34 views

Mysql database didn't connect through sqlyog or any other mysql software?

I can connect to a MySQL server through a browser and also I can show all database list through PuTTY. But when I try to use sqlyog or running the mysqldump command through PuTTY it shows this error: ...
0
votes
1answer
52 views

MySQL startup errors: ERROR 1005

My Debian MySQL installation gives this: Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306 Sep 25 13:38:09 xint01 mysqld: 140925 13:38:09 ...
2
votes
1answer
50 views

Why does mysql server packages have perl dependencies in linux distros?

I'm trying to clean out some unneeded packages from one of my gentoo boxes with emerge --depclean, and I thought I had a few perl modules installed that none of my wanted packages should require. So, ...
1
vote
1answer
36 views

Establish connection between Qemu Raspbian machine and Host

Objective: I would like to install several virtual (emulated) Raspberry machines on the laptop, connect them to each other and to the laptop. Afterwards I would like to send tcp packets from virtual ...
1
vote
1answer
290 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
29 views

Mysql Database files read access

Right now I'm trying to set read access to the files of one of my databases. I'm using debian with basic mysql installation so the database location is /var/lib/mysql. I want ...
0
votes
1answer
38 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 ...
1
vote
2answers
62 views

Ubuntu: where add a script executing SQL on machine start?

Each time Ubuntu is starting I need to run a script, which is running some SQLs. So I need run it after MySQL already started. Where should I put such script?
0
votes
1answer
197 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 ...
1
vote
1answer
403 views

Problems installing mysql on debian

I have a : user@Node:~$ uname -a Linux Node 2.6.32-042stab092.1 #1 SMP Tue Jun 24 09:10:28 MSK 2014 x86_64 GNU/Linux With a : user@Node:~$ cat /etc/debian_version 7.6 and I am having problems ...
2
votes
2answers
90 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
0answers
30 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
1answer
31 views

Execute MySQL commands directly instead of entering console first

PostgreSQL In PostgreSQL it is possible to execute commands without entering the postgres=# console by executing sudo -u postgres psql -c "\l" instead of entering the console first and executing \l. ...
0
votes
2answers
102 views

Editing /etc/init.d/mysql to remove mysql.sock automatically

I am running MySQL on a CentOS release 6.5 (Final) virtual machine. It is used for testing Joomla. The phyiscal host reboots frequently, which is fine. The VM, however, does not perform a clean ...
0
votes
0answers
43 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
1answer
65 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 ...
0
votes
1answer
47 views

Other Programs Cannot Connect To MySQL

So just recently when installing php-fpm, I had installed a few MySQL packages with it (I believe). I already had mysql installed. However now when any of my programs attempt to access the database, ...
2
votes
0answers
331 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 ...
0
votes
2answers
690 views

Can't start mysql service

Trying to start my mysql service. /etc/init.d/mysql start returns: Job failed. See system logs and 'systemctl status' for details. Further: systemctl status mysql.service returns: ...
0
votes
0answers
50 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 ...
1
vote
0answers
32 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 ...
0
votes
1answer
76 views

Unable to install yum and mysql,ssh

When I go to install mysql on CentOS 6,I get the following error: yum install mysql mysql-server Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached hostfile ...
0
votes
0answers
327 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
1answer
24 views

Immediately kill MySQL

I have a shared server that someone has compromised Wordpress. Is there an easy way to kill MySQL. I am stopping the service but it is just sitting and waiting.... to stop Shutting down MySQL ...
3
votes
1answer
464 views

How do I parse a string in bash into variables using a tab as the delimiter and preserve spaces?

I am in the process of writing a bash script to display various statistics, some of which come from a MySQL database. The pertinant code I'm having difficulty with is: read min max rows <<< ...
0
votes
1answer
423 views

Installing mysql-server in vagrant bootstrap shell script (how to skip setup?)

I did try to install mysql-server on my Vagrant Ubuntu 12.04 LTS virtual machine. When I did so, the setup auto-starts. I can see this in the Vagrant output: While not mandatory, it is highly ...
2
votes
1answer
96 views

mysql fail to start bash_completion errors

So after upgrading my debian system, mysql does not start anymore with command "service mysql start". I get: Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' ...
0
votes
0answers
61 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 ...
-1
votes
1answer
103 views

MYSQL : Connecting to mysql from : 127.0.0.1 + telling ip tables to allow only 127.0.0.1 for mysql port : Logic vs Common Sense

If i make 1 billion or 1 trillion queries to MYSQL database from 127.0.0.1 via port 3306. vs If i make same amount of queries to MYSQL database also from 127.0.0.1 via port 3306. but with ...
2
votes
1answer
313 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
0answers
23 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?
1
vote
0answers
47 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 ...
0
votes
3answers
86 views

How do you view a sql.gz file as plain text SQL from the command line?

How do you view a sql.gz file as plain text SQL from the command line? I want to read the SQL statements stored in a .sql.gz file, from the command line on the server. I've tried tar -xzvf, but get ...
0
votes
1answer
74 views

mysql jdbc connection issues in RHEL 6

I have setup the mysql database in one of the RHEL 6 servers. I would like to connect to this server's database from any other machine using a java program. How should I do it?
0
votes
0answers
27 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 ...
1
vote
0answers
2k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [closed]

When I try to start MySQL it says "failed!", so I try using mysqladmin ping and get the following: mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server ...
4
votes
1answer
301 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 ...
3
votes
2answers
70 views

How to make Cron run

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
71 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 ...
0
votes
0answers
35 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) ...
1
vote
0answers
13 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, ...