MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
1answer
28 views

IP6Tables: How to enable external access to MySQL?

How to enable external access to MySQL with rules on ip6tables? I have tried to the rules below, where after inserted I get access, but when server restart the access remains blocked. :INPUT DROP ...
0
votes
2answers
75 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
47 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
1answer
21 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 ...
1
vote
1answer
65 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
135 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
625 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
80 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
84 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 ...
-2
votes
2answers
66 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
78 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 ...
1
vote
0answers
455 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
32 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
29 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
80 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
77 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
31 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
60 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 ...
3
votes
1answer
1k 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, ...
0
votes
1answer
31 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 ...
0
votes
1answer
100 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
31 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
3answers
128 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
90 views

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
31 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
154 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
40 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
48 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
110 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
71 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
85 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: ...
2
votes
1answer
103 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
52 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
44 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
92 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
1answer
71 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
184 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
81 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
316 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
143 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
45 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
51 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
56 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
150 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 a while, and then going back down. This didn't use to be ...
-3
votes
1answer
327 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 ...
1
vote
1answer
77 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 ...
3
votes
1answer
107 views

Enable HugePages on Linux for multiple services/processes

On one of my Debian machines I'm running a service on a JVM and a MySQL instance. I have enable the HugePages following various online guides but I'm having a problem. Here is my configuration: ...
-1
votes
1answer
48 views

make mysql to share all cpu

I am very new to linux server .I am using centos.Sometimes my cpu gets overloaded because of the process mysqld over 100% PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND ...
0
votes
1answer
206 views

Access db with dynamic IP using windows Application C#

I want to connect a Desktop Application (C#) with a website which is hosted on BLUEHOST Server (Shared Hosting). I have to add an IP on server to allow for remotely access to mysql database. But the ...
0
votes
2answers
481 views

SQLSTATE[HY000] [1045] Access denied for user 'admin'@'localhost' (using password: YES) [closed]

I've changed the password for admin user of mysql in phpmyadmin and now I can't access neither my Plesk panel and neither mysql via ssh. The error it triggers is: SQLSTATE[HY000] [1045] Access denied ...