MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
7 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
8 views

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

I have 4 servers that connect to a MySQL database. client-server-1.mydomain.com 1.2.3.1 client-server-2.mydomain.com 1.2.3.2 etc... When connecting, one of the 4 returns the IP address of the client ...
0
votes
0answers
17 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
24 views

Parsing MySQL backup with awk

I'm currently parsing out a MySQL dump to feed my scripts with the following commands I've pieced together; awk -F "[()]" '{ for (i=2; i<NF; i+=2) print $i }' | awk 'length($0) > 30' | awk -F ...
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: ...
0
votes
0answers
15 views

numproc keep increase on VPS

I just bought a 1&1 M Virtual Server (Linux). I've installed tomcat and uploaded my java application ( web service ) on it. After a few http requests on this one (between 30 & 50), I end up ...
1
vote
2answers
270 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
13 views

MySQL configuration stops at starting server

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 ...
-1
votes
0answers
18 views

log into phpMyAdmin [on hold]

A few days ago I was logging into phpMyAdmin with this http://mydomain/phpMyAdmin and then on that page I would type in my password and username. But now that page isn't loading I looked at my ...
1
vote
1answer
99 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 ...
-1
votes
1answer
16 views

mysqldump access denied with WAMP on Windows 8.1 [on hold]

I have a local install of WAMP and I'm having problems using mysqldump. I use this code trough cmd.exe: C:\wamp\bin\mysql\mysql5.6.17\bin\mysqldump -umyuser -pmypassword mydbname > C:\Web ...
-3
votes
0answers
22 views

Cannot connect to MySQL server from a remote client [on hold]

Ubuntu 14.04.02 LTS MySQL Server version: 5.5.43-0ubuntu0.14.04.1 (Ubuntu) In my /etc/mysql/my.cnf, I have: bind-address = 127.0.0.1 When I do: mysql -uproducts -pxxxx use mysql; ...
0
votes
1answer
35 views

Recover sql database files without using sql server [on hold]

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
46 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
35 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
14 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
32 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
28 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
17 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
0answers
29 views

MySQL Database marked as crashed [closed]

I was following mysqltuner to optimize my database. After optimizing, and restarting the mysql server, i can't seems to login anymore. I ran the following: mysqlcheck -u root -p --auto-repair ...
0
votes
2answers
52 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
23 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
27 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
20 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
7 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
11 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
31 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
45 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
2answers
32 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
36 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
15 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
27 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
32 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
38 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
32 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
40 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
76 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
126 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
votes
0answers
9 views

Required hardware resources for a webserver [duplicate]

I am going to run an online store that is estimated to reach 300-500 concurrent users. The application is based on Yii framework. Please tell me the hardware required for running this store ...
1
vote
1answer
38 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
26 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
40 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
40 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
51 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
34 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
48 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
57 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
28 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
72 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 ...