MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-2
votes
1answer
39 views

MySQL sometimes shutdown itself at the midnight. Here is the log

My MySQL service sometimes shutdown itself at around 2AM of the day. I cannot find which part of this log file explain the cause. I host it on DigitalOcean. I am not sure is it because of their ...
0
votes
1answer
15 views

Why is the MYSQL variable innodb_file_per_table changed to OFF automatically in a OPENSHIFT online gear?

My application is on openshift online gear with mySQL 5.5. Recently I found that my mySQL database become very big quickly (few days increase 1G) without many operations. This made me try to do ...
5
votes
5answers
168 views

Starting a mysql server in my ${HOME}?

I'm not root on my server (linux) and this server doesn't currently run a mysql server as a daemon. Can I start a mysql daemon that would only work for my account and where the data/files would be ...
8
votes
2answers
559 views

How to redirect users to different servers based on their location?

I have a website which is developed by using ASP.NET and MY DB is MySQL. Currently it hosted in USA Servers. But When I try to access it near India dynamic contents are loading too slowly. It is ...
0
votes
1answer
169 views

Vagrant and MariaDB (provision)

I'm trying to create a provision file that installs MariaDB but it keeps failing. The provision looks like this: sudo apt-get install -y software-properties-common sudo apt-key adv --recv-keys ...
0
votes
1answer
2k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
0
votes
2answers
92 views

MySQL Ram Usage & Improve it with mysqltuner

how can i improve my server ram usage: Server Ram = 1GB after install the mysqltuner , I have this result : [root@server ~]# perl mysqltuner.pl >> MySQLTuner 1.5.0 - Major Hayden ...
2
votes
3answers
1k views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
1
vote
1answer
46 views

RDS to EC2 mysql replication

I would like to create a RDS mysql and to replicate it to an EC2 server so the DB will be local and thus the query time will be faster (the EC2 is a web server). According to the second paragraph here ...
0
votes
0answers
17 views

Amazon RDS Connection Denied via additional user

I just created a new database and user grant all privileges on that user. I don't know what's happening I can't connect by using that user always "Access Denied". But I change to RDS master user it's ...
0
votes
1answer
39 views

php and mysqld processes running for hours. Is this normal?

I have a Jenkins server, which periodically rebuilds a PHP/mySQL application. Every time new PHP code is pushed, this job drops all the tables in the corresponding database and then recreates them ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
0answers
13 views

Mysql query to retrieve the latest updates based on DATETIME for each parameter [migrated]

I have a station_data table where sensors from different weather stations report their data. Sample data: id(AI),station_code,parameter_code,value,date_time 1,1,1,1.234,2015-01-01 00:00 ...
1
vote
2answers
96 views

Zabbix_server.log says [2006] MySQL server has gone away

Environment CentOS 6.6, Zabbix 2.4 DB MySQL Galera cluster with 3 nodes mysql-wsrep-server-5.6-5.6.23-25.10.el6.x86_64 galera-3-25.3.10-2.el6.x86_64 Errors [Z3005] query failed: [2006] MySQL ...
0
votes
2answers
1k views

Apache2 Debian server falls. Out of memory

help me please with my apache problem. I got an droplet at DigitalOcean with 512mb of RAM (Debian). There are 3 sites on MODX CMS (works on php). Today morning as i think system discovered an out of ...
1
vote
2answers
2k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
-1
votes
2answers
40 views

Preventing a user from running a script that should only be run by a CRON job?

I have a contact form on my site which uses $HTTP requests instead of reloading on the form submit. It's a really awesome feature, but it also opens up some nasty doors. My contact form sends an ...
4
votes
5answers
7k views

How can I forward mail while saving a copy using postfix and mysql?

I'm migrating email from old Plesk installations to custom built Ubuntu server running iRedMail (postfix/amavisd/dovecot/etc). I'm using postfixadmin to administrate all domains and a mysql backend. ...
0
votes
1answer
11 views

Need to setup depend services of tomcat and mysql

Trying to set service depend on each other, the command which I am using for it is as below. dependencies are not setting up. seems like there is somw thing wrong with my command : sc config tomcat6 ...
1
vote
1answer
3k views

Can not restart mysql service after getting Error 2002 Can't connect to local mysql server

Starting yesterday, I'm getting this error when connecting to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I haven't touched my ...
4
votes
2answers
3k views

How to avoid mysqldump warning “Skipping the data of table mysql.event”

After a recent Debian upgrade on my LAMP webserver to Wheezy, mysqldump is throwing a warning: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. Events ...
1
vote
0answers
27 views

Connecting to MySQL - one client connection returns IP. The other clients return hostname

I have 4 servers that connect to a MySQL database. DB server running Ubuntu 12.04 client-server-1.mydomain.com 1.2.3.1 Ubuntu 14.04 client-server-2.mydomain.com 1.2.3.2 Ubuntu 14.04 etc... When ...
5
votes
4answers
4k views

Couldn't execute 'show events' on mysqldump

While trying to backup all MySQL databases with mysqldump I get the following error: Couldn't execute 'show events': Access denied for user 'user'@'localhost' to database 'performance_schema'
0
votes
1answer
131 views

Check services running on the server and restart them if they have stopped? (python script)

I am trying to write a python script which shows me the services which are running on my server. The thing is that mongodb keeps going down on the server and each time it happens I have to manually ...
0
votes
1answer
42 views

MySQL INSERTs on a database table block SELECTS in another database and in another table

I am using MySQL 5.1 on a Windows Server 2008 R2 Machine with 8GB RAM. I am updating 2 databases weekly. Both databases consist of MyISAM tables, and I run a script which performs the necessary ...
0
votes
0answers
49 views

How can I maintain logins to multiple hosts in phpMyAdmin

I'm attempting to setup phpMyAdmin to administer multiple MySQL servers from a single instance. I've modified the sample config that was included in ...
0
votes
0answers
7 views

Migrating a WordPress site has broken UTF8 encoding [migrated]

I am trying to migrate a WordPress site from one server to another, but on the new server I'm getting incorrect symbols in place of UTF8 (I assume) characters. I dumped the database using mysqldump: ...
2
votes
2answers
318 views

Connecting MySQL database remotely on a hosting provider secure?

My JavaFX Desktop Application is currently connected to a hosted MySQL database remotely on bluehost. I query "SELECT", "UPDATE", "DELETE" on my JavaFX Application and successfully done. My ...
-2
votes
0answers
15 views

Which db choose to concurrent work of 2000 connections and more? [duplicate]

Let's assume. I have some credentials data which plan to store in mariadb. And I have two php scripts: worker.php - must work 2,000 workers(it is condition!). This workers must use same db for select ...
1
vote
0answers
30 views

MySQL configuration stops at starting server [closed]

Currently trying to install MySQL 5.6.26 on a Windows Server 2003 R2 Service Pack 2, during the installation, it stops at the starting server step, tried following this question's accepted answer, but ...
2
votes
4answers
6k views

MySQL log file disable

My question is how to stop logs on mysql log_error = /var/log/mysql/error.log i have commented already. with slow queries too. But i have one more log file in /var/lib/mysql/hostname.log with ...
0
votes
1answer
1k views

MySQL port 3306 became filtered when configured with Keepalived on Ubuntu server 12.04 lts

I'm configuring two load balancer (lb01 & lb02) with keepalived for my two mysql server (db01 & db02) with standard port 3306. There is virtual ip address (192.168.205.10) to access it also ...
0
votes
2answers
2k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
2answers
65 views

IPtables on Linux for mysql server private interface

Looking to make a mysql database server for web-servers. The server has a public & private interface and I need some assistance writing the rules. I want to only allow SSH, mysql via private ...
1
vote
1answer
50 views

Is it possible to run 2 concurrent tcpdump with different options?

I need to run 2 concurrent tcpdump commands with different arguments/options. Why ? Because we wrote some long long scripts compatible with following options : tcpdump -ixenbr0 -s 400 -n -A 'port sip ...
0
votes
2answers
7k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
0
votes
2answers
1k views

How do I sync a subset of tables between two databases on the differnet mysql database server?

I have the main MySQL database which has the following columns in one of the car table: +---------------+-----------------+------+ |carId |name |model | ...
5
votes
2answers
1k views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is ...
0
votes
2answers
3k views

www-data@localhost using password NO

I use plesk 9.3, which is required by Serverloft. We are hosting on 24 websites on it. First, it said too many connection error, and then when I search the main problem. The problem is: Warning: ...
1
vote
0answers
195 views

Apache 2.4 prefork, MySQL 5.6 and 2GB RAM

I think I'm having problem setting up Apache24 correctly. Apache seems to taking up to much RAM, and I'm not sure how to configure it. The FreeBSD server is using 50% of it's swap space. We are ...
0
votes
1answer
1k views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...
2
votes
2answers
7k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
1answer
46 views

Recover sql database files without using sql server [closed]

My Ubuntu computer HD crashed, so I cant boot up anymore, I'm trying to recover my data from the hard drive by booting up using the live CD. I can access the crashed internal hard drive by mounting ...
42
votes
12answers
42k views

`mysql_upgrade` is failing with no real reason given

I'm upgrading from MySQL 5.1 to 5.5, running mysql_upgrade and getting this output: # mysql_upgrade Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed ...
2
votes
1answer
3k views

MySQL (MariaDB) crashes frequently

I recently migrated an old server running MySQL to a new VPS running MariaDB 5.5. I don't have too much running on the server (just a few PHP sites) and free memory seems to be OK, but the DB keeps ...
0
votes
1answer
942 views

MySQL per user monitoring

Is there a tool for monitoring per user MySQL usage? Like number of queries for example. I have been looking on Munin which I currently use, but did not find anything. A similar tool is the per user ...
0
votes
0answers
39 views

Capture all mysql requests/responses and caculate the response time using tcpdump

I need to capture all mysql requests/responses using tcpdump and after that need to find out which response related to which request in order to caculate the response time of each request. I used the ...
1
vote
1answer
3k views

Lost connection to MySQL server at 'waiting for initial communication packet', system error: 2

I've just spun up a new RackSpace VPS using Ubuntu. I'm normally using CentOS so forgive me for any Ubuntu newbie mistakes. I set up an SSH tunnel using Putty and tried to connect via SQLYog, ...
1
vote
2answers
1k views

Horrible PHP/MySQL Query Performance On Ubuntu Server 10.04

I just did a clear install of Ubuntu Server 10.04 with the standard LAMP config.. Then I made a small script to test insert speeds into a table with 3 columns. When I run the script on any of my ...
0
votes
2answers
684 views

MySQL fails to start with one config line change - innodb_buffer_pool_size = 1G

My curent config works great but my innodb_buffer_pool_size is too small as the database is very large. All I am changing in my MySQL.cnf is innodb_buffer_pool_size = 1G to ...