MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

0
votes
1answer
101 views

LAMP stack everything seems to be working except sites are blank

I have a LAMP stack, Ubuntu 12.04.3 LTS PHP 5.3.10-1ubuntu3.8 with Suhosin-Patch (cli) (built: Sep 4 2013 20:05:42) Apache/2.2.22 (Ubuntu) MYSQL 5.5.32-0ubuntu0.12.04.1 (Ubuntu) Codeigniter 2.1.0 ...
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
61 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
826 views

Postfix MySql Dovecot - SMTP Authentication Failure

Hello I have a Postfix setup with Dovecot and MySql. The server is running Debian Squeeze. The MySql server is a slave that has data pushed to it from a primary (postfix) mail server(running a ...
2
votes
2answers
2k views

Which AMI to to use for Java/Tomcat/MySQL in Amazon EC2?

I originally posted this on stackoverflow.com and it was suggested serverfault.com might be a better place to ask this question. So here goes: I'm trying to determine which Amazon Machine Image ...
0
votes
1answer
65 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
1answer
69 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
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 ...
1
vote
5answers
1k views

mysql server doesn't startup

The mysql server is running on a newly installed ubuntu 8.04. (I wanted to move the mysql server into KVM. KVM itself is running on ubuntu 10.04. ) /mysql belongs to mysql:mysql and is accessible. ...
0
votes
2answers
645 views

MySQL Cluster transaction isolation level - READ_COMMITTED

I'm learning by mostly reading the documentation. Unfortunately, http://dev.mysql.com/doc/refman/5.1/en/set-transaction.html#isolevel_read-committed doesn't say anything, while it says everything. ...
0
votes
2answers
46 views

Monit issues with mysql Ubuntu server 12.04

I've installed Monit on Ubuntu server 12.04 but Im having issues getting mysql monitoring to work at all. Here is what I have done so far. #/etc/default/monit startup=1 #/etc/mysql/my.cnf pid-file ...
-2
votes
4answers
9k views

Change MYSQL Port on Windows

I need some assistance changing the port that MySQL is running on. So, according to http://dev.mysql.com/doc/refman/5.1/en/option-files.html MySQL first looks for conf in WINDIR\my.ini, ...
0
votes
1answer
707 views

Run mysqld under a different user (linux)

I've been trying to start mysqld under a different user as well as with a different data path. I've done so by modifing the my.cnf file as follows: [mysqld] datadir=/bob/database ...
0
votes
2answers
2k views

MySQL dump, output each table row on a new line whilst using --extended-insert

I'm having an issue, where for ease of use, I'd like to be able to format a command line MySQL dump so that each row of a given table is on a new line when using the --extended-insert option. Usually ...
0
votes
2answers
91 views

mysql 5.5 general_log won't stay turned off

I recently discovered that my general_log was turned on and it had generated a 400gb log file. OUCH.. Then I tried to turn it off. while running I entered "SET GLOBAL general_log = OFF" and sure ...
0
votes
2answers
828 views

Compiling PHP on CentOS Needs MySQL PDO Configured

I am trying to compile PHP with mysql_pdo on CentOS 6 and I am having just one heck of a time trying to make it happen. Currently I am trying to compile PHP 5.2, but I am going to have to do this for ...
0
votes
0answers
23 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 ...
0
votes
2answers
2k views

python mysqldb - mysql server gone away - can't reconnect

When attempting to import a bunch of data into mysql tables using python and mysqldb, I run into the following error '2006 - mySQL Server has gone away', and then I am unable to reconnect again within ...
0
votes
1answer
956 views

/usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd)

Recently I have a problem with sphinxsearch and mysql: Restarting sphinxsearch: /usr/bin/searchd: /usr/lib/libmysqlclient.so.18: no version information available (required by /usr/bin/searchd) ...
1
vote
1answer
52 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 ...
0
votes
1answer
63 views

Can I access an AWS RDS read replica directly from Internet?

Or what is the same, is possible assign a public IP address to my RDS read replicas? My read replicas end points answer with private IPs right now, even they are in a VPC subnet with an AWS Internet ...
0
votes
0answers
39 views

Mysql through ssh often can't connect or timeout

I have a MariaDB server (10.0.12) on a machine (Ubuntu 14.04) that other servers connect to through ssh for security purpose. The ssh tunnel is openned via autossh like so: autossh -M 3306 -f -Ng ...
1
vote
1answer
25 views

Innodb tables not showing

If I run query show table in mysql console, the innodb tables will be listed. But when I tried a query like select * from tablename, it says table does not exist. How can I fix this issue and make ...
0
votes
1answer
70 views

Pam-Mysql “Can't initialize threads: error 11”

Inside a Debian OpenVZ container, I have 2 OpenVPN servers (udp on port 53 and tcp on port 443). The authentication is based on Pam-Mysql. Inside my OpenVPN conf file I have: [...] plugin ...
0
votes
1answer
733 views

MySQL port 3306 became filtered when configured with Keepalived on Ubuntu server 12.04 lts

I'm configuring two load balancer (lb01 & lb02) with keepalived for my two mysql server (db01 & db02) with standard port 3306. There is virtual ip address (192.168.205.10) to access it also ...
0
votes
1answer
32 views

I changed mysql root password and I cant access It. password contained some chars

using this command I changed root password mysqladmin -u root password fg$pkh@567fghu And now I cant access mysql. Is this because mysql parse the chars other than what I expect? Also I ...
0
votes
1answer
47 views

yum update MemoryError 1G memory free

I am trying to do yum update and getting "MemoryError". The server (OpenVZ box) has 2G RAM and Percona MySQL server running with 1G InnoDB buffer configured. The OS is CentOS 6.5, kernel ...
0
votes
1answer
19 views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
-1
votes
0answers
133 views

mySQL: General error: 2013 Lost connection to MySQL server during query

I have a VirtualBox instance running on my OSX/Mavericks laptop. Within that instance I am running a stack consisting of, among other things, MySQL 5.1.66, PHP 5.3, Java 1.7 and Tomcat 6. Well, my ...
0
votes
2answers
949 views

OpenVZ MySQL InnoDB won't start

I have a OpenVZ Server with 4GB RAM and have tried to install MySQL on several distros (Ubuntu 12.04 64Bit, Ubuntu 12.10 64Bit, Debian 7 64Bit) and I always get the same errors: 130718 6:57:27 ...
0
votes
2answers
39 views

how to pipe a mysql dump to s3cmd

I want to transfer a mysql dump, compressed, to s3. I tried: mysqldump -u root -ppassword -all-databases | gzip -9 | s3cmd put s3://bucket/sql/databases.sql.gz but then I get: ERROR: Not enough ...
2
votes
3answers
115 views

Mysql crashing, oom-killer, out of memory, tuning issues?

I just moved all of my websites to a new server with 4GB RAM. Almost immediately, mysql started crashing, and at one point, didn't reboot which caused a major outage (since I didn't notice until ...
1
vote
1answer
300 views

MariaDB replication not auto reconnecting

I've got a simple master-slave replication setup amongst two MariaDB 5.5 servers. The connection between the servers is somewhat flaky, causing disconnections every now and then. However ...
0
votes
0answers
16 views

ProFTPd mod_sftp mod_sftp_sql

I am working on Ubuntu 12.04 I have setup a ProFTPd service with SSL/TLS, virtual users stored in a MySQL database and quota (mod_tls, mod_sql, mod_sql_mysql, mod_quotatab, mod_quotatab_sql). It works ...
0
votes
1answer
18 views

Cat pipe mysql : Stopped. What stopped and how can I fix that?

I imported a large database from remote using a cat + mysql command : cat my_db.sql | mysql --host=external_host --user=my_user --password=some_password my_database And after some time, it returned ...
0
votes
0answers
18 views

Oracle 6.5: MySQL Daemon failed to start

I installed MySQL by following these instructions on my Oracle Linux Server release 6.5, specifically using the yum package installer command, yum install mysql mysql-server mysql-libs mysql-server ...
1
vote
0answers
18 views

Issue while setting up a DSN while creating a linked server

I am trying to set up a linked server to my sql from sql server. However I am encountering problems while setting up the dsn. Reffering this link for help. My MySQL database resides on Amazon ec2 ...
1
vote
2answers
504 views

Changing MySQL startup timeout ([fail] reported although mysql properly started)

I've created a script to cleanup InnoDB storage engine. Everything works fine except that creating the ib_logfile0 and ib_logfile1 files when innodb_log_file_size is set to 1GB takes a while which ...
2
votes
3answers
787 views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
4
votes
1answer
1k views

how to troubleshoot using rsyslog to output to a mysql database

Using FreeBSD 8.0 32 bit. I have installed rsyslogd 5.5.5 with ommysql. (installed ports /usr/ports/sysutils/rsyslog55 and /usr/ports/sysutils/rsyslog55-mysql) My rsyslog.conf file looks like: ...
1
vote
2answers
1k views

Error code 1005 (errno: 121) upon create table while restoring MySQL database from a dump

I have a linux prod machine and a Win7 64bit dev machine. My workflow includes dumping the production MySQL database on the linux machine and restoring it in my local MySQL database on the windows ...
0
votes
0answers
28 views

User Uploaded Images– Blank Post – Connection reset by peer / FastCGI: incomplete headers

To give a little background, I have a website that permits users to upload images. WordPress is used as a content management system and the posts are immediately published with the image inserted as ...
2
votes
1answer
46 views

What database permissions to grant for Postfix using MySQL?

I'm trying to set up a Postfix mail server using MySQL for the mapping tables. As it's bad practice to simply grant all permissions unless they're needed, I want to grant only the minimal permissions ...
3
votes
1answer
800 views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is ...
1
vote
1answer
91 views

Suspicious Connections to My Database x.x.x.x Could Not Be Resolved

I have some dynamic content on my website that gets data from a database from a remote MySQL server. I recently rebuilt that server and have seen some strange activity in my logs. I searched a couple ...
0
votes
1answer
1k views

MySQL ADO.NET Connector & MSSQL Integration Services

Here I am, day three... attempting to sync a data view on a Windows Vista box (64 bit) running MSSQL 2012 and Visual Studio 2010. Sanity is slipping and hunger for progress fills my attention. I ...
0
votes
0answers
5 views

Error 1064 on MySQL Procedure [migrated]

I create a procedure like this DELIMITER $$ CREATE PROCEDURE proc_tambah_na ( IN v_nis VARCHAR( 20 )) BEGIN DECLARE v_selesai INTEGER DEFAULT 0; DECLARE v_semester INTEGER; DECLARE v_nilai INTEGER ...
0
votes
1answer
49 views

trouble running mysqldump on Ubuntu via cron job

I'm trying to set up a cron job to back up my database every night at midnight. Based on a few tutorials I've read, I've written a script that executes the following command: mysqldump -u my_username ...
0
votes
1answer
37 views

Re-ocurring issue with keys on temp tables

We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb. Last week I started doing 12 hourly backups with innobackupex because mysqldump ...