MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

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

MySQL Database marked as crashed [on hold]

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
1answer
30 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
19 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
23 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
19 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
6 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 ...
-1
votes
0answers
21 views

MySQL / MariaDB will not start [closed]

I keep getting the error below and MariaDB will not start up. 150723 18:03:51 [ERROR] Incompatible header in messagefile /usr/share/mysql/english/errmsg.sys'. Probably from another version of MariaDB ...
-1
votes
0answers
15 views

Safe way to access phpmyadmin on EC2 [closed]

I have a website hosted on a xampp server on ec2. How can I grant permission for a specific user or IP to access phpmyadmin ?
0
votes
1answer
26 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
41 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 = ...
0
votes
0answers
12 views

ssh: connect mysql and filezilla [closed]

I have an Ubuntu Server v14 running and want to connect with the following over SSH: MySQL Workbench FileZilla Both programs keep giving errors that they can't get a connection. Connecting via the ...
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
35 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
14 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
17 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
30 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
36 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 ...
-4
votes
1answer
28 views

Moving Mysql data from an old server to a new one [closed]

I need to move a Mysql database from one remote server to a new one. I have remote desktop access to both servers and FTP to servers from my desktop. Each server will have the same edition of Mysql. ...
1
vote
1answer
31 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
30 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
65 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
99 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
35 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
25 views

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

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
38 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
33 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 ...
2
votes
0answers
40 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
27 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 ...
0
votes
0answers
27 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
45 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
26 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
70 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
116 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 ...
1
vote
0answers
42 views

Migrating web site from local PC to Windows 2008 R2 (IIS 7.5)

The company I work for is interested in moving a local Intranet web site I made for them from my test box to one of their servers. My testbox is running Windows 7 64x, and the server is running ...
0
votes
1answer
29 views

Unable to connect to AWS RDS instance

I have set up a AWS RDS instance. I am using "end point" as hostname to establish the connection via MySQL workbench. But the connection is failing. I am sitting behind a company firewall and as per ...
2
votes
1answer
87 views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
0
votes
1answer
32 views

MySQL slow connection

I am running a laravel application that is on a separate server than my MySQL database. If I run the query on the Mysql server it takes the expected 0.00 - 0.01 seconds to return. However when I log ...
0
votes
2answers
67 views

Can't Start/Restart MySQL. Even After Reboot

Can anybody please help me? I'm afraid of losing my data. MySQL just stop and when I try to restart or start it, I can't. When I look at the log file, I see the following info: 150712 6:36:15 ...
0
votes
1answer
73 views

Can't connect to mysql using ssl with compiled php [closed]

I have been bashing my head against a wall for a couple of days now. I just cant figure it out. I Run ubuntu 12 with plesk 12 and apache 2.2. I have tried compiled PHP 5.6.10 and PHP 5.6.11 with ...
0
votes
0answers
33 views

mysql replication stops without errors

I have this issue with master to master replication setup. Replication stops without errors, but when I make: slave stop; slave start; it is working again. mysql --version mysql Ver 14.14 Distrib ...
0
votes
0answers
5 views

ERROR 1045 (28000): Access denied for user root [duplicate]

All of my non root users can still connect and all of my websites and applications work fine. I recently discovered that I was no longer able to login as root when trying to login to phpmyadmin. I've ...
0
votes
1answer
40 views

unable to find driver - lamp debian

This is my php sample script: <?php try{ $db=new PDO('mysql:dbname=_mydb;host=localhost', 'root', 'xxxxxx'); }catch(PDOException $e) { echo "Error: ".$e->getMessage(); } ?> And I ...
1
vote
0answers
62 views

Advice Tuning my server

as many others I Learn many info from you in the past and now I manage to run server independently , now I am new to sql tuning and I been searching around the web a while now and tuning seems to be a ...
1
vote
0answers
48 views

JavaFX: Connecting MySQL database remotely on a hosting provider. SECURE? [closed]

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. I am using ...