MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
40 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 ...
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
101 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 ...
-1
votes
2answers
41 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 ...
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
votes
1answer
46 views

Lots of mysql processes log error too many open files

I'm having problems with a CentOS server thats running slowly, htop shows about 40 lines of this which I think is causing the problem: 27218 mysql 20 0 17.7G 7449M 5088 S 0.0 46.8 0:00.24 ...
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 ...
1
vote
0answers
28 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 ...
0
votes
0answers
50 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
319 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 ...
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
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 ...
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 ...
1
vote
1answer
64 views

Allowed memory size of (whatever) bytes exhausted - Windows PHP

I have been trying to find advice on troubleshooting this issue for while but have been unable to find anything which relates to my situation. I am running PHP 5.6.0 on a brand new Windows 2012 R2 ...
0
votes
1answer
35 views

Remote login: Putty Works, HeidiSQL doesn't

I'm trying to login to my server with HeidiSQL. I prefer it to the console sometimes because of the GUI and quick import commands. This occurs on the same computer - Using Putty: [Server Host] port ...
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 ...
0
votes
0answers
57 views

how to do automatic failover of mysql / galera cluster

I have two mysql/galera clusters of three nodes each (two + garb node). The clusters are in separate DC's (dc1 and dc2) The cross cluster replication happens between node1-dc1 and node1-dc2 I want ...
1
vote
1answer
23 views

CloudSQL ERROR 2013 from GCE instance

From a GCE instance, I am executing the following from command line > mysql -udbase -p -DmyDb -hmyIp > > mysql> SELECT account, count(account) > -> FROM `headers` > ...
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
29 views

I switched my password hashing from md5 to ssha512, now exim4 won't accept smtp-logins

I have recently switched my password hashing from md5 to ssha512. This works fine with dovecot, so I can read incoming mail without problems. It does not work as well for exim4. Log output from ...
1
vote
1answer
35 views

Tomcat connect to Mysql load balancer

I want to connect tomcat with mysql in a load balanced way. Is this possible in Tomcat 7? What changes are required in the following configuration?. <Resource name="jdbc/TestDB" auth="Container" ...
1
vote
2answers
23 views

Postfix omits realm (@domain) when checking for smtpd pam+mysql authentication

I've trying to configure Postfix so users can send email through SMTP having a username and password. And I'm trying to store credential within a MySQL database. I've taken the path of saslauthd and ...
0
votes
0answers
11 views

import sql script throw error cannot find .cnf

I want to run a script, it's too large. Workbench runs it. But it reports an error: Preparing... Importing admin.sql... Finished executing script Could not open required defaults file: ...
1
vote
0answers
13 views

Adding mysql driver to tomcat openshift

I have deployed my war file on openshift tomcat. As suggested to deploy war file directly we need to remove the src and pom.xml before coping the war file in webapps folder. pre compiled java ...
0
votes
1answer
37 views

whats the best practice to do a long query like deletion of big chunks in mysql

On production servers I need sometime to delete a few 100,000s of rows . The query is optimized but deleting at once will cause servers freeze so I do it manually in chunks deleting for example 5000 ...
0
votes
2answers
48 views

Is this a MySQL injection or what?

I get this query in MySQL Worknbench -> Administration -> Client connection Running as localhost, so I guess is from the web page. SHOW VARIABLES WHERE Variable_name ='language' OR Variable_name = ...
1
vote
3answers
49 views

Is it possible to move MySQL to different hosting using replication?

I am considering switching to a new hosting provider and I would like to know if it is possible to achieve database (MySQL 5.6) migration without a huge downtime (= time to copy tens of GB of DB ...
-1
votes
1answer
37 views

PHP/APACHE and MySQL SERVER Setup [duplicate]

I'm about to setup a server hosting MySQL, Apache/PHP, File Uploads, and probably CCTV Storage. Planned Personal Server Specifications: ASUS H97M-E INTEL i7-4790 2 x 4GB 1600MHz RAM ...
0
votes
1answer
21 views

roundcube password plugin not updating

Im trying to configure password plugin for roundcube and cant get it to work! When i change a password it always pops up a message " An error ocurred, Could not save new password." My main config ...
0
votes
0answers
60 views

Ubuntu: port forwarding, trying get remote access to MySQL port 3306

i've been trying to gain remote access to MySQL on a server. I am running into problems, i cannot seem to get the port forwarded, here are some of the steps i've made: i've told MySQL to listen to ...
-3
votes
2answers
37 views

Can Varnish be deployed to front end mariadb/mysql server pool? Or is varnish helpful only when frontending HTTP servers?

Can Varnish be used to front end a pool of mariadb/mysql servers? I see that it does not handle any non-http requests and gives 503 error.
0
votes
2answers
52 views

Cannot connect to MySQL on EC2 over tunnel

For security reasons we want to connect to MySQL running on EC2 over ssh. We have other servers where we do this with no issues, but for some reason on EC2 it's not working. The instance is running ...
1
vote
1answer
34 views

Cannot login to mysql with non root user from command line

I am setting up a mysql server and I am trying to create a non privileged user to login with for each database that I create. I can successfully login as root from the console but when I try to login ...
0
votes
1answer
67 views

Unable to connect to RDS instance from outside VPC (ERROR 2003 (HY000) Can't connect to MySQL Server)

I've created a VPC, and inside it an RDS instance. The RDS instance is publicly accessible and its settings are as follows: RDS settings The security group attached to the RDS instance accepts all ...
0
votes
2answers
88 views

enable binlog in MySQL on Ubuntu

How can I enable binlog in mysql? The documents say to start the server with --log-bin but when I do: service mysql start --log-bin=/binlog I get: start: invalid option: --log-bin=/binlog And ...
1
vote
1answer
223 views

Recover mysql database innodb 'table doesn't exist'

Our server crashed last week and we lost a lot of information. We were able to recover .frm files for the tables, ib_logfile0, ib_logfile1 and ibdata1 but no .ibd. I've tried the ...
1
vote
1answer
65 views

mysql local installation mysql_install_db error [closed]

I am working on a *nix machine and I don't have root privileges. I am trying to install mysql locally using this blogpost: http://www.thedance.net/~roth/TECHBLOG/localMySQL.html However, I am ...
0
votes
1answer
29 views

MySQL: Replication without MySQL table, add user to replicated database on slave [closed]

I have a MySQL master / slave setup. Only one database is replicated. (not mysql) So now i cannot add users on the replicated database on the slave. #1044 - Access denied for user 'root'@'%' to ...
-2
votes
1answer
42 views

Servers in different DC's - performance impact

Today Linode eat my nerves completely by shutting down main DB server for 25 minutes due to their internal network problems. Right today I was going to set up another one server at linode to set up ...
0
votes
1answer
61 views

MySQL table only replication (Master->Slave)

I've set up two servers (one master and one slave db). I want to synchronize one single table of a whole database live (or with a delay of up to 5 minutes) in only one direction. I wanted to try the ...
3
votes
0answers
97 views

Update Mac OS X Snow Leopard Server to Yosemite

I have a Mac Pro (Model Identifier: MacPro5,1) running OS X 10.6.8. The machine serves to the web a couple of MySQL databases (v. 5.0.92) as well as a Redmine installation (with a Subversion ...
1
vote
0answers
58 views

TeamCity Connection Timeout

I set up a TeamCity server yesterday, and it was working fine until this morning when I restarted it. I didn't change any settings anywhere, but I keep getting this message in the teamcity-agent log ...
-1
votes
1answer
80 views

SSH tunnel to MySQL running on FreeBSD (Heidi SQL)

I'm trying to use a SSH tunnel to access a MySQL-server running on a FreeBSD 10.1 server. These attempts are done with Heidi SQL (http://www.heidisql.com/). The SSH daemon on the FreeBSD server does ...
0
votes
2answers
106 views

Mysql doesn't start mysqld.sock is missing

After I rebooted my server, everything started up normally except for "mysql", i tried to start it up manually "/etc/init.d/mysql restart" or with "service mysql restart", it fails In log file it ...
0
votes
1answer
30 views

MySQL: Master/slave setup

I need to setup a MySQL master and slave, between an office and a webserver in a datacenter. The master will be in the office. What would happen if the internet connection would fail in the office? I ...
-1
votes
4answers
85 views

MYSQL - is LOCALHOST speedy than i.e. (domain) mysql.domain.com [closed]

I am interested, on some hosting(although they are paid hostings, for example, DreamHost. probably 000webhost too), in database server, you have to insert: mysql.domain.com (instead of: localhost). I ...
0
votes
1answer
379 views

Yum: php55w-common conflicts with php-common-5.4

I am trying to install mysqli on a CentOS machine using yum install php-mysqlnd.x86_64 on the command line but I keep getting the message: Error: php55w-common conflicts with ...