An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
0answers
50 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
111 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
94 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
32 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
331 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
78 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
82 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
38 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
14 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
91 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
84 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?
3
votes
2answers
2k 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
160 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
108 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
177 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
38 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
33 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
519 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
103 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
88 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
165 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
129 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
2k 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 ...
0
votes
1answer
78 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
45 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 | ...
2
votes
2answers
63 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
161 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
141 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 ...
3
votes
1answer
4k 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
660 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
2k 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
357 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
174 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
54 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
173 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
142 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
424 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
433 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
214 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 ...
0
votes
3answers
167 views

How to know list of applications installed in my server? [closed]

I got one LINUX server in which Oracle LINUX 5 is installed. I have installed MySQL 5.1.73-community version. Now, I have to configure the variables. When I checked available memory through cat ...
3
votes
5answers
1k views

bash restart mysql when it gone run well in SSH part, but not in cronjob

My system is centos 6.5, I write a simple bash shell to check if mysql is crashed, restart service again. I put it in /home/myspace/mysql.sh chown root:root /home/myspace/mysql.sh then run every ...
0
votes
0answers
156 views

MySQL 5.1.73 in Oracle LINUX : Which is the correct mysql configuration file?

I have installed MySQL 5.1.73 manually by RPM on Oracle LINUX 5. When I searched configuration file - my.cnf I run below command and get list of multiple configuration files. $ locate *.cnf ...
0
votes
1answer
157 views

Automatic login for mysql used in CGI script

I have written a CGI script using bash which executes a MySQL query. For MySQL authentication , automatic login is used by supplying the credentials in .my.cnf file as shown below . # the following ...
0
votes
2answers
87 views

MySQL 5.1.73 - community edition : Where is MySQL configuration file?

I have installed MySQL 5.1.73-community edition in my Oracle LINUX 5 server. I am able to start / stop and execute MySQL commands. But, I am unable to locate the MySQL installation directory as well ...
5
votes
3answers
4k views

How can I upgrade MySQL in Debian using apt-get?

I'm using the Turnkey Linux virtual machine. The version of Debian in there is apparently on the "Wheezy" upgrade path (if that's what you call it). I'm not completely comfortable with Linux, as you ...
0
votes
1answer
160 views

Creating operating system (OS) user in Oracle LINUX

I am a user with sudo access. To install MySQL, I have to create an operating system (OS) user called MySQL. Can I create a user which also has sudo access on this machine?
0
votes
1answer
123 views

Installing multiple versions of MySQL on Oracle Linux

I have a Oracle Linux 5 server. I have to install MySQL 5.1 as well as MySQL 5.6. Is it possible to install both version of MySQL on the same machine? If yes, how can I achieve this?