MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
1answer
38 views

Managing multiple servers with database and apache [closed]

We are building a relatively simple setup, with multiple apache servers potentially behind a loadbalancer, with a single database server to serve a particular website that will in effect need to be ...
0
votes
1answer
221 views

MySQL CREATE command denied to user

I have a script system that refuse to be installed because of error that breaks installation. I tryied to import the data by import the data via .sql file at phpmyadmin and it still cant import. ...
1
vote
1answer
210 views

Postfix/Dovecot configuration with virtual users

I followed this tutorial for configuring Postfix + Dovecot with virtual users (in a mysql database) : ...
0
votes
1answer
78 views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
1
vote
1answer
218 views

Keepalived load balancing MySQL. Backup server time-out

Dear beloved people at ServerFault. I'm trying (and failing) to setup a load balanced MySQL server array. Please enlighten me, show me the error in my ways. Current setup: two MySQL servers with ...
0
votes
1answer
59 views

postfix/dovecot/mysql not sending/getting emails [duplicate]

I understand that I posted this before, however I left out some very important details which apparently made a lot of people less likely to answer, here's a more detailed version. My ...
0
votes
0answers
60 views

Amazon EC2 not responding on port 80 and mysqld will not start

An EC2 instance running Apache 2.2.5 on CentOS 6.4 appeared to be fine up until September 29. That day at 7:49 the Value in CloudWatch was 42, at 7:59 it was in the low 100,000's, the last Value ...
0
votes
1answer
68 views

Mysql - best setup for 4 replication databases and another standalone

we would like to merge on one server 2 mysql instances coming from 2 different server : 4 databases on the first instance, which is a replication slave, which are replicated from a master 1 database ...
1
vote
1answer
248 views

Upgrade mysql 5.5.40 to 5.6 on centos 6.4

I can't find a repo to add to my repolist that has an update for mysql 5.6. Does anyone know how to do this? I tried this [link] but it broke everything. I was getting a mysql_connect() undefined ...
0
votes
0answers
53 views

How to link my local MySQL DB to remote MySQL on the internet

Please I need some suggestions or advice on how to how to link my local MySQL DB to remote MySQL on the internet. I developed a Conference Management System for my client and they want us to setup 2 ...
0
votes
1answer
226 views

Amazon RDS load balancing and performance

My question is simple. Is it possible to load balance rds (master and read-replicas) using the same haproxy instance used for application load balancing? This would mean that the IP of the ...
-5
votes
1answer
101 views

MySql wont start [closed]

'Hi I have a pretty recent install of MySql on DigitalOcean. And for some reason I cannot get MySql to start. 141003 07:25:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 141003 ...
0
votes
0answers
42 views

MYD files renamed after restart - how to recover?

The disk space went full on our server. It remained like this for too long, and now mysql is completely crased. I'm getting errors like this : mysql> use mysql; Reading table information for ...
1
vote
1answer
253 views

Batch MySql script stopped with error “(104)Connection reset by peer”

On my site I start a script that executes a batch process that imports into the Mysql database a lot of products (texts and images). I'm monitoring the query process from Phpmyadmin>Status and I ...
2
votes
3answers
345 views

Linux desktop as a MySQL server?

My sysadmin created an Ubuntu Desktop VM for me to use as a MySQL database server. I am anticipating light use; approx. 10 DB connections max at any given time. We have no plans to ever need the ...
0
votes
2answers
158 views

Cannot install mysql-devel on centos

Everytime I try to run sudo yum install mysql-devel I am met with the following error: Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package ...
0
votes
2answers
33 views

Allow mysql user to be used just by specified user

Currently any system user can run: systemuser$ mysql -u mysqluser -p (assuming he knows the password). Is there a way to deny mysql (cli) to use particular mysql user? eg. systemuser$ mysql ...
0
votes
1answer
198 views

MySql Membership provider - Missing or incorrect schema

We have an ASP.NET site running on IIS 7.5 with a MySQL database using the .net connector, the membership/role providers are set in the web.config correctly and they work - but only temporarily. ...
0
votes
1answer
50 views

Password less mysql access to specified user/script only

In addition to this question: Performing root mysql operations in bash scripts I'd like to ask how to limit/allow this action (performing root administrative actions): mysql --local-path=mypath -e ...
0
votes
1answer
236 views

Apache can't connect to remote MySQL, but mysql command line from same server can

Symptoms: I am running CentOS 6. I can connect to the remote MySQL from the command line: mysql -h a.b.c.d -u user -p -D db. Laravel artisan commands run on the local command line can also connect: ...
1
vote
1answer
386 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 ...
0
votes
0answers
27 views

Percona connectivity issue, user cannot connect?

I am trying to authenticate a user in percona but I am seeing the error message below each time I try... 2014-09-29 12:43:37 5028 [Warning] The plugin '0' used to authenticate user 'user@' is not ...
0
votes
0answers
129 views

How to restore a corrupted MySQL master database from a slave database?

I recently discovered that the master db in a setup I'm running became corrupted. The slave was getting all of the data correctly so I have a solid backup. What I'd like to do is use replication to ...
0
votes
0answers
236 views

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
-3
votes
1answer
44 views

Urgent need of help - I changed unsafe inodb_log_file_size mysql parameter and now fails to start

I made a mistake and changed the inodb_log_file_size parameter value in my.cnf without shutting down the mysql first and moving the ib_logfile0 and ib_logfile1 out of directory. Now it fails to start, ...
1
vote
1answer
78 views

MySQL server hangs without reason

I have a server running web site with back-end database MySQL (more specific - 5.5.37-MariaDB, for debian-linux-gnu on x86_64). Sometimes it stops accepting connections and web site scripts report ...
0
votes
1answer
37 views

MySQL via SSL on VPC private subnet

Is an SSL connection recommended when connecting to a MySQL database server via a private subnet? SSL provides encryption but SSL causes a performance hit. The MySQL database server only serves ...
0
votes
2answers
65 views

MySQLD is using 175% of the cpu

On one of the servers, I have mysqld running as slave DB. The CPU usage is 175% at the moment used by mysqld. Here are the results of SHOW PROCESSLIST; ...
0
votes
1answer
280 views

Lost connection to MySQL server during query (5.6.20)

I have a brand new install of MySQL 5.6.20 and now get these messages from my front-end when I am loading up the new database. [Err] 2013 - Lost connection to MySQL server during query [Err] Alter ...
0
votes
0answers
54 views

Querying node information from Foreman is very slow and I'd like to optimize it

I'm trying to set up Rundeck to query Foreman for node information. For example, the curl query: curl -k -u rundeckuser:rundeckpassword "https://foreman/hosts?rundeck=true&format=yaml" takes ...
2
votes
1answer
106 views

Performing root mysql operations in bash scripts

What is a good practice to execute root operations on mysql databases in bash scripts? For example, I want to create new database and grant privileges, I have to use: mysql -u $ROOT -p"$ROOTPASS" -e ...
1
vote
1answer
62 views

pure ftpd auth using crypt sha512

I've installed pure-ftpd-mysql and it works fine with md5 password hashing. This isn't very secure, so I'd like to use crypt with salted sha512, the way I'm using in dovecot. How to set up this in ...
0
votes
1answer
165 views

Wordpress and Apache crashing MySql (CLOSE_WAIT)

Last days mysql server on my vps start crashing, sometimes right after restart. I found that problem in wordpress website. After service mysql start many apache2 processes overload memory and cpu. ...
0
votes
0answers
22 views

Can an Amazon RDS instance serve as master for one schema and act as a read-only slave for another?

We have an Amazon RDS instance in production that caters to db requests for a set of tomcat servers. This is say schema1 on the RDS instance that is constantly accessed. Can we setup the same RDS ...
-1
votes
3answers
254 views

MariaDB 10.x on CentOS 7?

Why there is no MariaDB 10.x RPM for CentOS/RedHat 7? How can I install it? I'm trying to install the most recent stable version on my server, but it seems, that official repo is absent. 5.5 is ...
3
votes
1answer
34 views

MySQL keeps getting “connect” commands 100X per minute

My server was having performance issues, things loading slow, pages not loading, etc so I ran the "top" command after logging in via SSH. I noticed the CPU kept jolting up to 40%, on and off, when ...
0
votes
1answer
44 views

Insanely high mysqld write I/O on SELECT queries

I am struggling to find a reason for my mysql have this much of disk write, it just doesn't make any sense. It it doing mostly of the time SELECT queries, so the only reason I find to it write so much ...
0
votes
0answers
42 views

MySQL cluster data node restarts when its twin fails

Configuration: Server #1: 1 mgm node, 1 data node, 1 sql node Server #2: 1 mgm node, 1 data node, 1 sql node Specification: MySQL Cluster 7.3.6 x86_64 Debian 7.6 x86_64 It's been deployed by ...
0
votes
1answer
46 views

how to find cause of io spike

Everyday at around the same time, the IO usage on the server where our mysql slave goes up to 100%. I have setup a script that takes IO information every five minutes so I can find out why this ...
1
vote
1answer
706 views

MySQL error: “The partition with /var/lib/mysql is too full!” df -h shows otherwise

my rented server is currently saying that mysql is too full when trying to start it when using /etc/init.d/mysql start. However using sudo /etc/init.d/mysql start it works normally. Running df -h ...
-2
votes
1answer
28 views

Ubuntu server crashing frequently

i hope you can help me. i am running an ubuntu 12.04 server which i am using as a web/sql server. the server was running fine for month but now since two weeks the server is crashing almost every ...
1
vote
1answer
105 views

Never ending transaction problems after mysql 5.0->5.6 upgrade

I upgraded our entire backend mysql db from 5.0 to 5.6, including changing a few tables to innodb, and we've been having nothing but problems with never ending transactions since. I still have a ...
0
votes
1answer
62 views

My local MySQL server was temporary down for unknown reasons

My local MySQL server 5.5.38 (on CentOS 6.5) has been temporary down and the mysql log file was filled with this kind of details: This could be because you hit a bug. It is also possible that this ...
1
vote
0answers
39 views

Postrotate “error running shared script”

Morning all, I realise this question has been answered already but the fix does not seem to work in this case so I'm hoping you guys can help. This this is the error I'm getting: error: error ...
-2
votes
1answer
4k views

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock [closed]

Recently, I've started getting this error when trying to login to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I read on another ...
-1
votes
1answer
736 views

my.cnf configuration in mysql 5.6.X [closed]

Server information 64GB RAM Intel(R) Core(TM) i7-3930K CPU @ 3.20GHz Mysql Server version: 5.6.20-log - MySQL Community Server (GPL) I have 20 websites on this server like share hosting my big ...
0
votes
3answers
126 views

Exim won't start - Error loading lookup module mysql.so

I had to change the root password for MySQL on a server. Exim also uses MySQL for users etc. I didn't think Exim/Dovecot used that password, but now things are not working well and I'm pretty sure ...
-2
votes
1answer
2k views

phpMyAdmin displays blank page

I have gone through all links related to a blank page displayed by phpMyAdmin but none of them helped my solve my issue. I have installed phpMyAdmin and deployed it on the Apache server. I have also ...
0
votes
1answer
123 views

Strange CPU spikes with MySQL

On my server (ubuntu 12.04) mysqld started to show some strange CPU spikes. I've logged some of it as a sample: http://pastebin.com/4MwKUVwL The value after the triple dash '---' is the cpu usage ...
0
votes
1answer
60 views

Production server (cluster) configuration

I have a problem, that i'd like to address to you. We are creating an webapp that shows infos and statistics. And we have a problem about how to 'do right' our server configuration The thing is that ...