MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (7)

1
vote
3answers
1k views

MySQL access denied error when connecting via SSH tunnel

For months I've been connecting to the MySQL instance running on our local test server through an SSH tunnel without any issues. All of sudden though, with no changes I can think of, the server has ...
2
votes
1answer
542 views

Zabbix: How do I configure a Trigger which will check if a specific value has been changed in the last 10 minutes?

I've been given the task to monitor a specific value in some MySQL server database, I need to raise a notification if the value has not been changed in the last 10 minutes. I've added to the ...
1
vote
1answer
280 views

MySQL: mysqld_safe works but unable to start mysql service, why?

I'm using MySQL 5.6.19 on a Centos 5 machine. I removed the data dir and created a new one with: mysql_install_db --user=mysql --datadir=/var/lib/mysql When I run: mysqld_safe & all works ...
1
vote
2answers
205 views

Spammer spoofed localhost? Or server fail? How do I secure against this?

I noticed a spammer got through postgrey AND SpamAssassin, which was very strange. I examined /var/log/mail.log and saw some suspect lines: Log below, or on Pastebin: http://pastebin.com/k7sKnvGE ...
1
vote
2answers
188 views

how to test server's performance online?

I have three Liferay portal -- ApacheTomcat 7 running on a Dedicated server (RAM : 32 , CPU 8 cores, 3.4 Ghz). All portals are running on the same Mysql instance. The problem is the response of the ...
1
vote
1answer
75 views

MySQL suddenly taking 2000 ms per request, instead of 200

UPDATE: finally remembered to look at munin, and it seems that one of the HDDs is the root of the problem after all, unless I'm totally reading this wrong. Here's the munin output: ...
0
votes
1answer
62 views

MySql Replication Stored to Central Database

Hi I maybe looking with the wrong terminology. But i have a situation where i need to replicate / copy data to a centralized database. Shop1.dbshop - > Central.dbshop1 Shop2.dbshop - > ...
1
vote
2answers
8k views

how to fix corrupt, not cleanly closed and upgrade needing tables in mysql

When I restart mysql server in Debian, I always have the below messages. How to make the messages disappear or fix the problem/corrupted tables? debian:~# /etc/init.d/mysql restart Stopping MySQL ...
1
vote
1answer
357 views

mysql can't use locks with log tables

When I run mysqlcheck command in Debian MySQL 5.1, I get the below messages: Debian:~# mysqlcheck --all-databases -u root -p Enter password: mysql.columns_priv OK ...
0
votes
0answers
69 views

How to create a new MYSQL charset?

I am trying to configure roundcube webmail and I get the error "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/))" I fixed this before on my website by adding ...
0
votes
1answer
73 views

MySQL not accepting password, responds with using password: NO

I'm telling mysql to prompt for a password but it won't acknowledge it: mysql -h xxxxxx.xxxxxx.us-east-1.rds.amazonaws.com -P 3306 -u root –p response: Access denied for user 'root@%'@'10.10.1.1' ...
-1
votes
2answers
903 views

install mysql on centos7 with RPM

When I try to install mysql via the rpm: wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL- 5.6.19-1.linux_glibc2.5.x86_64.rpm-bundle.tar tar xf ...
1
vote
1answer
259 views

Configuring MariaDB to log to mysql.log using rsyslog

I'm a little stumped - there is something obvious I'm missing here. Recently I made the switch from mySQL to mariaDB. Everything is working so far - except for the logging, as I realized today. All ...
4
votes
1answer
281 views

Latency & speed considerations between 2 servers on Amazon EC2

I'm setting up a system that consists of: 2-4 database servers 2-4 webservers (running Node.js) The webservers use the database servers heavily. Aside from connecting to the private IPs of the ...
1
vote
1answer
369 views

MySQL service won't start, Error 5

The MySQL56 service will not start giving me the error: Windows could not start the MySQL56 service on Local Computer. Error 5: Access is denied. The last time I was able to get into MySQL was the ...
1
vote
1answer
63 views

Unable to start MySQL server while configuring MySQL Cluster using its auto installer GUI?

We are trying to configure MySQL Cluster using its Auto Installer GUI. When we click on 'Deploy and Start MySQL Cluster' button, it showing a small popup with progress. Once it is reached at 57%, ...
0
votes
2answers
78 views

What is the best/most secure way to download/send/keep offline backups?

I have a small app that uses MySQL. I'm on a small Ubuntu box using Apache on Digital Ocean. In case anything ever goes wrong, I would like to have something that periodically sends me or downloads in ...
0
votes
2answers
80 views

Why can't I add / change permissions for mysql

Every time I try and add a permission I get the following error: ERROR 2013 (HY000): Lost connection to MySQL server during query This happens using mysql in the terminal and through PhpMyAdmin ...
2
votes
1answer
104 views

suPHP and Apache DBD : change GID only

(Note: if you're familiar with suPHP setups and want to skip the question's details, you'll find a quick explanation of what I'm trying to achieve at the end) I am currently setting up a machine to ...
0
votes
1answer
47 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
0
votes
1answer
40 views

Tons of apache processes running on a very low traffic development server

I have a development server that is having memory problems. There is little to no traffic on this server because it is a dev environment, but apache is spawning tons of processes and using up a lot of ...
-1
votes
2answers
223 views

CENTOS Vs Windows 2008 R2

We have an application running on Windows Server 2008 R2 with Apache WAMP, Tomcat, Mysql, PHP and java SE for last 4 years. Its a Web based ERP application. I would like to know if it makes sense to ...
0
votes
1answer
42 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. ...
1
vote
1answer
106 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 ...
3
votes
2answers
267 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
214 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
81 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 ...
0
votes
0answers
97 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
58 views

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

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
95 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
1answer
43 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 ... ...
0
votes
0answers
158 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
371 views

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
140 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
105 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
328 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
57 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
45 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
110 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
41 views

MySQL incorrect result of insert [closed]

Created table 'testload' on demo database (int (15)) ...
1
vote
2answers
209 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
1answer
391 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
1k 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
2k 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
72 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
165 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
90 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
vote
1answer
439 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
68 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
81 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 ...