MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

-2
votes
2answers
103 views

Cannot start MySQL server following upgrade [closed]

Cannot start MySQL server following upgrade I've just upgraded MySQL from 5.1.59 to 5.6.20 (OSX 10.7) and now the MySQL server will not start. In MySQL Workbench (v6.1.7), in the startup/shutdown ...
1
vote
0answers
14 views

Auditing connections using certificates

We would like to have clients connect using client certificates from a trusted (internal) issuer and then log which user connected. Unfortunately, the following limitations are preventing success: ...
1
vote
1answer
42 views

WinServer 2008 R2 MySQL cluster service won't start

So I have a two-node failover cluster in WinServer 2008 R2, I also created a generic service which will manage my MySQL5.5 database (the database root is also in a iSCSI storage). When the cluster ...
1
vote
1answer
132 views

Creating a stable, auto-scaling app server cluster

I have two servers, each running anywhere from 50-100 different legacy webapps, written in languages ranging from PHP to Python to Ruby-on-rails to NodeJS. We're wanting to kill off these machines ...
-2
votes
2answers
51 views

One database for two websites [closed]

I'm starting a project where I need two different websites to interact with one database. They have different domains and different source codes. My servers providers are Hostgator and Linode. ...
0
votes
2answers
118 views

Centos 6.5 DB MySQL server, default install, resize or move DB location - disk-usage issue

I did a standard install of Centos 6.5 in a 1TB SSD (MLC) not realizing that only 50G is allocated to / and approximately 816G to /home: [gskidmor@mrserver ~]$ df -h Filesystem ...
0
votes
1answer
74 views

Percona slave crashes with “unexpected PLT reloc type”

I have 2 data centers each with a master/slave database running Percona server 5.5.23. For some reason, one of the slave databases crashed with this error: 03:00:40 UTC - mysqld got signal 11 ; ...
-3
votes
3answers
65 views

Is it safe to use mysql 5.1? [closed]

I've contacted 3 different hosts lately, to talk about Apache server, one of them is my current host, two of them have mysql 5.1 (One is mine), one has mysql 5.4, but none of them seems to give me a ...
0
votes
1answer
31 views

how to use mysql database replication to backup a single database

Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible? or does the replication slave have to replicate ...
-1
votes
1answer
199 views

MySQL installation with Ansible on Debian Wheezy

As the title suggests, I am trying to install MySQL Server 5.5 on Debian with Ansible. Since this needs to be a silent installation, I provide the root password before the installation with debconf ...
-1
votes
1answer
23 views

Moving MYSQL database Cache issue?

I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess. ...
0
votes
0answers
156 views

mysql-server : Depends: mysql-server-5.1 but it is not going to be installed

I want to install MySQL on Squeeze (Debian), but I get this error message from apt: mysql-server : Depends: mysql-server-5.1 but it is not going to be installed I have tried to use a different ...
-4
votes
2answers
254 views

Error MySQL CentOS - Starting MySQLCouldn't find MySQL server

I can not make any operation in mysql: root@server2 [/]# /etc/init.d/mysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] root@server2 [/]# /etc/init.d/mysql start ...
1
vote
0answers
98 views

MySQL on Amazon RDS db.m3.medium performing slowly

I'm moving a rails application from heroku to AWS in order to increase reliability and control over the stack architecture. I was planning to use amazon RDS as I will need several app servers, and a ...
2
votes
1answer
23 views

Drop outgoing mail to previously unavailable mailboxes in exim using mysql database

we have a larger community portal which became bigger and bigger over the years but also has some dead accounts. Recently the ip of the server was blacklisted because many mail adresses of the users ...
0
votes
2answers
54 views

MariaDB RHEL Fresh Install Root Login Issue

I just installed MariaDB on a RHEL system and this is my first time using MariaDB. I can start/stop the service only using the following commands: sudo systemctl start mariadb.service sudo systemctl ...
0
votes
1answer
34 views

TOP processes by system time

I have a system running 2 processes - MySQL and Java I'm seeing 20-30% of the time spent in %system. I've looked around to try and find a way to identify which what the balance of the system time is ...
1
vote
1answer
29 views

import rescued cacti database into newer version

I have an older cacti database with critical data I am trying to recover. The old database has many less fields than the new current stable. Doing a manual import produces wild errors. How do you ...
0
votes
1answer
52 views

Postfix intermittent lookup failures

i have intermittent lookup error on my postfix/mysql/dovecot/debian when looking to virtual aliases ... it happens on 10% of outgoing emails Revelant log of a failed request : Aug 28 12:17:43 ...
2
votes
1answer
122 views

How do I keep MySQL from ever increasing it's disk space usage when used with puppet-dashboard?

The setup We have a Debian Linux set up with MySQL v5.1.73 (innoDB storage engine) and puppet-dashboard version 1.2.23. As you probably guessed, puppet-dashboard is using MySQL as its backend. Also, ...
0
votes
1answer
189 views

Upgrade PHP-mysql Lib Centos 6 [duplicate]

I just delete all php and mysql and installed it again. but in PHPMyadmin i still get: Your PHP MySQL library version 5.1.69 differs from your MySQL server version 5.5.39. This may cause ...
0
votes
1answer
114 views

How to move RDS database to different VPC

I didn't select a VPC when creating a MySQL RDS database, so it created it inside an auto-generated "default" VPC. I'm now unable to add it to any of my pre-defined security groups, or access it from ...
0
votes
2answers
184 views

Centos Your PHP MySQL library version 1.5.73 differs from your MySQL server version 5.5.39 [duplicate]

I have recently updated my PHP version to 5.4 and my mysql version to 5.5 [root@**** ~]# php -v PHP 5.4.31 (cli) (built: Jul 25 2014 07:41:53) Copyright (c) 1997-2014 The PHP Group Zend Engine ...
-1
votes
1answer
66 views

Innodb performs IO Operation when idle

I am currently doing some stress testing where I am pushing inserts to the database as fast as I can. The simulation inserts 10000 records per second. After inserting around 200 million records I ...
0
votes
2answers
199 views

PHP stopped working after upgrading from 5.3 to 5.5 using PPA

I had PHP 5.3 working on an old server that my company uses. I have PHP 5.5 working on my AWS server. Both of the servers are Ubuntu. My application is working fine on my AWS server. But when I ...
0
votes
1answer
104 views

Centos mysql version is 5.5 however PHPmyadmin still says version 5.1

When i run the following in my console: [root@****~]# mysql -u root -p -e 'SELECT VERSION();' Enter password: +-----------+ | VERSION() | +-----------+ | 5.5.39 | +-----------+ Which should be ...
0
votes
1answer
334 views

mysql “no packages marked for update” in Centos

From the following guide i have been trying to update mysql on my Centos server: http://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/updating-yum-repo.html My current mysql version is: ...
0
votes
1answer
55 views

What are good systems for managing Drupal infrastructure? [closed]

I work in a company which is about to migrate most applications from in-house custom built Java/Tomcat applications to Drupal. Due to company policies, applications and websites need to run on ...
0
votes
1answer
41 views

“Can't create table” when having to many partitions

I am currently having a problem I dont understand. Wherever I look it says mySQL (5.5) / InnoDB doesnt have a table limit. I wanted to test the InnoDB compression and was about to create an empty ...
0
votes
0answers
28 views

MySQL is processing (non-performed) queries from 2 days ago

I'm experiencing a very strange issue. 2 days ago, our MySQL server had fluctuations and various queries sent from our app couldn't be processed. Today, I'm seeing that these non-performed queries ...
0
votes
1answer
35 views

update time and create time of tables is showing null in mysql

The columns update_time and create_time is having the value NULL in the information_schema Tables of MYSQL. How can the value be NULL?. Can anyone please explain?
0
votes
1answer
58 views

Windows server and ddns which binding and sql hostname do i use?

i'm trying to connect to websites on this server from outside the network. i've opened ports in router and firewall and can ping the ports using portchecker. let's pretend i want to use wordpress or ...
0
votes
1answer
61 views

Openfire password forgotten - database hidden

I have set up an openfire server two months ago and I have forgotten if I had used the built-in database or my MySQL server on localhost. I am using Windows Server 2012 on Amazon EC2 with XAMPP ...
1
vote
0answers
73 views

Website down… due to sleeping MySQL connections?

I've just inherited the administration of a website, and I'm finding some problems: When the traffic in the site peaks (it happens when our posts are featured in some distribution lists/RSS feed), ...
0
votes
1answer
365 views

MySQL SSL: bad other signature confirmation

I am trying to enable SSL connections for MySQL-- SSL will show as enabled in MySQL, but I can't make any connections due to this error: ERROR 2026 (HY000): SSL connection error: ASN: bad other ...
-2
votes
1answer
61 views

Access denied for user 'diduser'@'localhost' to database 'diddata' (1044, 42000)

I am trying to setup a MySQL server and when I went to create a second user it wouldn't give it permissions for the database. I can connect fine as long as I don't specify a database. Access ...
0
votes
0answers
41 views

MySQL permission errors

It seems that on a Ubuntu 14.04 machine the user mysql cannot access anything. It is not writing logs nor reading files. Witness: - bruno():mysql$ cat /etc/passwd | grep mysql mysql:x:116:127:MySQL ...
3
votes
1answer
135 views

How do I configure rsyslog to deal with MySQL Slow Query Log multi-line messages?

Using rsyslog v8.2.2, I would like to group multi-line messages, such as those output by the MySQL Slow Query log. Each new message begins with three consecutive lines having '#' as the first char of ...
0
votes
1answer
214 views

Forced reboot caused /var/lib/mysql to 'disappear'

During the nigh my provider had to force reboot the server (pull the plug), after boot, there was a problem with the MySQL server (I'm using MariaDB). After hours of research I can't find the main ...
0
votes
1answer
51 views

How many incremental backups to keep with Percona xtrabackup?

I'm looking to replace an aging and decidedly suboptimal mysqldump-based database backup strategy with Percona's Xtrabackup. This all looks pretty straightforward, except that I'm wondering: how many ...
0
votes
2answers
842 views

MySQL remote connection - Access denied for user 'username'@'localhost' (using password: YES)

I am setting up a remote connection to a MySQL server but no matter what I try I am getting access denied error from the remote server. I added the user by: CREATE USER ...
0
votes
1answer
39 views

New MySQL 5.7 installation: Account “Any@%” with USAGE-only, no-GRANT? [duplicate]

I've a MySQL 5.7 brand-new installation (via Oracle official RPM) on CentOS 6.5. Via phpmyadmin, I see this strange "Any@%" account I didn't create, with only USAGE as GLOBAL PRIVILEGES and Grant: No ...
0
votes
1answer
96 views

MySQL stops running without reason in log file

I am running MySQL 5.6.17 on Centos 6.5 (2.6.32-042stab090.5 #1 SMP Sat Jun 21 00:15:09 MSK 2014 x86_64 x86_64 x86_64 GNU/Linux). Every couple of weeks MySQL stops running, the logs do not show ...
-2
votes
1answer
98 views

MariaDB service won't start on FreeBSD jail

Just set up a dedicated database jail running databases/mariadb55-server and for some reason it won't start on demand nor on boot. Any suggestions? # service mysql-server start Starting mysql. ...
1
vote
2answers
89 views

Restarting mysql utilizing the puppetlabs/mysql module?

I have two folders -- one is 'public_modules' and the other is 'private_modules'. When I start a new Vagrant machine, the 'public_modules' folder is populated with modules as described in my ...
0
votes
1answer
70 views

Percona startup fails: mysql can't access directory for file creation

I found a few questions and suggestions for similiar problem, unfortunately nothing seems to work for me, so please excuse me if this is double (and point to right source)... Server is Fedora Beefy ...
0
votes
2answers
67 views

Repeated EC2 Apache 500 error

I'm running a Django website off Apache and MySQL. I'm using a t1.micro instance. After every couple of days, my server starts giving a 500 error. I solve this problem by restarting the Apache2 and ...
0
votes
0answers
57 views

Creating Table in mariaDB - ERROR 1429 (HY000)

I successfully integrated mariaDB-10.0.13 with Cassandra-2.0.8 and 2.0.9 I was able to created a table present in cassandra on mariaDB and was able to query successfully. But my problem is that ...
-1
votes
1answer
61 views

postfix how to setup local domain users as virtual users

How can I set up local domain users as virtual users? I have setup virtual domain and the users but when I sent an email it keeps telling me "User not found". To test to see what the problem is, I ...
0
votes
0answers
146 views

MySQL server would not start after config change

I have MySQL server installed on an AWS EC2 micro instance. The server was starting/stopping properly with sudo service mysql start/stop, but it stopped working since I made minor changes to the ...