MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
44 views

nginx + php-fpm: 502 - when mysql is under load

mas :) I've got the following hardware 1 dedicated MySQL server (5.1x) 3 webservers with nginx and php-fpm (Ubuntu 12) and I'm running a small magento shop and several other low-traffic sites on ...
0
votes
1answer
32 views

VMware Host only network - Cannot connect to mysql between VMs

I've setup a virtual private network using VMware workstation 11. IPs are configured as so: Host: 192.168.129.1 Physical machine VM: 192.168.129.3 MariaDb database VM: 192.168.129.4 Web ...
1
vote
2answers
31 views

Moving mysql slave

I am trying to move MySQL slave from old pc to new. Original slave is MySQL version 5.6.12 same as new slave(MySQL is part of wamp 2.4). Replication works fine at old machine. But when I stop slave, ...
1
vote
1answer
28 views

Dovecot error reading mailbox: Can't expand ~/ for mail root

I want to configure dovecot to use mysql as users database. This is my config: # Authentication for SQL users. Included from 10-auth.conf. # # <doc/wiki/AuthDatabase.SQL.txt> passdb { driver ...
0
votes
0answers
21 views

Way to know what source is reading the most from MySQL Server(RDS)?

I have a mysql server which is registering very large bandwidth usage. I want to know what options I have for: Knowing what source is using the MySQL server most. (server ip?) What tables or queries ...
0
votes
1answer
21 views

mysql master to master replication with one slave

I have 3 servers Server A master to Server B Server B master to Server A and Server C Server C slave to Server B When I add table to Server A, it replicated on server B but not in Server C When I ...
0
votes
0answers
42 views

Diagnosing high Network Out (Bytes) by MySQL instance

I have an EC2 instance (r3.xlarge) with only MySQL running on it. At some points in time, this machine sends a sustained amount of information (at almost a rate of 400Mbps) for about an hour or more ...
0
votes
0answers
29 views

On Cloud: [Warning] IP address '' could not be resolved: Temporary failure in name resolution

I have configured mysql on cloud (azure) and can find lot of unknown IP's which are trying to connect with my db instance. I have configure my db users and bind it with network IP's. How can i stop ...
2
votes
3answers
89 views

The curious case of high 5 min load average

Looking for some expert advice here. I'm a first time sys admin on my own server and I can't figure the bottle neck in my server. I've been receiving tons of high 5 min load average alert ranging ...
2
votes
1answer
273 views

Can't open and lock privilege tables: Table 'mysql.user' doesn't exist - Trying to run second instance of myslq

On a Win7 box. I downloaded mysql-5.7.9 and I am attempted to run it as its own self contained instance along side another instance of an old version that is already running. I installed a new ...
3
votes
0answers
20 views

MySQL user suddenly loses some permissions [closed]

On CentOS 7, I have a MySQL (actually MariaDB) database user that needs all server privileges from a remote IP (to be able to use Navicat Premium to manage the database). Somehow every once in a ...
0
votes
0answers
24 views

Kamailio 4.3 replecing opensips 1.11

We have a customized sip routing script in opensip 1.11 now for good performance and stability we are moving to kamailio 4.3. So here am facing some issues related to kamailio module and funciotns ...
0
votes
1answer
72 views

Package mysql-server-5.6 is not configured yet

I had an issue installing MySQL 5.6 on Ubuntu 15.10. Basically loading the db server failed for the mentioned reason. mysql-server depends on mysql-server-5.6; however: Package mysql-server-5.6 is ...
0
votes
0answers
80 views

mysql won't start after upgrade to 5.6 - Permission denied

I'm running Ubuntu 14. Last week I was trying out some PDF tools locally and while trying to install pdftk it mentioned something about a dependency problem and needing to upgrade my 5.5 install to ...
0
votes
0answers
30 views

Modify MySQL information_schema (specially create_time) on AWS RDS?

I am trying to modify the create_time of an entire database, tables, etc. I have found that information_schema TABLES stores the create date of the tables on the column CREATE_TIME. Unfortunately ...
-1
votes
1answer
49 views

All MySQL databases appear to have disappeared

I'm running CentOS 6.7 with MySQL 5.1.73 and it appears as if all of the MySQL databases have disappeared within the past hour. MySQL starts up without any issues, however when running show ...
1
vote
1answer
43 views

mariadb mysql parallel installation apache and php

I'm trying to install mysql and mariadb on the same server as a parallel installation, each service on a different port. I installed mysql server using apt-get on a debian-based distro and then ...
0
votes
0answers
21 views

Do I need binlogs with a Percona xtradb cluster?

If I am running an XtraDB cluster, with no replication, do I need binlogs? They're enabled and chewing up disk space. I'm aware I can restrict their number using max_binlog_files, but I'm not sure if ...
-1
votes
1answer
94 views

YUM attempt to install instead of update MySQL packages

I have a doubt about the difference between install and Upgrade message with YUM Update. I have 2 servers with MySQL 5.6.25 installed on then "Server A" and "Server B". When I run the command: YUM ...
0
votes
0answers
42 views

change file system from ext3 to ext4 effict on MySQL

I have a situation where MySQL was installed in Linux with a ext3 file system. One table (InnoDB) reached the maximum size allowed for ext3 (2 TB) , insert statement gave "The table 'foo' is full". I ...
0
votes
1answer
16 views

service mysql restart with default options

I have Ubuntu 14.04 with MariaDB Galera cluster installed. My cluster has just one node now, so I restart the mysql service using: sudo service mysql restart --wsrep-new-cluster How can I set this ...
-2
votes
1answer
18 views

Rotate Old Files

I have a cron to backup 3 files every Hour, they are SQL backups - in the format name-name-bak-2015-12-1919:30:01.sql I need a way to rotate and delete the older ones say every 7 days? Thought of ...
0
votes
1answer
23 views

Get password for all failed MySQL logins

Im having issues trying to figure out what is the cause of a failing SQL login. The password seems correct to me, but it still isnt working. I want to see what exactly the user login is sending when ...
0
votes
0answers
7 views

Access denied error connecting to SQL DB with Postfix

I have no idea how to go about debugging this. I have created an SQL user called postfix and i have verified that i can log into the DB with this user and edit tables. I have configured postfix to use ...
-1
votes
1answer
37 views

Syncing MySQL backup with GIT tags

We have a large Yii2 / PHP application using MySQL database and versioned by GIT. The application is under continuous development as customer require new features. The database gets changed quite ...
0
votes
1answer
78 views

PHPMyAdmin “#2006 - MySQL server has gone away” during login

First: I've searched all over Google and although this looks like an infamous error, none is actually my case and hence no fix is available. OK so today I encountered this something weird: PHPMyAdmin ...
0
votes
0answers
16 views

Need to determine why my VPS rebooted - every few days, a sudden spike

Can anyone give some advice as to why my LAMP VPS server (running centos) reboots every few days? Well I know why - it's because the CPU and load suddenly spikes, but what causes the spike and what ...
0
votes
1answer
21 views

How do I install mysqli_ for PHP on Linux without affecting anything else?

I have root access to a server and it is currently running a live e-commerce site with lots of sales. The site currently uses mysql_ for everything. mysqli_ is not installed at all. I need to keep ...
0
votes
0answers
24 views

Migrating MySQL 5.1 to MariaDB 10

I plan on migrating my data from MySQL 5.1 to MariaDB 10. At the same time I will be upgrading hardware so I will have a completely new server. Is it possible to simply mysqldump from MySQL 5.1 and ...
0
votes
1answer
34 views

mysql won't start on FreeBSD

We recently picked up a client that has a site hosted on a FreeBSD box. The stack is FAMP. Things were chugging along just fine until recently mysql seems to have stopped running. There is no mysql ...
-2
votes
1answer
23 views

How can I reduce the Cache usage of MySQL and raise the free memory?

I currently have a virtual server with 12 GB of RAM and 8 CPU running many websites with Apache and MySQL. When looking in PhpMyAdmin monitor, I see the following resource usage graph: image -> ...
0
votes
0answers
22 views

High CPU due to MySQL after killing processes

On my linux server I ran into a problem this morning. I realized that after I killed all background tasks that were making ~200k database entries (1gb in size) throughout the night, my CPU usage was ...
-1
votes
1answer
14 views

Cacti and MySQL Queries

I am new to Cacti and am interested in using it to perform some queries against a MySQL database. I have a software which logs an error counter into a MySQL table, and I'd like to be able to graph ...
0
votes
0answers
68 views

Unable to start MySQL on CentOS

I've just installed a fresh version of MySQL on my CentOS machine. The problem I'm facing is that when I run this command: # service mysqld start I get in the console this error message: ...
0
votes
0answers
19 views

Mysql Server 5.5 is looping on start

Yesterday i had sadly to recover my server, that included all Databases in /var/lib/mysql . The huge issue is now that mysql wont startup and is some kind of looping,- it crashes and is getting ...
0
votes
1answer
34 views

Unable to install a fresh version of MySQL on CentOS

These are the steps, that I followed: cd /etc/yum.repos.d # go to repositories rpm -qf mysql-community.repo # get the name of old repositories to delete yum remove mysql57-community-release # it is ...
-3
votes
3answers
56 views

Mysql stopped suddenly and cannot be restarted

Here is what /var/log/mysql/error.log says [ERROR] /usr/sbin/mysqld: unknown option '--mysql/' Full log: http://pastebin.com/hhUY2LXi Mysql config: http://pastebin.com/cNMux19T Command to start ...
0
votes
2answers
61 views

How to open the MySQL port only to Amazon RDS for replication?

I have a MySQL database on a dedicated server, that I want to replicate to Amazon RDS to always have an up-to-date backup. For this, Amazon RDS needs to be able to connect to my master MySQL server. ...
-5
votes
2answers
55 views

Will changing the server time on a MySQL server (v 5.0) have any impact on the SQL Server? [closed]

I am dealing with a production system that has the time set as June 2009 . Will fixing this time to the current date break anything while the SQL Server is running? will there be any issues ...
-1
votes
1answer
65 views

MySQL: Why would I have to repeatedly FLUSH HOSTS after a few minutes? [closed]

I have a web system setup in AWS that we are building up to migrate an existing web app to. I have 2 VPCs: 1 for web and 1 for data. These VPCs are Peered and Security Groups are setup to isolate each ...
3
votes
1answer
69 views

AWS MySQL ERROR 2026 (HY000): SSL connection error:

I' am trying to connect to my AWS RDS MySQL instance with terminal on OSX El Captain, but I keep getting this error: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) ...
0
votes
1answer
29 views

Where is systemd script for mysql.service located?

I am actually using MariaDB (drop-in replacement for MySQL). I'm trying to make some changes to my systemd mysql.service file. I can see it exists because running sudo systemctl lists it and ...
2
votes
1answer
57 views

Best practices to backup mysql databases

This question concerns best practices for mysql backup with replication and large number of databases. I'm looking for your point of view and suggestions :) I - Current situation I have two ...
1
vote
0answers
33 views

Advice on management of large MySQL database [duplicate]

I've inherited responsibility for a 400GB MySQL database that is hosted in Amazon RDS. The DB serves an application that relies intensively on DB operations, so version releases frequently involve ...
0
votes
0answers
34 views

Galera Cluster: system requirements for an Arbitrator?

I'm planning the deployment of a Drupal website running on Linux (CentOS 7) and Nginx in IaaS. I will be using two nodes for HA, and each will offer the exact same services (Nginx, PHP, Redis, ...
0
votes
0answers
11 views

MySQL Remote Connection Sometime Timesout

I'm doing multiple remote connections from 3 different machines (more than 50-60 / second) to one machine where i have my MySQL Database (MariaDB 10.1). Most of the time it is fine and the mysql ...
1
vote
2answers
146 views

Can't run MySql > GLIBC_2.14 not found

mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /usr/libexec/mysqld: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib64/libstdc++.so.6) Starting MySql ...
0
votes
1answer
76 views

LAMP server with remote MySQL on CentOS 6.4 [duplicate]

I am pretty new to linux and LAMP setup. I want to setup a LAMP environment with AP on one linux server and M on a different linux server. I have a hard time finding a relevant document with such a ...
-1
votes
1answer
102 views

LAMP stack with apache and php on one linux server and mysql on a different linux server [closed]

I am pretty new to linux and LAMP setup. I want to setup a LAMP environment with AP on one linux server and M on a different linux server. I have a hard time finding a relevant document with such a ...
0
votes
1answer
40 views

Can not connect to Cloud SQL using local IPv6 address

I want to connect to a Google cloud SQL instance using its free IPv6 address instead of buying an IPv4 address. For that I looked up my IPv6 address and allowed it. I also looked up my routers IPv6 ...