MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
1answer
20 views

debug mysql crash

I have a production server which I am managing and I have been running a rails application on this server. The issue has happened twice in the past month or so and I am not sure how to debug this. ...
0
votes
0answers
9 views

Finding and removing old mysql-bin files

I am running a MySQL server on Windows 8. The MySQL directory requires 118 GB of space and has a lot of 1 GB mysql-bin files that haven't been modified for years according to the file system. All of ...
0
votes
1answer
31 views

Moving from Parse cloud to AWS [on hold]

I have an iOs app completely working on Parse cloud storage, however for some reason I need to switch to AWS now. I've never used AWS before, so I'm not sure which product to use in AWS. My data is ...
3
votes
2answers
110 views

Cannot Establish Remote Connection to MYSQL Database

want to access the MYSQL database remotely but when checking on yougetsignal(dot) com I get a message that port 3306 is closed. Configuration: Fresh Server (Centos 6.4 64 bit with Zpanel installed) ...
0
votes
1answer
14 views

Zenoss - install.sh doesnt ask for mysql password

i'm trying to install zenoss on a ubuntu-14.04 virtual machine. I followed the following guide "https://help.ubuntu.com/community/Zenoss". After some errors with dependencies, I have the following ...
-1
votes
1answer
16 views

Telnet to localhost 3306 looses connection to host after few seconds

When I try to telnet into my localhost port 3306 which belongs to mysql, it shows me the hello packet, then looses connection after a few seconds. My skip networking is set to OFF, I have started and ...
-1
votes
0answers
22 views

How to correlate apache events among a web cluster?

We have a cluster of about 200 web servers. From time to time we'll have an event occur where a subset of those servers will trigger the monitoring software to restart the apache daemon. We can get ...
0
votes
0answers
24 views

How to correctly recompile PHP?

Using Ubuntu Server 14.04 x64 / PHP 5.5.9-1ubuntu4 (cli) w/ FPM / MySQL InnoDB version 5.5.35 Incredibly frustrated with what was supposed to be a minor issue. Basically, I'm being forced to ...
-1
votes
2answers
40 views

how do I move where percona mysql stores the databases? [on hold]

I'm running low on disk space and want to move my database's to a new disk (NAS). I have no clue how to do this. Any help is appreciated. I'm using Ubuntu 13.04 and the latest version of Percona ...
0
votes
2answers
31 views

Performance hit from moving DB to another drive symlink?

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
0
votes
0answers
15 views

Performance hit from moving DB to another drive symlink? [duplicate]

We're considering moving one database (there are 4 of them in total) with InnoDB tables, to a separate partition in a Ubuntu 14.04 VPS. This DB gets read/write intensive (500 writes per sec, about ...
0
votes
1answer
20 views

Dovecot MySQL Authentication SlowDown

I have an IMAP/POP3/Webmail server with Dovecot1 2.2.10 with a MySQL backend located on another server. The server runs with default configuration. ... driver = mysql default_pass_scheme = plain ... ...
-2
votes
0answers
35 views

Mysql resolving 127.0.0.1 to hostname [migrated]

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
0
votes
0answers
8 views

Error: Trying to add tablespace 57 to the tablespace memory_cache

I was wondering if you could help me out repairing a Mysql database: InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Error: trying to add ...
1
vote
1answer
89 views
+50

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
1
vote
3answers
105 views

localhost webserver vs separate server for small office [duplicate]

We have a small office (4 people at the moment) and work exclusively with healthcare data (HIPAA protected). For the past 2 years we've been storing all client data on a mysql database on my local ...
0
votes
0answers
12 views

Unable to create the initial Zenoss object database

trying to setup Zenoss in Centos. Couldn't initialize the Zenoss due to below error /etc/init.d/zenoss start Zenoss not initialized. Performing first-boot initialization... Fresh install pre steps ...
1
vote
2answers
27 views

php pdo connection cannot be established, but mysql command line client can

situation as follows: php script on server a, run by user 'web' (nginx + php-fpm) should access mysql on server b via pdo library, but gets SQLSTATE[HY000] [2003] Can't connect to MySQL server on ...
0
votes
0answers
17 views

Options to include with mysqldump when taking backup of hybrid databases

I'm planning on taking backups of all MySQL databases on a remote production server. The combined database size is around 2 GB. Most of the tables are InnoDB ~1.8 GB and the rest are MyISAM. Now I've ...
1
vote
2answers
30 views

run second mysqld instance for backup restore

I am trying to start a second mysqld instance to restore data from backup (innoDB). Following the manual I put together this: P="/var/lib/reoback/backups/2014-06-30/var/lib/mysql" cd $P mkdir tmp ...
1
vote
1answer
30 views

mysql: Unable to Grant while using root user, what could be the reason?

I have a mysql server which i'm able to log into using root password (no password) but for some reason I'm unable to grant other users access to mysql. When I run: mysql> grant all on *.* to ...
-4
votes
2answers
24 views

MySQL incorrect result of insert [closed]

Created table 'testload' on demo database (int (15)) ...
-1
votes
0answers
40 views

mysql service failed to start [closed]

I have dual Operating system on PC, windows 8 and Ubuntu 14.0, and I am mostly using Ubuntu because my MySQL database is hosted on Ubuntu. Recently when I am trying to restore my database, which is ...
1
vote
2answers
36 views

start mysql service after syncing data dir to tmpfs

hej there! I'm maintaining a network of 8 Pandaboards. One of them is acting as server to host a php-based browser game, others are clients running that game. The server runs Debian Wheezy from SD ...
1
vote
0answers
29 views

Is it ever a good idea to use different storage engines on MySQL for a given database? [migrated]

I asked this question at http://stackoverflow.com/questions/24477834/mixing-mysql-storage-engines-in-a-database, but it was closed as being off topic. I have needs for different functionality ...
0
votes
0answers
23 views

Mysql server won't start after Mavericks upgrade [migrated]

I am unable to start MySQL server after upgrading from OSX 10.8.5 to 10.9.3 prompt: sudo ./support-files/mysql.server restart ERROR! MySQL server PID file could not be found! ...
1
vote
1answer
69 views

Token error when trying to change password through pam-mysql

I am currently preparing a machine for a web hosting service, and I decided to use MySQL to store all our users (since the rest of our services use it already). For that, I am using libnss-mysql and ...
1
vote
2answers
78 views

error installing mysql client after installing remi php-mysql

after installing nginx with php-fpm thanks to remi repository, I get an error when I simply install mysql client : yum install mysql give me the following result (see bellow). Loaded plugins: ...
0
votes
1answer
55 views

Updating phpMyAdmin that works with MySQL 5.1.73

I have recently setup a Xen VPS hosting (CentOS 6/512MB RAM/20GB HDD) for my WordPress based website. My current phpMyAdmin version is 4.1.7 and the current MySQL version is 5.1.73. I wanted to ...
1
vote
1answer
39 views

Compare between MYSQL cluster and MYSQL server

I have created a MYSQL cluster using network speed 100-megabit Ethernet 2 Data Node (3G RAM) 1 Management Node (3G RAM) 2 SQL Node (3G RAM) 2 HAProxy with heartbeat cluster to balance between SQL ...
0
votes
0answers
24 views

Nginx & PHP: How to install / activate PDO

I have an nginx server with PHP running on Windows Server 2012 and I want to install Collabtive. This web-based project management software requires PDO to connect to a MySQL database. The ...
3
votes
1answer
21 views

Exim4 crypteq with MySQL lookup always fails

I got an Exim 4.80 server on Ubuntu 14.04. I want to switch from Dovecot Auth to MySQL. The passwords are stored as crypt (with sha256, beginning with $5$). The expansion looks like this: ...
-1
votes
0answers
24 views

enable remote and local access of mysql database

We're deploying a web site, and the developer wants remote access to mysql and also to use the same dbuser to connect locally from PHP code. I've commented out bind = 127.0.0.1 to enable remote ...
1
vote
1answer
34 views

boot2docker mysql privileges

I'm using boot2docker on mac osx 10.9. I have an image with mysql 5.1 installed. I grant my user with FLUSH PRIVILEGES; like following: Host: 192.168.59.103 User: root Password: ...
0
votes
2answers
51 views

resetting iptables seems to make connections clear faster

I have iptables setup on 2 servers. Server#1 is public and Server#2 only allows the ip address of Server#1 to have ACCESS. Server#2 has a mySQL database that Server#1 queries. I ran a query and it ...
2
votes
2answers
61 views

Two databases synced backup

I got a system that need two databases to work. I need a script to backup both databases at given point of time. I need databases to be in sync, so I need to be sure that backup does not allow changes ...
0
votes
1answer
30 views

Postfix and MySQL configuration

I have the problem with configuration of Postfix on my server. I have been used this link like tutorial for creating and configuration Postfix. ...
0
votes
1answer
18 views

Parallel mysqlimport Syntax Wrong?

I'm trying to import a large 70GB+ database (all InnoDB) using mysqlimport. This is a development system on Windows using WAMP server. MySQL 5.6.17. I'm getting the following error: mysqlimport: ...
4
votes
1answer
45 views

strace shows long time reading from mysql socket - mysql takes long time to execute query?

My Apache server takes long time to process request. I attached strace to it and can see the two following delays: 1) Very critical (143 seconds to process) 1335 0.000037 write(16, ...
0
votes
1answer
34 views

HAProxy's Flooding MySQL Connections

I have a setup of 2 HAProxy servers using the KeepAlived process for failover, and each HAProxy is configured to load balance mysql connections to my MariaDB Galera cluster of 3 nodes. I'm trying to ...
0
votes
1answer
47 views

installing phpmyadmin for remote db host

I am having trouble trying to install phpmyadmin. We are using AWS services for our servers. Our mysql db is located in an RDS instance. Now I am trying to install phpmyadmin on an EC2 instance. I ...
0
votes
0answers
18 views

MySQL character-set-server won't take effect

I'm trying to have my MySQL server use UTF8 as the default collation and character set. I am able to set everything except for the character_set_server which always takes 'latin1' as value. I have ...
-4
votes
1answer
58 views

Which one is better ? one big server or two small servers for mysql and apache? [closed]

I am moving my small phpBB website from a hosting to cloud (digitalocean) the size of my mysql server is 400MB, and I wonder if I should buy one big server for my site or two small servers ? let say ...
0
votes
1answer
64 views

Can not restart mysql service after getting Error 2002 Can't connect to local mysql server

Starting yesterday, I'm getting this error when connecting to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I haven't touched my ...
0
votes
1answer
64 views

After editing my.cnf MySQL fails to restart

I want to edit the /etc/my.cnf file. I've tried to use this as the file content: [mysqld] set-variable = max_allowed_packet=24M set-variable = max_connections=300 log-slow-queries safe-show-database ...
0
votes
0answers
30 views

Unknown SQL server host error in phpMyAdmin after switching php versions in WAMP [migrated]

I've installed Wamp Server 2.2, which includes php 5.3.13, Apache 2.2.22 and MySQL 5.5.24. Then I installed php 5.2.4 using the WampServer2-PHP524.exe extension found here on SourceForge. When I ...
1
vote
1answer
58 views

Puppet random password generating

I am going to install around 100 mysql servers and I would like to have different root password on every of them. I am going to use puppet mysql (https://forge.puppetlabs.com/puppetlabs/mysql) which ...
0
votes
0answers
22 views

Maintaining a progress counter across multiple PHP worker threads using Gearman

I've set up an Amazon EC2 instance running Gearman and 10 worker threads written in PHP. I'm also utilising MySQL and Redis. For each user that signs up to my website up to 1,000 Gearman jobs are ...
1
vote
1answer
51 views

MySQL shutting down without worning, out of memory?

I'm scratching my head on this. I have New Relic tracking, and my log files on the server, but MySQL keeps stopping, and all I have is this when I check logs, New Relic has nothing. Only thing I'm ...
-1
votes
0answers
51 views

Can't connect to MySQL server on 'ipaddress' (4) (2003) [closed]

$mysql_host = "myipaddress"; $mysql_user = "user"; $mysql_pass = "password"; $mysql_db = "mydb"; $con = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db); // Check ...