MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
14 views

How to write access command with credentials?

We had a third party company setup servers and built services for us years ago. But the relationship is strained now and basically they won't reply any email to us. We could find some legal help but ...
1
vote
0answers
7 views

RTC/UTC was innacurate on MySQL (MariaDB) server. I fixed it - was that bad?

I'm pinch hitting as an admittedly green server admin. I installed a bunch of security patches on a MariaDB server that had an incorrectly configured repo (not by me) and wasn't getting patches for a ...
0
votes
0answers
2 views

Starting MySQL/TokuDB with missing recovery log

I've lost TokuDB recovery log(HDD has died) and TokuDB won't even start complaining about missing recovery log: /var/log/mysql/error.log: ... [ERROR] TokuDB: Recovery log is missing (persistent ...
0
votes
1answer
18 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 ...
1
vote
0answers
26 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 ...
0
votes
0answers
17 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 ...
0
votes
0answers
9 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
21 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 ...
1
vote
1answer
18 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, ...
-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 ...
-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.
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
144 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 ...
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 ...
-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 ...
1
vote
0answers
68 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
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 ...
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 ...
1
vote
1answer
41 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 ...
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
16 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 ...
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 ...
-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
20 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
36 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 ...
0
votes
1answer
57 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 ...
0
votes
1answer
48 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 ...
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 ...
0
votes
1answer
36 views

Mysql innodb_buffer_pool_size in relation to innodb_buffer_pool_instances

I run a virtual server with an Owncloud installation on it. Now Owncloud has the problem that the way it's developed at the moment, each file upload causes a little MySql overhead. So is very ...
0
votes
2answers
109 views

How can I install MySQL 5.7.9 to Ubuntu 14.04?

I tried to install with these inscturctions, but installation installed version 5.5. $ sudo apt-get install software-properties-common $ sudo add-apt-repository -y ppa:ondrej/mysql-5.7 $ sudo apt-get ...
0
votes
1answer
17 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
0answers
31 views

MySQL replication - invalidating query cache entries (table)

We lately mved to MySQL V5.5 on CentOS release 6.7 with master and 2 slaves. Since then the replication process lags a lot behind the master with the line in the process list of: invalidating query ...
0
votes
4answers
66 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 ...
0
votes
1answer
25 views

MySQL [ERROR] Can't start server: can't create PID file: No such fie or directory

I'm having trouble starting mysql and mysqld. Output of sudo service mysql start command is mysql : Unrecognized service Same way output of sudo service mysqld start is nothing When I tried sudo ...
1
vote
0answers
12 views

Minimizing downtime during MariaDB Replication Setup [migrated]

I have the task of setting up MariaDB (10.0) replication from a master running in a datacenter to a slave running out in an AWS VPC. Reading up on the instructions on Setting Up Replication - MariaDB ...
1
vote
1answer
19 views

MySQL Error Code: 1017 permission denied

I have downloaded the German version of the Northwind sample database. I moved the folder to /var/lib/mysql and set the rights to drwxr-x---. Here is an output of /var/lib/mysql drwxr-x--- 2 mysql ...
0
votes
2answers
42 views

CentOS 7.2 Azure VM - MariaDB/Apache killing memory

I have an Azure VM with CentOS 7.1, Apache 2.4.6, and MariaDB 5.5. The VM has 2 cores and 3.5 GB RAM. The server is only hosting a small WordPress site with almost no traffic. For the past two days, ...
4
votes
1answer
70 views

Galera cluster (MariaDB) on Docker/CoreOS: second node doesn't work on first attempt

I'm trying to create an automatic deployment of Galera Cluster with MariaDB, running inside Docker containers on CoreOS. Software used: - MariaDB official Docker image, version 10.1.10 - CoreOS ...
0
votes
1answer
49 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
0answers
18 views

How to compare MySQL privileges granted to privileges used? [migrated]

I have inherited a MySQL server that has a user with far too many privileges granted but I believe not all of these are required. Is there any way to compare the MySQL privileges granted to the MySQL ...
0
votes
0answers
14 views

dovecot shared folders (acl with mysql) can't be subscribed

For some reason the folder Project Folders is not selectable. Practically every public or shared folder is not selectable. The Email client is Thunderbird. # 2.1.17: /etc/dovecot/dovecot.conf # OS: ...
-1
votes
0answers
26 views

Accidently mv / directory to public_html

We accidently moved / directory to public_html in centos first we though we did rm -rf / but thank god we did not. most of files are moved however public_html/var/lib/mysql folder is missing from ...
0
votes
0answers
14 views

same page, different load time on different server

I am completely new to server admin. I have built a large site (for one person to code) and have to do things myself. I have a site on a shared server and another on a managed VPS. The VPS server ...
0
votes
1answer
42 views

Adding MySQL user with different hosts in SaltStack

I have two servers running the same application with a need to access a database on one specific database server running MySQL. Both servers with the application should access the MySQL DB with the ...
0
votes
0answers
18 views

InnoDB file per tablespace

I am using following syntax to create innodb table: create table InnoDB_Test(a INT) DATA DIRECTORY='/var/log/storage/MySQL' INDEX DIRECTORY='/var/log/storage/MySQL' engine=InnoDB; I want to create ...
0
votes
1answer
33 views

Why is a command in init.d script ignored?

As part of my work, I manage a mySQL cluster composed of 3 Ubuntu 14.04 machines. All 3 machines should be identical. On machines 1 and 2, when I run sudo service mysql status, I get a status report ...
0
votes
1answer
22 views

nginx + php5-fpm + mysql too many queries per second?

I have a VPS Debian running a nginx webserver and 2 node.js servers, one with socket.io for suplying data for my website and another one for a bot. The socket server runs a lot of queries but I try to ...
0
votes
0answers
20 views

Can't connect to mysql instance

I started a second instance of mysql (5.7.9) on my server and configured the service to run this command: mysqld.exe --defaults-file="C:\mysql-5.7.9\bin\my.cnf" mysql579 In my.cnf I changed the ...
0
votes
0answers
17 views

How to Diagnose Random “Error establishing a database connection” with WordPress

I maintain a Linux VM in Azure which contains one MySQL instance and 8 databases within that instance. Each database is used by a WordPress front end also hosted in Azure App Services. When using my ...