MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
7 views

pure-ftpd-mysql doesnt work after install

I searched for a tutorial to install the ftp-Server correctly and I found this tutorial to install pureftpd-mysql but I can't login with the example user or any other user. I tried 2 other tutorials, ...
0
votes
1answer
15 views

MySQL - Can not connect from local network, but can connect from any other IP

Facing a really strange issue. The original requirement was to have a development server which can be accessed from our office in Sweden and from India. In our server in Stockholm, I created a new ...
0
votes
0answers
36 views

ProFTPd + MySQL + Apache

I am trying to set up a LAMP server with ProFTPd using MySQL authentication This is a dedicated server with a single website under /var/hitr/public. I'd like to use proftpd to for user's configured ...
0
votes
0answers
7 views

Upgrade MySQL Client API Library Mac OSX 10.10.4 [on hold]

On my local development machine iMac running OSX 10.10.4 I have MySQL Server version 5.6 running, but the Client API is at 5.0.11. mysql -v Server version: 5.6.24 MySQL Community Server (GPL) ...
0
votes
1answer
12 views

MySQL process in Sleep command and page is loading after 1 minute

I'm using VestCP which installed for me Apache2.2, PHP 5.5.25, MySQL Percona and Nginx. I have an app built in ZF1 which works fine on all my development computers but on this server the application ...
-4
votes
0answers
16 views

How to let your server connect from a DB located to another server? SmartFoxServer/Phpmyadmin [on hold]

When i try to start another server so ill have 2 servers in one db. but my 2nd server cant connect to db that is located to 1st server. can someone help me? I use xampp as mysql phpmyadmin.
0
votes
1answer
15 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
47 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
15 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
9 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
18 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 ...
1
vote
1answer
41 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
69 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
64 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
34 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
43 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
26 views

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

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
40 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
21 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
86 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
18 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
15 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
42 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
29 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
21 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
147 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
24 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 ...
-1
votes
1answer
53 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
3answers
64 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
81 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 ...
-1
votes
0answers
91 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
16 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
54 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
39 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
44 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
50 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
40 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
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 ...
0
votes
2answers
34 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
30 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
20 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
100 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
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 ...
0
votes
1answer
79 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
45 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 ...