MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
33 views

MySQL, NFS and symbolic links

I have been migrating an older server running apache2 + mysql under ubuntu to a new server running debian (wheezy). The migration works fine while the databases are storted localy (in our case ...
0
votes
1answer
13 views

PHP installation issue on a Windows Server hosted in the Azure cloud

I am trying to setup PHP and MySQL on a Windows Server that is currently in Azure cloud using the information from this blog post ...
0
votes
0answers
5 views

Percona: What are the implications of changing repl.commit_order?

I'm currently doing some trials of Galera Cluster with Percona 5.6. I've progressed to testing a 2 node cluster on baremetal. With repl.commit_order set to 0 (off) the TPS performance as measured with ...
0
votes
0answers
16 views

MariaDB Remote MySQL Connections

I am trying to allow multiple people to remotely connect to my MariaDB MySQL server. I'm assuming it works the same way widely across any MySQL server as I can personally connect to it from my home ...
0
votes
1answer
33 views

How to login to a server as a mysql user in order to stop the mysql server?

I have a linux server instance hosted by RunAbove where I log in as an 'admin' user using an ssh key. I need to change the mysql root password on the server manually. I'm following directions given ...
0
votes
1answer
56 views

Mysql crashed showing following errors. Is this a hack?

2015-05-17 14:50:38 1896 [Warning] Host name 'hn.kd.ny.adsl' could not be resolved: No such host is known. 2015-05-18 00:11:23 1896 [Warning] IP address '222.186.21.38' could not be resolved: The ...
-3
votes
1answer
36 views

Not able to install MySQL server on CentOS 6.6

I tried this following command [root@n yum.repos.d]# rpm -qa | grep mysql mysql-libs-5.1.73-3.el6_5.x86_64 mysql-community-release-fc21-5.noarch [root@n yum.repos.d]# But I give followed ...
0
votes
2answers
28 views

User with grant permissions cannot grant permissions for new user with and new database

I am using: mysql 5.5.43-0 on ubuntu 14.04.1 I try to create a new admin-user (admin) who is allowed to do the following things: a creating new users (dbuser1) with password - (permission "create ...
-1
votes
2answers
41 views

how to extract mysql version by bash script in centos 6

I need to extract the mysql version in a bash script on CentOS 6 for a minimum requirements check Example: # mysql -V mysql Ver 14.14 Distrib 5.5.43, for Linux (x86_64) using readline 5.1 # mysql ...
-3
votes
1answer
23 views

phpMyAdmin and roundcube web mail error - Cant log in [on hold]

I'm having an issue logging into the roundcube and phpmyadmin. I get an error just shows up with code. I run Centos6 on my VPS. I cant pin point the problem. Here are some screenshots of the errors: ...
-2
votes
2answers
35 views

RAM usage by Apache server in Wordpress Site

I need some advice as I have a VPS OpenVZ with 1GB Ram and 1GB burstable. I am running a site on wordpress and my site users are about 2000 per day. My DB size is about 90MB and I am using latest ...
0
votes
1answer
14 views

What is the next step to take when receiving this mysqldiff error?

I have a MySQL database that has been in production and saved and restored a few times with phpmyadmin and mysqldump/restore. I suspect the "production activity" has introduced some discrepancies ...
0
votes
0answers
19 views

MySQL: Show only 1 record which is less than or equal [on hold]

I want to filter my table for a specific value. There should always the next lower value be shown. +----+-----------+-------+------------+ | id | productid | lvl | value | ...
1
vote
0answers
54 views

Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) [closed]

I am using MySQL with PHP for printing details from Database. As i tried to make a new user which was successful though but, i had error from MySQL when i tried to fetch data from it , it showed me ...
0
votes
1answer
16 views

Ubuntu broken machine (backup mysql via FTP)

I cannot access my virtual machine (ubuntu 14.04). The only way to connnect is via the FTP. I really need to backup all mysql databases from there. Is this possible to just copy the whole mysql ...
0
votes
0answers
14 views

RDS MySQL A B replicate across continents?

I have a web app that I run for Australian customers hosted on AWS using RDS. Can I bi-directional replicate in realtime the database to the USA and Europe AND expect to be able to have a single ...
0
votes
1answer
37 views

mysql error when running script to dump all databases

I am having mysql server in centos which is running fine, i recently got a script to dump all individual databases to one folder, when i run that script to dump, i'm getting this error when ever i run ...
2
votes
0answers
23 views

combine two mysql replication log files

So I use a master-master replication of a mysql database and load balance traffic between the two. This results in server A with a binlog of all it's transactions and Server B with a binlog of only ...
0
votes
1answer
20 views

How exactly date/time works in MySQL with timezones?

My understanding was: everything is UTC internally dates are displayed in @@session.time_zone timezone for current session if I do INSERT with +02:00 TZ set and insert 2015-05-15 10:54 it is parsed ...
0
votes
1answer
27 views

MySql Clients connection timeout randomly

I have 100 PC clients connecting to MySQL over LAN. They're running INSERT querys with no particular period.Statistically, at the same time no more than 10 PCs are trying to run INSERT query. This is ...
1
vote
1answer
94 views

MySQL Workbench with Debian Jessie - TCP/IP over SSH does not work

I use to connect with Windows 7 Pro x64 to my MySQL server hosted on a Debian Wheezy with the MySQL Workbench client using the "TCP/IP over SSH" but it does not work on my new server on Debian Jessie, ...
-1
votes
0answers
9 views

Plesk Windows mysql root access denied even with correct password [closed]

I am using Plesk on Windows Server. I just want to login to mysql as root. I get the password as stated in here. I get the password and I am sure this is the correct password. But I get access denied ...
0
votes
1answer
22 views

Puppet - mySQL not remotely accessible upon setup (workbench)

I used Puppet's mySQL module to bring it up like this. The workstation ip is 172.16.1.49 and JIRA(mySQL) VM is 172.16.1.47 (Puppet Master is 172.16.1.80); I'm trying to access mySQL server using ...
-1
votes
0answers
49 views

SSH Connection is established on port 22, but service is not working [migrated]

I am having this recurrent issue on one of my MySQL Cluster Servers, actually always happens in any random MySQL server of this cluster, on many countries where we have this same configuration. I ...
0
votes
1answer
42 views

Puppet - mysql module not pulling “my.cnf” from fileserver

Trying to deploy mySQL puppet. Using "Puppetlabs-MySQL" module. My puppetmaster'd pp has node 'jira.oracle' { class {'mysql::server':} } class mysql::server { package { "mysql-server": ensure ...
0
votes
0answers
27 views

Are MySQL processes supposed to “die”, or stay alive?

All other processes have "time" lengths less than 5 minutes, yet MySQL stayed alive since its last restart (4 days ago). The behavior I'm observing is: MySQL process never dies and increasingly spikes ...
0
votes
2answers
51 views

MySQL keep crashing

So a little background, a few weeks ago I brought a new CentOS dedicated server in Melbourne, however it seems beside the number of attackers I get, there also seem to be an issue with the MySQL ...
0
votes
0answers
60 views
+50

Unable to query or connect, depending on bind-address

I have a simple script that is failing differently depending on the bind-address configuration. If I set bind-address to the IP address of the server and run the script the query times out. If its ...
0
votes
0answers
86 views

new pp for JIRA<>mySQL

Getting "Error: Could not retrieve catalog from remote server: Error 400 on SERVER: Could not find template 'jira/etc/rc.d/init.d/jira.erb' at ...
0
votes
0answers
12 views

MySQL error log set but not working on Windows7

MySQL (v5.6) is running as a service on a windows7 box: "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56 And my.ini ...
0
votes
1answer
47 views

Deploy MySQL/MariaDB on demand in a C# application

I'm creating a lightweight bug tracker, and I'm really having difficulties with people that don't know how to deploy and connect to a MySQL database on their own. What they should do is to create ...
0
votes
1answer
33 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
31 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
42 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 ...
1
vote
1answer
43 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: ...
1
vote
1answer
39 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 ...
0
votes
0answers
32 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 ...
0
votes
2answers
33 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
0answers
29 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
16 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 ...
4
votes
3answers
96 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. ...
-1
votes
1answer
45 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 ...
0
votes
1answer
69 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 ...
0
votes
2answers
40 views

Python Pip Install fails - Could not build the egg. Also cannot use 1.2.5 because of google cloud sql

I need mysql-python. I get error of could not build egg while installing 1.2.4 Everywhere it says install 1.2.5, which works for me too. But googleAppEngine's app.yaml supports only 1.2.4 ...
0
votes
0answers
16 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 ...
1
vote
1answer
28 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
25 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 ...
4
votes
2answers
91 views

99% disk IO spikes with Percona

So we have a server that has seemingly random spikes in disk I/O, going up to 99.x% at random times and for no obvious reason, staying high for ~1 hour, and then going back down. This hasn't been much ...
-3
votes
1answer
102 views

Mysql showing 100% CPU usage [closed]

I'm experiencing some problems with my MYSQL server installed with Cpanel. My server is showing 100% usage of mysql even if I don't have too much traffic on web. I am running CentOS 6.5x64 with 80GB ...