MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
19 views

URL routing for domains

I have a site with 10's of thousands of users. Each user has their own site hosted by me at a subdomain of mysite.com/user1 or as an add on domain at user1.mysite.com or user1.com. This is all done ...
0
votes
1answer
17 views

icinga2 mysql connection issue

I followed all the install wizards When setting up icinga2, I have the following error: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) ...
-2
votes
0answers
9 views

How to create a sub project in weblate? [on hold]

I just setup a new server with weblate software send I have no clue how to set correctly a sub project with github source. Can anyone please post a model to follow? The documentation at weblate is ...
-4
votes
0answers
31 views

nginx after one or 2 Hour error

my site is joomla and i config windows server 2008 r2 to mysql php and nginx it work ok but after 1 or 2 hour suddenly show error page?! this is my configuration: worker_processes 32; events { ...
0
votes
1answer
11 views

Munin not warning on trespassing warning level

I have a Munin installation which surveils a bunch of servers. Two of them have MySQL replications running of which Munin plots the slave lag by use of mysql_slave_status. [mysql-slave.nmk.loc] ...
0
votes
1answer
36 views

Mysql Allocates too much ram

I am using a 4GB VPS from 1&1 and the main mysqld process is allocating up to 2GB, though never using more than 100mb from them. Should I be worried about this and how can I optimize it? (Running ...
0
votes
0answers
6 views

MySQL (InnoDB) - processes waiting on futex

Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
0
votes
0answers
15 views

Why binlog capture only postions [migrated]

Please help me out, why master server records only position not statement. ### INSERT INTO `sanma`.`response` ### SET ### @1=743096223 ### @2=0 ### @3='IR' ### @4='UnderProcess' ### ...
0
votes
2answers
29 views

CentOS root user crontab for mysqldump

I am using CentOS 6.6. I am trying to set up a crontab. I made an .sh script which runs perfectly when executed manually. The command is following: mysqldump --skip-lock-tables --single-transaction ...
0
votes
1answer
32 views

MySQL frequently starts returning empty results on SELECT and throws no errors. After restart it starts working as expected

MySQL started frequently returning empty results to all queries on all databases until I restart it after which it again works as expected. No errors are thrown or logged and the MySQL server keeps ...
0
votes
0answers
20 views

mysqld got signal 11 server halted

Since few days my mysql server halting whole server and I found such information in log 150129 21:22:35 [ERROR] /usr/libexec/mysqld: Sort aborted 150306 17:55:55 - mysqld got signal 11 ; This could ...
0
votes
3answers
42 views

Doing a backup with mysqldump and drop it on another server (Bash)

I'm using a cron job to do backups hourly and now, I want to drop those backups on another server by default. My script is the following: mysqldump -u db_user -p db_password db_name| gzip > ...
0
votes
2answers
32 views

What information is lost on a connection when passing it through a aws load balancer?

Bit of a newbie question here. What happens when traffic is forwareded through a load balancer? I had always assumed that load balancers just forwarded connections from clients to one of a set of ...
-1
votes
0answers
17 views

What is the best way to run PHP script every 30 seconds? [duplicate]

I have kind of a special requirement that is, I'm using a Raspberry Pi 2 B device to feed some data to a mysql database in a cloud serve. So I have installed LAMP stack on raspberry pi and config my ...
1
vote
1answer
24 views

Roundcube MySQL/session issues, “no valid session data found”

So Roundcube is connected to MySQL fine, and is running queries. However, whenever I login, I get a "Your session was invalid or expired." error. From some PHP debugging, I think it has something to ...
0
votes
0answers
9 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
20 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
39 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
10 views

Upgrade MySQL Client API Library Mac OSX 10.10.4 [closed]

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
18 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
17 views

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

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
16 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
49 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
23 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
10 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
20 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
45 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
77 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
98 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
40 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
50 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
45 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
33 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
141 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
17 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
49 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
41 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
22 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
30 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
243 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
27 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
63 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
28 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
67 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
87 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
18 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
61 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
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: ...