MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
3answers
42 views

MySQL configurations are not saved after restarting windows server machine

I have a PHP application hosted on a windows server 2008 R2 machine. I had a problem with strict mode in MySQL and solved it by disabling the strict mode using the following command set ...
2
votes
1answer
1k views

InnoDB “log sequence in the future!” crashing, won't start

I stopped mysql only to find that it wouldn't come back up, /etc/init.d/mysql start only outputs . . . . . . failed. I've narrowed it down to an issue with InnoDB. The database starts when ...
0
votes
1answer
34 views

how do you secure mysql without a server root password?

I'm currently trying to install mySQL server on a centos6.5 server. I do not have a root password because i use a SSH Key Pair to access the server. During the installation process the prompt says: ...
1
vote
1answer
25 views

How does ubuntu, mysql determine hostname?

This is the specific Q: I have apache running on ubuntu in parallels and mysql running on this VM and on the host OS X. Since I try to emulate my production environments locally I connect to the ...
1
vote
1answer
41 views

Dovecot not running quota sql query

I'm trying to configure dovecot to handle quota limits. I have followed a guide and configure the right steps. I even compared them with our current mailserver. The problem is, Dovecot doesn't ...
5
votes
2answers
3k views

Is there any way to disable grouping databases in phpMyAdmin?

If you have db names like test_db1 test_db2 phpmyadmin would create a group test. The group appears in the left side-bar with related databases displayed under it. How can I disable this feature?
1
vote
1answer
40 views

OpenShift: MySQL PDO 'connection refused', works locally

I have an API i want to deploy to OpenShift, everything works locally, but when trying to use it online i get some problems. When trying to connect to the database, using PDO, i get this error: ...
3
votes
1answer
46 views

HAProxy balance algorithms for Apache and MySQL

just recently I got responsible for an existing project that uses Apache webservers and MySQL databases. The webserver are behind a HAProxy loadbalancer and the application connects to the MySQL ...
6
votes
2answers
6k views

Amazon RDS Instances: db.m1.large vs db.m3.large

Recently, Amazon announced new instance types for RDS. Currently, we are running db.m1.large, and it looks like the new db.m3.large is comparable but cheaper. Before moving these over, I wanted to ...
2
votes
1answer
846 views

MySQL HA and Magento DB

Is it possible to use MySQL cluster for Magento DB? I have Web app developed in Magento E-commerce platform and I want to make DB highly available using the MySQL cluster. Magento supports only InnoDB ...
1
vote
1answer
55 views

connect mysql server installed on t1.micro instance from vpc t2.micro instance

I have mysql database server installed on ubuntu in t1.micro ec2 : Instance state: running Public IP: 50.xxx.xxx.xxx Instance type: m1.medium Elastic IP: 50.xxx.xxx.xxx Private DNS: ...
5
votes
2answers
108 views

MySQL package upgrades (Debian apt-get) always break master-master replication due to changes in mysql schema

I have master-master replication set up on 2 Debian servers, and they replicate everything, including the mysql database itself (so that new users and such also replicate). This generally works very ...
0
votes
1answer
935 views

Apache not loading: libmysqlclient.so.18: file too short

I have installed MySQL and PHP, and I tried restarting apache and here what happens when I run # service httpd restart: Stopping httpd: [FAILED] ...
2
votes
3answers
5k views

Error importing large MySQL dump file which includes binary BLOBs in Windows

I'm trying to import a MySQL dump file, which I got from my hosting company, into my Windows dev machine, and i'm running into problems. I'm importing this from the command line, and i'm getting a ...
0
votes
2answers
36 views

Redirect a port to a blocked port but with the filter to unlock it

I have all ports with iptables dropped for security reasons, now i want to open a port which redirects the traffic to a blocked port, but it will open if the traffic comes to this port. Let's see, i ...
0
votes
3answers
641 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 ...
0
votes
0answers
35 views

MySQL slow file I/O

I got a little issue with MySQL having slow file IO. When benchmarking 1k blocks (I did them on purpose that small for worst-case) I get an hdd speed of about 2MB/s. When looking at iotop while ...
4
votes
3answers
102 views

Replicating a linux web server

I'm planning on replicating a web server for high availability purposes. The server is running as a Ubuntu 15.04 virtual machine in Hyper-V and has MariaDB 10.0, Apache 2.4 and PHP-FPM 5.6 installed. ...
0
votes
1answer
37 views

Import file bug [closed]

I am trying to import a table into PHPMyAdmin, my database has 2 tables, one of which is labelled "table 3". When I try to import a database into PHPMyAdmin it doesn't bother to check if a table ...
2
votes
3answers
1k 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, ...
0
votes
1answer
2k 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 ...
2
votes
4answers
7k views

Mysql server fails to start

Googling since two hours, I require your assistance. I'm on a Debian virtual machine and I cloned it. The only change is the new IP adress it has. Mysql doesn't start any more: Starting MySQL ...
0
votes
1answer
2k 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
35 views

Creating my.cnf leads to error with innodb

I got access to an existing mysqld server (5.5.35 from Debian Wheezy) with existing data in production use. I found no existing configuration file in /etc/my.cnf or /etc/mysql/my.cnf. So I copied the ...
0
votes
0answers
21 views

Migrate MUC (multi-user conference) data from Mnesia to MySQL in ejabberd

Ejabberd's mod_muc module supports db_type option, which can be either internal (Mnesia) or odbc (MySQL) to store MUC-related data. Is it possible to migrate from Mnesia to MySQL saving all the ...
-2
votes
1answer
56 views

Running phpMyAdmin from its Git Repo?

On all my servers, I run phpmyadmin using the STABLE branch of the phpmyadmin git repo (https://github.com/phpmyadmin/phpmyadmin/tree/STABLE). This allows for very easy updates/rollbacks. On ...
0
votes
3answers
5k views

phpMyAdmin: #1045 - Access denied for user 'root'@'localhost' (using password: YES).

I am getting in phpMyAdmin the famous #1045 error: Access denied for user 'root'@'localhost' (using password: YES). This is my /etc/phpmyadmin/config.inc.php: /** * Server(s) configuration */ $i ...
0
votes
2answers
2k views

How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts

I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's going to be an offline install so there's no access to the repository. The only MySQL package ...
2
votes
1answer
753 views

phpMyAdmin doesn't allow users to log on [closed]

When the auth_type is set to cookie, phpMyAdmin won't allow anyone access. Putting the same credentials we are trying on the form into the config file works. Does anyone have any ideas what could be ...
-1
votes
1answer
48 views

How can I deal with failures when connecting to a MySQL cluster?

Our company has created two MySQL servers that are kept in synch using a master-master strategy. The two-machine cluster is managed using crmsh. This is only a high-availability cluster, meaning that ...
1
vote
0answers
160 views

Installing php-mysql on centos 6.5 fails due to conflicts when percona client 5.5 also installed

Some background: I'm writing a Chef cookbook to set up a LNMP stack for local development. It requires the php-mysql library for PHP 5.4 (using the php package). We're using the yum-remi repository ...
14
votes
1answer
935 views

PuTTY typing its name into the console

I was doing a MySQL dump over SSH using Putty, and now it is just typing PuTTY over and over again into the console, Ctrl+C doesn't do anything. Does anyone know why this is happening?
4
votes
2answers
414 views

Changing phpmyadmin root password

I'm trying to figure out how to change the root password for phpmyadmin. I've tried doing this a few times using this: $ mysql -u root -p use mysql; update user set password=PASSWORD("NEWPASSWORD") ...
2
votes
1answer
100 views

Overwriting phpMyAdmin

I am using Centos 5.5 and had phpMyAdmin version 2.11.11 installed. I couldn't find a way to update it, so what I did was do a manual download, backed up /usr/share/phpmyadmin, then replaced that ...
2
votes
2answers
2k views

How to grant and revoke rights to tables using phpMyAdmin

Is phpMyAdmin capable of granting rights (permissions) on certain tables to users or roles? When I look at the page of a database table there is no "rights" tab. I have only found a place where I ...
0
votes
1answer
82 views

Can't access mysql docker container from the host

I have a debian server with docker 1.6.0 on it with a running official mysql container (https://registry.hub.docker.com/_/mysql/). I use a fairly basic firewall configuration in which all ports are ...
3
votes
3answers
1k views

Amazon RDS Pros/Cons of Multiple DBs per instance

I run two completely independent websites. I am moving their MySQL databases to Amazon RDS. I'm not going to do Multi A/Z deployment - let's remove that variable from this question. I'm not sure ...
0
votes
1answer
1k 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 ...
3
votes
3answers
1k views

Monit can't detect MySQL, but I can

Monit is configured to watch MySQL on localhost at port 3306. check process mysqld with pidfile /var/lib/mysql/li175-241.pid start program = "/etc/init.d/mysql start" stop program = ...
0
votes
0answers
17 views

Installation for mysql_config with Percona already installed

I have a CentOS 6.6 installation with Percona XtraDB Cluster client installed on it. This version of Percona is a project requirement and can not be uninstalled. But I need the MySQLdb for Python ...
0
votes
1answer
47 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
74 views

Is it better to store the MySQL database directory on a separate RAID 1 device?

We have a Linux server with a RAID 1 using two HDDs on which runs a Apache server managing multiple sites and some other services that interact intensively with the databases and produce massive ...
3
votes
2answers
93 views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; ...
11
votes
4answers
4k views

How to reset or recover admin account password for MySQL?

I have a MySQL database that I "inherited" and I was not given the admin credentials. I do however have access to the box that it runs on. Is there a way to either recover the admin credentials or ...
2
votes
1answer
31 views

Server error with large posts

On a large drupal site, the database server is on a separate server connected directly to the web server. The web server uses apache and memcached. The problem is that whenever the post is a large, ...
1
vote
1answer
32 views

MySQL not allowing remote connections from new server

I currently have one server that's connecting to a centralized MySQL server (say, 192.168.0.10). This server already allows remote connections from this IP address (say, 192.168.0.20), and in spite of ...
0
votes
1answer
31 views

mysql and redis services unavailable during high traffic times

I've have a webserver that runs some services like Apache, Mysql, Redis and some NodeJS apps. On times of high traffic my server seems to do not support the heavy load. When it's ocurring, often when ...
1
vote
1answer
52 views

Unable to Create MySql 64-bit System DSN on windows

I have a very similar problem to this: Unable to Create System DSN but none of the fixes suggested there have worked for me. System: windows 7 64-bit enterprise. I'm trying to create a DSN to use ...
0
votes
2answers
2k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...