An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
25 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
36 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
0answers
63 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
94 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
73 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
21 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
29 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
48 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
39 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
35 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
35 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
166 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
133 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
27 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
29 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
48 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
198 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
63 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
133 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
52 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
45 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
77 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
161 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
18 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
40 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
61 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
41 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
24 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
493 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
167 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
58 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
53 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
26 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
10 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, ...
2
votes
1answer
53 views

mysql restoration process takes longer time

I have a Ubuntu 8.04 machine which has around 300 GB size mysql databases. I have dumped all the databases using the mysqldump command as below. mysqldump -u root -p --all-databases > file.sql ...
0
votes
1answer
48 views

Linux iptables DNAT 53306 to 127.0.0.1 3306

mysql real port is 3306。 I want public network using 53306 to visit mysql, and 3306 is not allowed access from public network. How to write the iptables rules DNAT 53306 to 127.0.0.1 3306?
2
votes
2answers
516 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
1answer
61 views

installing php-mysql on rhel6

I have rhel6 running on my server and installed mysql from Red Hat Enterprise Linux 6 / Oracle Linux 6 (x86, 64-bit), RPM Bundle. Now I want to host a php site on that machine. And when I run yum ...
0
votes
1answer
46 views

How to reconfigure PHP

We have a new linux server CentOS 6.5 with Plesk. Default PHP is 5.3.3, I have installed PHP5.4 & 5.5 on the server. I am a beginner on linux. Actually, I don't know how to install software on ...
2
votes
1answer
92 views

Mysql synonym drop and create

I am running into the issue that, when the script is run, the MySql section of it isn't working or is droping the synonym. Is there something else i need to put into the command to have it log into ...
1
vote
0answers
28 views

MySQL: Tab-completion not working [closed]

Tab completion in mysql is not working. I tried to start mysql with mysql --auto-rehash but it didn't work either. I also tried mysql> \# but autocompletion refuses to complete my commands. ...
0
votes
0answers
28 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
330 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
42 views

Mysqld_multi doesn't recognize groups

I am trying to configure a MySQL server to run multiple instances of the daemon (I wish to duplicate it onto different drives). I've been trying to use the mysqld_multi script. However the script is ...
1
vote
3answers
60 views

mysql database no space available

I was restoring a 200 GB database into a newly installed RHEL machine. However, while restoring I ran into no space available issue. Is it possible to change the directory where the databases are ...
1
vote
2answers
72 views

how to insert many similar records in mysql at a time?

we know that we can insert multiple records at a time using this query: INSERT INTO `TABLE1` (`First`,`Last`) VALUES ('name1','surname1'), ('name2','surname2'), ('name3','surname3'), ...
0
votes
1answer
74 views

Rooting Linux via mysql

I have a CentOS 5.6 x86 installed. I have full access to mysql but it seems I have forgotten Linux root password. How I can access the root via MySQL? Is it even possible? Update: MySQL Version is ...
1
vote
0answers
893 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 ...
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 ...