MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
16 views

Connecting to an AWS RDS behind a NAT with an SSH tunnel

I've set up a MYSQL RDS on AWS, in a private VPC behind a NAT. With Workbench, I can connect successfully from a remote client into the RDS no problems - so all of the RDS, the NAT and the security ...
2
votes
1answer
8k 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 ...
1
vote
0answers
22 views

SYN flood on mysql server

Consider this structure: DB <-TCP3306- WEB{1,2,3,4} All servers are CentOS 6/7 Web servers are running PHP (using php-fpm) that connects to the MySQL server. Occasionally, I get this error ...
7
votes
1answer
1k 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
14 views

trouble with change data dir on ubuntu mysql

Install zabbix on Ubunutu server with MSQL 5.6.27. After mount new part in /var/lib/mysql and copy all db files, mysql not started. What i done: 1) stop mysql 2) copy /var/lib/mysql to partition ...
1
vote
0answers
60 views
+50

Mysql listens to wrong port on restart

I'm working on a 'local' PHP project. It's a PHP app running in a Debian VM intended for use on the user's own PC. I have a couple of python scripts running as root services from /etc/init.d which ...
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 ...
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 ...
6
votes
8answers
1k views

Monitor MySQL Replication

What is the best practice for monitoring a slave to make sure that it is a) Still running b) Not too far being the master I would like to alert by email if it is behind, happy to write a script or ...
1
vote
1answer
1k views

Issue with aborted MySQL connections (error code: 4)

Some of the connections between my application server (Ubuntu, Apache, PHP) and my DB server (Ubuntu, MySQL) are failing with error code 4. According to the documentation error code 4 is: OS error ...
3
votes
2answers
10k views

Confirm that mysqli extension is not installed

Recently I discovered that mysqli extension is not installed in my server Centos version 2.6. I confirm it because I change the driver of db connection from mysqli to mysql and now works fine. So, is ...
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 ...
0
votes
0answers
8 views

xtrabackup/innobackupex: Full/Incremental backup advice

OS: Centos 7 Database: Mysql/MariaDB I have written my own shell script to produce Full and Incremental backups using innobackupex. I have read through the man pages for innobackupex and tried to ...
0
votes
0answers
20 views

Exporting privileges from Mysql - Something is missing

I used a little bash function to export MySQL privileges from a server (see http://serverfault.com/a/13050/238291). Works well, used it multiple times and never had an issue (although I do have to sed ...
0
votes
1answer
56 views

high mysql CPU usage more than %1500 on centos 6

I am running a high traffic websites on a Dedicated-Virtual 24GB RAM CentOS server hosted by the planet. Very often the server dies because of high CPU usage (%1500) When i check the running ...
1
vote
1answer
17 views

Small queries wait for large queries to resolve MYSQL PHP on Centos 6.5

I have a Centos 6.5, and I'm running Vaadin on Tomcat, This application has really heavy queries for reports and stuffs. My problem is, when I'm connect to MYSQL from PHP, when I made a small query, ...
3
votes
2answers
7k 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
votes
0answers
16 views

need to assign mysql root user to database with full permission [on hold]

I have a Centos 6 box with MySQL 5.6 There's a database control panel script I bought that requires full root access to MySQL. I can't figure out via CLI how to greant the mysql root user the full ...
0
votes
4answers
65 views

Sometimes: Unable to connect to host 127.0.0.1, or the request timed out. MySQL through Sequel PRO

I have been struggling with this issue for over a year now, and it’s really giving me a headache. I often experience I am unable to connect to the MySQL server through SequelPRO. If I ssh into the ...
-1
votes
0answers
17 views

Mysql master-master node recover after hdd destruction [on hold]

I want to setup MySQL master-master replication. But I can't figure out if it is possible to recover failed node from the remaining one after total hdd destruction.
12
votes
6answers
6k views

Forward local port or socket file to remote socket file

Quick question - I run two linux boxes, one my own desktop and the other my VPS. For security reasons on the VPS end I opted for socket connections to MySQL (/var/run/mysqld/mysql.sock). I know I can ...
1
vote
0answers
17 views

MySQL proxy authentication options

I have a farm of production mysql servers that are currently protected by restricted passwords. I would prefer to restrict access to these systems at network level, but have to account for the fact ...
0
votes
1answer
142 views

SQLSTATE[HY000] [1130] Host xx.xxx.x.xxx is not allowed to connect to this MySQL Server

I have 2 servers with digitalocean - web (nginx) and database (mysql) servers - and can't get a connection from the web to the mysql server. From what I've read in other SO posts on the topic, the ...
-4
votes
0answers
16 views

What are .frm , .myd , .myi and .opt files, and what do they contain (in MySQL)? [duplicate]

So it's clear to me that MySQL is a bit more complicated than just some CSV files and a nice tool to manipulate them. So in my Linux distro (Ubuntu MATE), I've found that that my MySQL databases are ...
0
votes
0answers
16 views

InnoDB causing mysqld to crash on Amazon Linux AMI

This Amazon Linux server is running a single WordPress site that is constantly crashing. The way to resolve it seems to be to run service mysqld restart and it resumes operation until it crashes ...
-1
votes
0answers
22 views

Access mysql database on EC2

How can I connect from my computer to my mysql database on EC2? I have checked the security groups for the instance, and made sure that my public IP is allowed in the security groups for inbound ...
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 ...
0
votes
1answer
24 views

mysql replicate-* data transfer from master

I have been playing with MySQL replication for a new project of mine. I am using row based replication. I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
1
vote
1answer
40 views

Postfix can't connect to MariaDB on 127.0.0.1

(Yes, this question seems very similar, but I understand why I get the message. What I don't get, and can't find any palpable information about on my own, is what to do about it. So here I am.) I ...
8
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
0answers
11 views

Using a py file as an API endpoint on a hosted server

Hello all geniuses out there! I am not sure if this is the right place to post this question, but here goes nothing! I am writing to you all for a bit of help and clarity involving how to set up an ...
0
votes
0answers
15 views

Socket.io w/ node.js + nginx +mysql + php5-fpm Memory Leak?

I have a Debian VPS running node.js socket.io server + nginx + mysql +php5-fpm and the socket server seems to freeze with no messages and no errors. I noticed that the memory usage grows over time but ...
0
votes
0answers
15 views

innobackupex: InnoDB: Log file ./ib_logfile0 size 14754304 is not a multiple of innodb_page_size

I did a backup using innobackupex: innobackupex /mnt/aws/backup It completed successfully: ... 160131 11:40:03 Executing UNLOCK TABLES 160131 11:40:03 All tables unlocked 160131 11:40:03 Backup ...
8
votes
3answers
4k views

Is there any way to disable grouping databases in phpMyAdmin?

If you have db names like test_db1 test_db2 phpmyadmin would create a group test. The group appears in the left side-bar with related databases displayed under it. How can I disable this feature?
1
vote
1answer
27 views

MySQL keeps crashing at unknown intervals

Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 160130 08:29:38 mysqld_safe Number of ...
1
vote
1answer
2k 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
2answers
2k views

Why can I not start mysqld_safe on Red Hat Enterprise Linux (RHEL)?

I downloaded mysql-5.1.44.tar.gz and installed it by issuing the following commands: $ ./configure $ make $ make install Everything installed without any error. Next, I tried to start the mysql ...
1
vote
2answers
3k views

Postfix cannot authenticate against SASL

My system is Debian 7 aka Wheezy with postfix, courier, and mysql installed. Courier works well and if I issue testsaslauthd -u user@domain -p password -f /var/spool/postfix/var/run/saslauthd/mux -s ...
10
votes
9answers
16k views

How to capture the queries run on mysql server?

We're trying to do some server performance debugging and I would like to capture a snapshot of the queries being run on our mysql server over a period of a couple minutes. I'm familiar with mysql's ...
0
votes
1answer
48 views

MySQL Daemon Lock issue

Last night, my MySQL server went down unexpectedly. On attempting to restart (with service mysql restart - I'm root) it merely hangs. With the mysql -u root -p command, I get ERROR 2002 (HY000): Can't ...
-2
votes
3answers
33 views

Linux mysql server 5.6 will not start, or restart

I have a problem with mysql server; it doesn't want to start do you have an idea thank you. janv. 29 10:51:15 clicshopping mysqld_safe[20076]: 160129 10:51:15 mysqld_safe Can't log to error log ...
0
votes
0answers
19 views

MySQL 5.7 under Debian Jessie with postfix-mysql

I currently have MySQL installed from the MySQL APT repository and am on the 5.6 branch. It comes with libmysqlclient18 and postfix-mysql requires it. If I want to switch to the 5.7 branch, APT will ...
0
votes
1answer
35 views

Mysqld.exe crases on startup with error 0xc000007b

I've just deployed a new VM on Microsoft Azure with Windows Server 2012 R2. It is identical to other two I have (it was created from scratch though, not duplicated or from an pre-existing image), all ...
5
votes
1answer
4k views

max_binlog_size & log-bin size

I have a problem with full disk -rw-rw---- 1 mysql mysql 1073741982 2012-07-03 18:14 mysql-bin.000034 -rw-rw---- 1 mysql mysql 1073741890 2012-07-04 14:39 mysql-bin.000035 -rw-rw---- 1 mysql mysql ...
0
votes
1answer
47 views

PHP 7 cannot connect to MySQL

I have compiled LAMP servers for hundreds of times. However I am facing issues with PHP 7. I compiled it properly, but it cannot connect to MySQL in localhost. phpinfo shows PDO and mysqli are ...
5
votes
7answers
24k views

How to undo DROP Table?

I accidentally dropped all tables. Can I restore back? I don't have the backup copy.
6
votes
2answers
2k views

How to pass input from one script into another using bash

I am writing a script where I am want to launch the mysql_secure_installation script and provide the appropriate answers at each prompt. I tried using echo like this: echo -e ...
0
votes
0answers
29 views

mysql-workbench installation error

I have ubuntu 14.04 and try to install mysql-workbench. and getting an error as The following packages have unmet dependencies: mysql-workbench: Depends: libgcc1 (>= 1:4.1.1) but 1:4.9.3-0ubuntu4 ...
2
votes
3answers
2k views

Centos MySQL optimization 4gb ram

I am using Centos 6 64bit on vps with 4gb ram. 1 wordpress website and 2 wallpapers script websites. Wordrpess have 10k visits daily. Site is slow. My.cnf # Example mysql config file for large ...
0
votes
0answers
51 views

Adding to tar archive /var/lib/mysql is it enough for backup restore task?

In every docker project, I have a backup.sh and restore.sh file I want to find a good way for backing up and restoring mysql backup using only ./restore.sh ${timestamp} My backup.sh look like ...