An open-source, relational database management system.

learn more… | top users | synonyms

0
votes
1answer
322 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
333 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
883 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
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 ...
0
votes
1answer
448 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
625 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
2k 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
277 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
250 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
166 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
11k 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
432 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
244 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?
2
votes
1answer
53 views

MySQL Database Charset

I have just migrated a MySQL database to a new server using mysqldump. The charset of database is normally UTF-8 and everything was working fine on the old server but when we switched over to new one, ...
1
vote
0answers
32 views

Restore deleted Mysql Directory in linux [duplicate]

My MySQL directory has been deleted from directory /root/var/ by mistake, we need to restore it, Is it possible ?
3
votes
2answers
7k views

cronjob for automatic DB backup to date prefixed file

I am using the latest Linux Mint. I was wondering if it's possible to create a special cronjob for a database backup. In my /etc/cronjob file I have the following code: # Minute Hour Day of ...
0
votes
3answers
220 views

Where Is MySQL installed on My Machine?

What is going on, everybody? Recently I have installed MySQL server on my Debian machine using Advanced Packaging Tool, and I am curious where it is installed and how I can find all the source files ...
1
vote
2answers
1k views

WordPress installation with Docker

I have to migrate my WordPress installation to my own server in order to get SSL working properly. (It was originally on GoDaddy shared hosting, which doesn't allow for external SSL cert ...
1
vote
1answer
182 views

how to check if mysql table is used or an application accesses the table in shell script?

A shell script is doing dump for a mysql table, but before dumping the table I want to check if this table is used by any other application. If so, I want to wait and enter in a loop until the ...
0
votes
1answer
1k views

proftpd via mysql & web management of FTP users

I have installed prftpd and proftpd-mysql rpm on a linux machine. Intention is to have usermanagement of ftpusers via web. So I have installed proftpadmin from Here Now when I am adding the below ...
3
votes
1answer
109 views

How to interpret the following pattern of uptime data?

I have a small web server running mysql and wordpress which after a while appears to stop processing web requests. I can't even log into the server via ssh as ssh client times out when trying to ...
2
votes
2answers
65 views

Why does the root user have control over mysql directories but not show as a member of the mysql group?

Sorry if this is a duplicate. It seems somewhat similar to the question here but I think what I'm asking is a little different. I've got a CentOS 5.x box running with mysql on it. The root linux ...
0
votes
3answers
775 views

mysqldump should prompt for password

When I'm executing mysqldump command from localhost or from remote host, it's not prompting me for password. I want the password prompt even though I'm running it from remote or from local. On my ...
0
votes
1answer
564 views

dovecot mysql-connection error because of special charater in config

I successful set up my Server with froxlor, etc. but now I get errros with my mail delivery Agent because I use a '#' in my mysql-pw. I tried to escape it with a '\' but it doens't seem to work. :( ...
2
votes
1answer
121 views

Linux Heartbeat options possibilities

I would like to understand if my below scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup for ...
3
votes
1answer
2k views

MySQL server won't install to a new os (Debian, Ubuntu)

Today I wanted to install (on a new VPS with new OS) a MySQL server. I used this command: apt-get install mysql-server mysql-common mysql-client-5.5 I tried with Debian 7 (x64 and x86) and Ubuntu ...
1
vote
1answer
59 views

Can MySQL be malicious without PHP (or other language)?

I'm pretty sure the answer is "no", but who knows. Is a MySQL database able to initiate a communication with the server without any human action ? This server is disconnected from the exterior ...
1
vote
1answer
644 views

How to alter stored procedure in a MySQL database using the Linux command prompt?

I want to alter the stored procedure in my server machine. I'm uploading the codes via SSH Linux command prompt, I need to alter an existing stored procedure in my server. I don't have c-panel or ...
2
votes
1answer
2k views

Segmentation fault (core dumped) when try to run iptables rhel6

Im currently trying to set up a mySQL replication and i dont have a /etc/sysconfig/iptables. So I tried to install it with yum install. It showed the following output. Installed Packages Name ...
1
vote
2answers
322 views

Is it possible for a OpenVZ container to interact with a MySQL database on the host?

Say every container and the host itself has its own dedicated, external IP. Is it possible to do this without any problems? And is this really a good plan? Instead of hosting a database per ...
3
votes
1answer
11k views

Where does MySQL store its databases on Debian?

Our system crashed and we're trying to recover our data. The disc is fine, but the OS is gone, so I'm trying to get at the actual MySQL database files. Does anybody know where to look for them in a ...
2
votes
1answer
179 views

How do I avoid echoing password (two simultaneous prompts)?

The command I'm talking about is this: mysqldump -u root -p DB | mysql -u root -p DB2 And here's the output: Enter password: Enter password: MYPASS As far as I can tell, after I enter first ...
3
votes
1answer
191 views

Compile proftpd with MySQL authentication support on AIX

Edit 1: The problem seems to be related to MySQL component. because if I remove every SQL directives from config file, it does work on ftp/ftpes, sftp and ftps Edit 2: If I put an existing host ...
0
votes
1answer
150 views

why is my php script slower on debian than freebsd?

We moved a web-based application to a new server recently, but the new server seems to run slower than the old one. The old server was FreeBSD 7 with Apache 2.2, mod_php 5.3, and mySQL 5.1. The new ...
3
votes
2answers
14k views

Mysql query resultset in bash script

I am using the bash script to connect to the mysql database and execute a query. I use the below script to connect to the database and execute the query. #!/bin/bash Total_Results=$(mysql -h ...
1
vote
2answers
363 views

No package community-mysql-devel available

I'm trying to get this package because I need it to build software on CentOS 6, but I'm getting this error: No package community-mysql-devel available I'm logged in as root, using yum. Could it be ...
0
votes
1answer
386 views

Wordpress won't recognize the MySQL database

I want to install Wordpress on Archlinux but I have this error: Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I un-commented this line in ...
1
vote
1answer
102 views

Mysql import the most recent file from a directory

I have a directory with daily backups of my entire MySQL database. I want to import the most recent backup into the database. I know to import a backup I need to use mysql -u root -ppasswordhere ...
14
votes
2answers
2k views

Will my MySQL query continue to run even if my ssh connection drops?

I've connected to a server over SSH and logged in to mysql, and asked it to run a query (the results of which are dumped into a CSV) that could take well over an hour. Although I have instructed my ...
1
vote
2answers
1k views

MySQL refuses to uninstall

apt-get remove mysql-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: ...
2
votes
2answers
6k 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 ...
1
vote
2answers
761 views

Running `sudo /sbin/service mysqld start` causes system to crash

OS: CentOS 5.10 Service: Amazon Web Services Attempted to remove MySQL 5.0 and install MySQL 5.6 I had a server set up, and was going to use MySQL, but it was was set up with MySQL 5.0. Since ...
3
votes
2answers
189 views

How can I monitor a file that fully recreates during its run?

This is a follow-up question of Why are some file changes not shown in tail -f? With the use of capital F: tail -F I can monitor the output of tail -F ~/.mysql_history from the manual: ...
3
votes
1answer
130 views

Why are some file changes not shown in tail -f?

I tried to follow the mysql history file with: tail -f ~/.mysql_history in another window I entered as the same user: mysql -u someotheruser -p and none of the following commands are shown in my ...
1
vote
2answers
788 views

How do I restore my MySQL databases that were dumped from phpMyAdmin?

I recently did a clean install of Linux Mint 16 Petra on my laptop. Before I wiped the old system, I did a backup of all my MySQL databases by going to the Export tab in phpMyAdmin and dumping all ...
2
votes
1answer
696 views

redirect error out to standard output

I can save the error out in the same file as standard out. I have used this method below. The problem is that the error out is "always" shown at the top. In the example given below the error relates ...
2
votes
1answer
4k views

MySQL permission denied error even after setting security context for SELinux on VM

I have MySQL installed on CentOS (detail versions given below). My OS is a VM machine and not a physical machine, the directory /data/mysql is a local disk (virtual). I suspect I might need to do some ...
0
votes
1answer
4k views

MySql not accessible by root user

I have a local MySql server. It is started as I can access it with my local user like $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 Server version: ...
7
votes
1answer
3k views

OOM Killer - killed MySQL server

On one of our MySQL master, OOM Killer got invoked and killed MySQL server which lead to big outage. Following is the kernel log: [2006013.230723] mysqld invoked oom-killer: gfp_mask=0x201da, ...
0
votes
1answer
71 views

Getting Sublime + xDebug to work on Debian

I have been trying to get sublime and xdebug to work on debian, but have had no luck. I can't seem to find any debian specific guides. I have tried using the ubuntu based guides, but they don't work ...