An open-source, relational database management system.

learn more… | top users | synonyms

-2
votes
0answers
16 views

using mysqlimport on a large amount of csv files in a directory via bash scripting [on hold]

I have a directory with approximately 75 csv files in it that I need to mysqlimport into a MySQL database. The MySQL database does not have the tables created. The files: * The data is all numbers ...
0
votes
0answers
10 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
19 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
35 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
1answer
55 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
0answers
42 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
17 views

Port shown as online when no program is listening [closed]

I installed MySQL and noticed that the port is open. After trying to change some things in its config it still was, so I was trying to "close" the port via iptables, unfortunately it doesn't work as ...
0
votes
0answers
9 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
28 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
40 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
15 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
14 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
51 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
37 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
51 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
33 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
17 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
6 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
37 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
33 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
90 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
27 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
35 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
56 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
21 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
23 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
165 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
34 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
43 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
51 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
60 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
414 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
30 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
2answers
44 views

php-mysql not working

I'm running on RHEL6. I have installed php and php-mysql. <?php phpinfo(); ?> is working perfectly. But I can't connect to MySQL is there a way to confirm that php-mysql is not working on my ...
0
votes
1answer
33 views

how can I replace a record in my DB (mySql) by new record?

I have created a shell script to connect to a DB and INSERT IPs and MACs from dhcpd.log file: #/!bin/bash dhcpLogFile="/var/log/dhcpd.log" NumberOfLines=$(awk '/DHCPACK/ { print $8} ' $dhcpLogFile | ...
1
vote
2answers
47 views

Is it secure to connect remotly to Mysql using shell?

I have created a shell script to connect to a DB and do some queries: #/!bin/bash ... ... mysql -h remote -u root --password='pw' MatchingDB some SQL queries My question is : Is this connection ...
0
votes
1answer
35 views

how to ignore a MySql error and go on to the next query?

I have created a shell script to connect to a DateBase and INSERT IPs and MACs from dhcpd.log file by connecting to the DB only once: #/!bin/bash dhcpLogFile="/var/log/dhcpd.log" NumberOfLines=$(awk ...
2
votes
1answer
63 views

how to Connect to Mysql only once?

I have created a shell script to connect to a DB and INSERT IPs and MACs from dhcpd.log file the scripts worked properly: #/!bin/bash #Defining Variables dhcpLogFile="/var/log/dhcpd.log" #Begin Code ...
2
votes
1answer
745 views

Anyone know a good gui to MariaDB? [closed]

I'm using MariaDB instead of MySQL in Slackware 14.1, and I need a graphic manager like MySQL Workbench. Can anyone suggest me something? I tried using MySQL WorkBench but it could not connected with ...
0
votes
1answer
60 views

PHP on centos 6 not working

I have installed PHP, MySQL, Apache on CentOS 6, now I have restarted the Apache and mysql, to test PHP i have created a index.php on /var/www/html/test/ now once i go to localhost/test/index.php then ...
2
votes
3answers
552 views

MySQL Workbench Cannot start SSH tunnel manager

I don't know why this error is happening when I try to connect by MySQL Workbench. Cannot start SSH tunnel manager. I'm using slackware 14.1 and installed all dependencies.    
0
votes
1answer
137 views

Creating MySQL database and user without password

I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: ...
1
vote
1answer
73 views

Modoboa 1.1.1 Deployment Errors

I try to install modoboa follow this steps: http://modoboa.readthedocs.org/en/latest/getting_started/install.html I installed modoboa with pip install modoboa Traceback (most recent call last): ...
0
votes
2answers
40 views

Yum- upgrading packages that are running

Is Yum designed in such a way (or is the underlying system) that you can safely upgrade a binary while it's running? For example, you have MySQL 5.5 and you run yum -y install mysql56-server to ...
0
votes
0answers
72 views

How Linux is implementing case sensitivity and what are its benefits over windows [duplicate]

Please do not mark it as duplicate ... I already read this post I am asking this question here because due to migration from Windows to Linux, I am facing multiple functionalities break. Linux is ...
0
votes
1answer
51 views

Can't seem to connect to my Debian Mysqli Server?

So I have a simple PHP script which I attempted to do something along the lines: $db = mysqli_connect("localhost", "root", "PASSWORD HERE", "database name"); mysqli_query($db, "SELECT STATEMENT ...
-1
votes
1answer
73 views

Why sudo ./bin/mysqld_safe & on Mac OS X 10.6.8 doesn't ask for password?

I get the following permissions from terminal: $ cd /usr/local/mysql $ ls -l drwxr-xr-x 41 root wheel 1394 29 Apr 00:55 bin drwxr-xr-x 4 root wheel 136 29 Apr 00:55 docs ...
0
votes
1answer
111 views

How to install mysql-server 5.6 on RHEL 5.8 (when MySQL-server 5.0 is already installed)

I want to install mysql-server 5.6 on RHEL 5.8, but when trying rpm -i or rpm -Uvh it complains that I already have version 5.0 on there. I am happy to replace, upgrade or install another instance. ...
1
vote
2answers
71 views

Allow remote MySQL to a specific IP - using CentOS 6.4

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 ...
0
votes
1answer
92 views

How do I make a tmpfs mountpoint persistent across reboots?

If I create a ram disk on cent os using tmpfs will it go away on restart? I know the data will go away (I would assume), but will it still survive a reboot? I am going to allocate a ram disk for use ...