MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

0
votes
0answers
4 views

What would be a stable, failproof, scalable galera cluster implementation

Context: We are using a MariaDB Gallera cluster with (only) 2 master nodes for a web application. Last night we had a power failure and now we can't seem to recover the data and found out the database ...
0
votes
0answers
14 views

MySQL Access denied for 'root'@'localhost'

When I try to add new user using root account I get error #1045 - Access denied for user 'root'@'localhost' (using password: YES) I am using CentOS 6.6 Also tried to do that from terminal instead ...
-2
votes
0answers
11 views

What causes this error in startup of MySQL Workbench? [on hold]

I already reinstalled and that didn't help. What causes this and how can I fix it?
0
votes
0answers
4 views

Galera cluster implementation questions

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers. I have a few questions regarding my implementation: 1. what will happen if one server becomes ...
0
votes
0answers
18 views

my.cnf file does not reflect changes on ubuntu 12.04

Hello I am running an application install which requires thread_stack = 256k in my.cnf file. The location of the file is etc/mysql/my.cnf and I updated the value and restarted the mysql server,but the ...
-2
votes
2answers
22 views

Where to obtain MySQL community edition software updates for windows platform?

I am new to the mysql adminstration. For the Microsoft SQL Server the updates can be downloaded from the microsoft web site/ windows updates. But I am unable to find the same thing for mysql. I have ...
0
votes
0answers
24 views

SQLSTATE[HY000] [1045] Access denied for user 'root' [on hold]

OK, this happens a lot but not quite this way. I have an MySQL server running on Yosemite. I had a crash locally and restarted. I get the above error in Drupal, so I go through my checklist. ...
1
vote
0answers
13 views

libnss-mysql on freebsd 10.1

i have libnss-mysql installed on freebsd 10.1. Everything works except groups command. getent group - ok # getent group ....... froxlorlocal:*:1003:www <-- data from passwd vmail:*:2000 ...
0
votes
0answers
11 views

MAMP mysql server not running: error 2002 [on hold]

Had not used MAMP in a year since install, opened ok yesterday, was in phpmyadmin, then did other things on computer (just on MS Word, and checked news on Internet), then went back to MAMP. Problems: ...
1
vote
2answers
23 views

How to Grant Apache Access to Directory

I am currently getting a locally hosted website up and running, but have encountered problems in accessing it from the host computer and other computers, as well. I have already created exceptions in ...
0
votes
1answer
23 views

How can I make the node server with only accept some port?

I have LAMP server now I want another server connect to my mysql with another ip address how can I do that I don't know the keyword to search I will explain with the picture [client] ---> ...
-4
votes
1answer
13 views

Centos 7 mysqlreport

I am using freshly installed Centos 7 on Google cloud. I input the following: wget hackmysql.com/scripts/mysqlreport chmod +x mysqlreport ./mysqlreport And go the following: ./mysqlreport: line ...
2
votes
3answers
134 views

Allowed Memory Size Exhausted irregardless of amount, Memory leak?

I'm running a small Wordpress blog for my sister on a very common CentOS 5.11 with Apache 2 and PHP 5.3.3. Lately, we discovered while she tried to update or install anything using Wordpress own ...
0
votes
0answers
7 views

Process string before or after insert into mysql [migrated]

I have a sensor network where each sensor uploads raw measured weather data every 10 seconds to a apache/php/mysql REST API. There are a few 100 sensors sending data and this will become more over ...
0
votes
0answers
24 views

Mysql won't start because of the PID file

I've been trying to start Mysql but when I type service mysql start I get: Starting MySQL ... * The server quit without updating PID file (/var/run/mysqld/mysqld.pid). Although I know I ...
-2
votes
0answers
15 views

restore database in mysql without using query

Recently I formatted my computer. Unfortunately I forgot to get backups of my MySQL databases. But I have my previous xampp folder with me. To restore my previous database i copied my previous ...
0
votes
2answers
25 views

MySQL server has gone away error after upgrading Mysql version to 5.6

I have upgraded mysql version from 5.1 to 5.6. Step[s I have followed : I have uninstalled older version and installed new version. Reset mysql root password Restored DB dump of particular DB ...
0
votes
0answers
8 views

PDO to AWS RDS Connection Issue

We have a website written in PHP hosted on AWS EC2 instance, talking to AWS RDS database. When high traffic on the site, some users are experiencing 503 error on pages and we can see these errors on ...
-1
votes
0answers
4 views

Apache can't find QueXF in my installation

I am interested in installing QueXF on Ubuntu (Desktop, sadly) 15.04 64-bit. I followed these instructions, except with the newest versions of QueXF and its companions. I got to the point where I was ...
2
votes
1answer
52 views

Is it possible to connect to MySQL from PHP using the old password encryption protocol?

I am working on a front-end project with a legacy system. I have to access a MySQL 5.6.25 database, which is still using the old pre-4.1 password encryption protocol. In particular I have to write a ...
0
votes
0answers
26 views

Kamailio cannot connect to remote Mysql Server

I installed Kamailio 4.0 on a Ubuntu-Server 14.4 and a MySQL Server on another Ubuntu-server using Virtualbox. 192.168.0.131: MySQL Server 192.168.0.141:Kamailio 4.0 I changed the address ...
1
vote
1answer
10 views

Connect to MariaDB through SSH fails with error 2013 - Lost connection to MySQL server at 'reading initial communication packet'

I'm trying to connect to a remote MariaDB server through SSH using Navicat Premium from Windows but all the time I can't and get this error: 2013 - Lost connection to MySQL server at 'reading ...
-1
votes
0answers
34 views

Mysql - %CPU load 3000 - random timings [on hold]

For the past few months we are facing a particular issue with MYSQL load at random times. All of a sudden %CPU load for mysql will reach 3000 and never reduces even when the server is ideal and with ...
0
votes
0answers
16 views

MySQL Freezes System Preferences then Crashes Mac [closed]

So I'm trying to set up my Mac Mini as a webserver, OSX Yosemite. Ive installed MySQL but when I try run it from the preferences pane everything freezes then eventually crashes. The version of MySQL ...
0
votes
0answers
10 views

mysql galera 2-way cross-cluster replication

Scenario and setup Two mysql galera clusters in two datacenters with 2-way multi-master replication Each cluster has 3 nodes: 2 full nodes and 1 garbd node Example host names: dc1-sql1 --> ...
0
votes
0answers
4 views

Disable Primary Key [migrated]

I wanted to speed up a large insert bulk by disabling keys. So I ran the following command on a MyISAM table: alter table my_table disable keys; When I execute show index from answer_2011, I see a ...
0
votes
0answers
19 views

mysql swap file crash on freebsd

I have a low memory VPS that mysql and the swap file crash out every morning at exactly 0300. There are no cronjobs on the system that have been configured. The server is a basic LAMP development ...
0
votes
1answer
13 views

Why mysql don't start in ubuntu server?

I edit mysql config for remote connect, I paste there bind_address = 0.0.0.0 After it i tryed to restart (sudo /etc/init.d/mysql restart or start) but I see fail of it in both commands. in logs ...
-4
votes
0answers
16 views

PHPMyAdmin Full Export Issues [closed]

So today i was switching to my new webserver and when i backed up my mysql databases a did a full export.... is there anyway to import my full.sql file and still have all the databases separate and ...
-2
votes
0answers
14 views

update query field order guaranteed [migrated]

Is an UPDATE query in MySQL guaranteed to execute the field updates in order that are presented? e.g. UPDATE `table` SET `first_to_update` = `second_field`, `second_field` = `third_field`, ...
0
votes
0answers
23 views

A nginx, php-fpm, and mysql php app is very slow for no explainable reason — times out often

I have a setup of a load balancer, followed by a web server consisting of nginx, hhvm, and php-fpm. The app I speak of is using php-fpm, and all hhvm apps perform fine. When I access ...
-1
votes
0answers
27 views

Windows server 2008 - Can't access a specific IP [closed]

I have a fresh install of windows server 2008 on a dedicated server. I would like to remote connect to one of my server tough mysql. I get this error: Warning: mysqli::mysqli(): (HY000/2002): A ...
0
votes
1answer
35 views

SQL not stopping / starting

I have a Debian server running MySQL and hosting a bunch of websites. I am getting a lot of SQLSTATE[HY000] errors recently so I started investigating my SQL install. The first thing I notice is that ...
-2
votes
1answer
41 views

Reduce the amount of RAM used by MySQL

I have recently purchased a 1GB DigitalOcean Ubuntu 14.04 VPS and it is running a blog written in Python and Django. I have installed NGINX and MySQL on the same machine. My problem is that MySQL is ...
2
votes
1answer
49 views

Reading 65k rows hangs PHP/MySQL

I am developing a PHP application that processes IP adresses. I am working with mysql tables containing up to 4 billion rows. I have a script that currently needs to fetch 65536 adresses from this ...
0
votes
0answers
14 views

Why to mysql stored procedure updates twice? [migrated]

I have this stored procedure: DELIMITER $$ CREATE PROCEDURE updateTrendContentStats(IN mongoid VARCHAR(255),IN numericid INT,IN points INT,IN ctype INT,IN activity INT,IN created INT) BEGIN DECLARE ...
1
vote
0answers
25 views

Mysql_connect not reading username or password [closed]

I am running VPS on Rackspace with WHM setup. I have 3 accounts/domains setup here which were all working great. I just did an EasyApache update to add a few PHP extensions that weren't originally ...
0
votes
0answers
33 views

DRBD high iowait every 65 seconds

I have a peculiar problem: simple INSERT queries to MySQL slow down and appear in my slow q logs every 65 seconds exactly. My stack looks like: mysql56u (IUS) on CentOS over ext4 over drbd over ...
0
votes
1answer
36 views

Elasticsearch network.bind_host and network.publish_host

I have a 4gb ram machine that works as a DB server for a ios/webapp. On that machine I only have Elasticsearch and MySql installed. What I want to do now is to only allow connections to ES from two ...
1
vote
0answers
80 views

Website exploited, suspected SQL injection + PHP check bypassed, but can't explain how the latter was performed [migrated]

Background: A website I made some year ago has been recently attacked; the exploiters managed to get access to the PHP front-end I made for the client, which is used to upload files, and they managed ...
-1
votes
0answers
12 views

Linux server for Windows clients, commercial client desktop license needed? [duplicate]

I want to upgrade the windows hosts and server (server 2003, client xp) in a hotel. We have micros fidelio software running and according to wikipedia they also support oracle sql. Since we only need ...
-1
votes
0answers
27 views

Restore MySQL from files

I had an old server die that hosted a Wordpress site. I have rescued the files that lived on it but I am having trouble getting the database to work on the new server (they use the same MySQL ...
1
vote
0answers
22 views

MySQL Replication: Don't propagate failed queries to slaves

I have a simple MySQL replication setup with one master and two slaves. Occasionally there are queries that get executed on the Master which fail due to duplicate unique keys or other reasons. What ...
3
votes
1answer
139 views

How to fix Logjam vulnerability with MySQL

Since the latest openssl upgrade on my Debian server, my mysql clients are unable to connect and give the following message SSL connection error: error:14082174:SSL ...
0
votes
1answer
17 views

Postfix virtual_mailbox_maps mysql lookup on 2 different DBs

I'm trying to configure a postfix server to receive email for 2 different domains (no problem so far). But the users/mailboxes for both domains need to be looked up in 2 different tables on 2 ...
0
votes
1answer
33 views

Configuring PHP MySql extension

I am trying to load a MySql extension for PHP development. Running <?php phpinfo(); ?> I can see that the MySql extension is not loaded. This is also apparent when running a script that uses ...
2
votes
1answer
43 views

HAproxy mysql failover

I try to set up a HA cluster with Percona xtraDB Cluster for MySQL replication and HAproxy for load balancing. HAproxy works really good with apache, when apache crash or if it's not responding, ...
0
votes
2answers
100 views

Can't Track Down What's Causing Server To Go Out of Memory

For a few months now I've been experiencing random crashes on my 2GB RAM VPS Linode server. Someone convinced me to switch to self-managed hosting and I for some reason thought I could handle it ...
1
vote
1answer
21 views

Install mysql-php5 to specific php file

I'm running an Ubuntu OS 14.04 hosting Nginx with Zend Server and Apache listening on separate ports. I managed to install Zend Server without any hassle. In an attempt to run Apache beside Nginx, ...
-3
votes
1answer
27 views

How to set default file permissions? [duplicate]

I have ran these codes: sudo chown -R / sudo chmod 755 / And now my server is not working. I need to get backup copy of MySQL database How can I fix it?