An open-source, relational database management system.

learn more… | top users | synonyms

3
votes
1answer
136 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 ...
3
votes
3answers
4k views

MySQL Linux Client Timeout/Keepalive

Is there a way to set a keepalive in the command-line MySQL client on Linux? Our network recently moved to a VLAN setup, and our systems department no longer has control of the firewall. The ...
3
votes
2answers
131 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 ...
3
votes
2answers
2k views

MySQL 5.1 to 5.5: all UTF-8 characters lost!

I decided to upgrade my Debian installation, and after some days using MySQL 5.5, I found that mysql prints garbage to the terminal intead of UTF-8 characters. I had a look at the SQL file that was ...
3
votes
1answer
3k views

How to enable an federated storage engine in the Debian MySQL package?

How would I enable an extra (in this case FEDERATED) storage engine in the mysql-server-5.1 package from Debian? I've installed mysql-server-5.1 via apt-get. But the SHOW ENGINES shows that federated ...
3
votes
2answers
333 views

Apt-get hangs on “Setting up mysql-server-5.5 (5.5.44-0+deb8u1)”

I'm on Debian 8 (stable) (Linux zenbook 3.16.0-4-amd64 #1 SMP Debian 3.16.7-ckt11-1 (2015-05-24) x86_64 GNU/Linux) and tried to apt-get update && apt-get upgrade yesterday. There was an ...
3
votes
2answers
220 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
3answers
2k views

rlwrap: mysql autocompletion not working

Normally, autocompletion works fine in mysql command-line client (mysql-client-5.5). I have a table called booking. When I type the letter b and pres TAB the name of my table gets autocompleted: ...
3
votes
2answers
662 views

High IO wait - How to determine the root cause?

I have a MySQL instance on two dedicated servers. One for the production, the other for the test platform. The 2 servers are pretty the same, the only difference is the RAID controller and the ...
3
votes
1answer
3k 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 <<< ...
3
votes
2answers
752 views

Error establishing a database connection; how can I determine whether or not these connections are real?

I've just run into a problem today with MySQL reaching its database connection capacity. The error I'm receiving is, Error establishing a database connection. When I try to access /phpma, I get this ...
3
votes
2answers
532 views

Trying to create tunnel to mysql through SSH

Im in a bit of a bind here. I have a client that want's me to set up his website, but he runs the server w/ SSH and CentOS 6.2 as it's OS. Now, I'm trying to add the sql server on Mysql Workbench for ...
3
votes
3answers
770 views

How to force rpm to check dependencies during upgrade?

We have a current version of our software that has a dependency on MySQL 5.1 and this is specified in the RPM requires. For our new version, we now require MySQL 5.5 and specify this in the RPM ...
3
votes
1answer
37 views

ssh port forwarding through pseudo terminal

Here's a situation: I do all my work on a Mac. There's a certain linux server 'server01' that provides access to another linux server 'server02' via a pseudo terminal So, to ssh into ...
3
votes
1answer
1k 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 ...
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 ...
3
votes
2answers
874 views

Installing php-cgi under Ubuntu for Cherokee web server

I have set up Cherokee web server on my server, and want to enable PHP and MySQL support for applications like Wordpress and phpBB. I have tried running these commands: sudo apt-get install php5 ...
3
votes
2answers
83 views

Debian 8 - Install lastest version of MySQL

After downloading MYSQL APT Repository at http://cdn.mysql.com//Downloads/MySQL-5.7/libmysqld-dev_5.7.11-1debian8_amd64.deb I ran the command dpkg -i libmysqld-dev_5.7.11-1debian8_amd64.deb ...
3
votes
0answers
1k views

How can I fully remove a tablespace from MySQL?

I have a MySQL database called camera_main_live, which I administer using Adminer. It is, to all appearance, empty. So when I want to add some content, I begin by running this script (with Adminer set ...
3
votes
4answers
5k 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: ...
3
votes
1answer
213 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 ...
3
votes
2answers
2k views

Install mysql workbench community on fedora 23

The mysql-workbench-community package is available for Fedora 22 in the official repos, but unfortunately not yet for Fedora 23. Trying to install the fc22 version results in mysql-workbench not ...
2
votes
2answers
13k views

df command not showing correct values

This is a RHEL server, I'm running a MySQL server on it, the database and log files (however, logging is disabled) are located on the /srv directory where plenty of space is available. Recently I had ...
2
votes
2answers
2k views

SFTP with Mysql user pass instead of PAM

Is there a way for people to log onto a debian server via sftp using just mysql database table as authentaction. IE not adding a user to the system? I know it can be done over ftp and TLS but i ...
2
votes
2answers
475 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 ...
2
votes
2answers
454 views

How do I set the mysql server character set in FreeBSD 8.2?

My mysql server's current server character set is latin1. My server is started on startup via rc.conf setting mysql_enable="YES". How to set my server to use utf8 as the server character set?
2
votes
2answers
5k views

How to allow mysql remote connections via particular interface

I have a 10.237.49.251 IP on eth0 and another IP on another interface How do I enable remote mysql calls on eth0 device?
2
votes
3answers
5k views

Where, in automysqlbackup, do I add mysqldump parameters?

How to stop automysqlbackup's cron.daily script -- as installed and configured from apt-get install automysqlbackup -- throwing the following error: mysqldump: Got error: 1142: SELECT,LOCK TABL ...
2
votes
1answer
2k views

Install MySQL from Bash Script

I'm coding a bash script to automate the process of deploying VPS servers but I'm having some trouble while trying to install MySQL from either aptitude/apt-get or yum, this is what I have so far: if ...
2
votes
1answer
483 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
6k views

How to install phpmyadmin 4.0 on Debian

Is there a way to install an up-to-date phpmyadin on Debian via apt-get? I only found a PPA for Ubuntu on the that you can install with sudo add-apt-repository ppa:nijel/phpmyadmin apt-get update; ...
2
votes
1answer
57 views

mysql console, keeps outputting garbled text if 'b' key is pressed

mysql -u username -p mysql> Now in the console whenever I press the b key the screen goes berserk with garbled text: Google doesn't help here. Edit: using ubuntu 12.10 with xterm or the ...
2
votes
3answers
213 views

Shell script executed with cron results in different size file than executed manually

I have a RHEL server that I am running a MySQL database on. I have a Bash script that executes mysqldump that creates a backup file. The backup file created when executing the script directly in ...
2
votes
1answer
435 views

Why does logrotate zip a file before it is closed

I'm using logrotate to rotate mysql output. When cron runs logrotate, I get frequently get an e-mail with the following content: error: Compressing program wrote following message to stderr when ...
2
votes
3answers
7k views

setting mysql root password in CentOS 7

How can I log into the mysql 5.6 command line client and reset the root password in Centos7? I read the following at this link, but it does not work: 1) sudo service mysqld stop 2) sudo service ...
2
votes
2answers
145 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 ...
2
votes
1answer
183 views

strings command printing some extra characters

I am trying to capture mysql traffic using tcpdump and converting it to text using strings command, but while capturing mysql traffic, I am getting some extra character at the end of each character. I ...
2
votes
1answer
1k views

mysql replication not working

I have two servers A and B I tried to setup replication between two servers for fixed dbs DBA and DBB but it's not working my configurations Tables are not getting updated why?? Master:(/etc/my.cnf) ...
2
votes
2answers
4k views

MySQL not getting started on linux

I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution. Downloaded the following files and installed all the rpms as under: MySQL-server-5.5.27-1.sles11.i586 ...
2
votes
1answer
1k views

How to script a database migration using SSH?

I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a copy of the live database to our local development ...
2
votes
2answers
352 views

List files that occur lexically after/greater than a given prefix (or, run database upgrade scripts in a proper order)

I'm trying to create a shell script that runs through a bunch of SQL scripts. I've these files: $ ls upgrade/ 01-foo.sql 02-bar.sql 02-baz.sql 03-foo1.sql 04-buz.sql And I've got the version of ...
2
votes
2answers
2k views

Postfix cannot find a MySQL shared library

I am trying to install Postfix with MySQL support. When I start or run the postfix daemon, it complains that it "cannot find libmysqlclient.so.18", which is in the directory /usr/local/mysql/lib, ...
2
votes
1answer
447 views

How to install a database dump via Shell Script?

I have a Mysql database dump. I want to install it with Hudson via a Shell Script to an external Linux machine. How can you take a Mysql script and run it inside a database on other machine? I know I ...
2
votes
1answer
20 views

Postfix database unreachable behaviour

I have a server running postfix and dovecot with a local mysql database to store virtual domains and users. I'm considering to move the database to another server and perhaps switch to using ldap ...
2
votes
1answer
127 views

How do I create a SSH user that can only access MySQL?

I want to set up an SSH tunnel to my MySQL database on a remote server. Can I create an SSH user that has only the minimum permissions that are strictly necessary to access MySQL, for example with a ...
2
votes
1answer
1k views

Permission denied writing to mysql log

I am just testing out a new Ubuntu (Vivid 15.04) install on Vagrant, and getting problems with mysql and logging to a custom location. In /var/log/syslog I get /usr/bin/mysqld_safe: cannot create ...
2
votes
1answer
182 views

Option --skip-slave-start Not Working with Systemctl

I just started with centos 7. I'm trying to get replication working and am attempting to start mysql without starting the slave (so that I can set the pointers as to where it's supposed to resume ...
2
votes
1answer
197 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, ...
2
votes
1answer
341 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' ...
2
votes
2answers
1k 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 ...