MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
1answer
41 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
6k 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
1answer
12 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 ...
0
votes
2answers
43 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 ...
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
172 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 ...
-3
votes
0answers
21 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
999 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
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 ...
41
votes
12answers
41k 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
2k 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
920 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
29 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
663 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 ...
1
vote
1answer
32 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 ...
-1
votes
1answer
42 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
1answer
71 views

Migrate MUC (multi-user conference) data from Mnesia to MySQL in ejabberd

Ejabberd's mod_muc module supports db_type option, which can be either internal (Mnesia) or odbc (MySQL) to store MUC-related data. Is it possible to migrate from Mnesia to MySQL saving all the ...
0
votes
2answers
80 views

Using MySQL with Ejabberd

I'm trying to integrate MySQL into Ejabberd but I'm constantly facing problem with it. I'm working in AWS EC2 environment and I have 1 EC2 instance that has MySQL, Ejabberd and latest Erlang (Version ...
4
votes
2answers
239 views

How to fix Logjam vulnerability with MySQL

Since the latest openssl upgrade on my Debian server, my mysql clients are unable to connect and give the following message SSL connection error: error:14082174:SSL ...
0
votes
1answer
13 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 ...
8
votes
2answers
3k views

Mysql Slave stuck in “System lock”

My MySQL slave is spending a lot of time in Slave_SQL_Running_State: System lock. I can see that the system is currently I/O write bound, and that it is processing the log, although slowly. Show ...
1
vote
1answer
462 views

Cloning a VM to add a new MySQL Slave

I am in the process of adding a new slave to a replicated MySQL setup. I'm proposing the following process: clone one of the nodes to a new VM start it with no networking stop mysql change the ...
1
vote
1answer
15 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
26 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 ...
4
votes
1answer
987 views

Speed up MySQL inserts with partitions on MyISAM with unique key

I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on ...
0
votes
0answers
25 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
1k views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
4
votes
2answers
7k views

How to create a local backup of a remote Amazon RDS MySQL database?

How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be ...
3
votes
3answers
6k views

1286 - Unknown storage engine 'InnoDB'

I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
1
vote
1answer
21 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
3answers
3k views

How to recover the deleted table data from MySQL?

accidently the data from MySql databse table has been deleted, so kindly tell me any solution to recover it.
0
votes
5answers
2k views

MySQL my.cnf file not being read, Ubuntu 10.04 64bit

I've been researching this for a few hours with no luck. Basically it looks like my server's my.cnf file isn't being read at all. I've searched my server, and there's only one my.cnf file on it, ...
15
votes
6answers
12k views

How can I speed up a MySQL restore from a dump file?

I am restoring a 30GB database from a mysqldump file to an empty database on a new server. When running the SQL from the dump file, the restore starts very quickly and then starts to get slower and ...
9
votes
3answers
11k views

How to automatically kill slow MySQL queries after N seconds?

I am looking for a well tested bash script (or alternative solution) to do so, in order to avoid max_connection to be exhausted. I know that it is fighting the symptoms, but really need such script as ...
2
votes
2answers
4k views

403 Forbidden when trying to access a folder in document root of nginx

When I access index.php, it works fine. But on localhost/pset7, it gives a 403. Here is the permission log, -rw-r--r--. 1 root root 51 Jul 31 14:21 index.html -rw-r--r--. 1 root ...
1
vote
1answer
3k views

Postfix - mysql authentification failed

I'm playing with postfix configuration for the first time. I'm trying to set up the postfix user authentication through MySQL (I use the standard configuration with postfixadmin, courier, etc.) The ...
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 ...
1
vote
1answer
114 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 ...
0
votes
1answer
1k views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
1
vote
2answers
1k views

Heavy write to Galera cluster - table locked, cluster practically unusable

I set up Galera Cluster on 3 nodes. It works perfectly for reading data. I have done simple application to make some test on the cluster. Unfortunately I have to say that the Cluster fails totally ...
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
10 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 = ...