MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

-1
votes
4answers
85 views

MYSQL - is LOCALHOST speedy than i.e. (domain) mysql.domain.com [closed]

I am interested, on some hosting(although they are paid hostings, for example, DreamHost. probably 000webhost too), in database server, you have to insert: mysql.domain.com (instead of: localhost). I ...
0
votes
1answer
379 views

Yum: php55w-common conflicts with php-common-5.4

I am trying to install mysqli on a CentOS machine using yum install php-mysqlnd.x86_64 on the command line but I keep getting the message: Error: php55w-common conflicts with ...
1
vote
0answers
68 views

Migrating web site from local PC to Windows 2008 R2 (IIS 7.5)

The company I work for is interested in moving a local Intranet web site I made for them from my test box to one of their servers. My testbox is running Windows 7 64x, and the server is running ...
0
votes
1answer
36 views

Unable to connect to AWS RDS instance

I have set up a AWS RDS instance. I am using "end point" as hostname to establish the connection via MySQL workbench. But the connection is failing. I am sitting behind a company firewall and as per ...
2
votes
1answer
237 views

MariaDB Galera Cluster falls out of sync easily

We're trying to debug an issue with a MariaDB cluster. We're running Maria 10.0.19 on c4.large instances in Amazon EC2; the OS is Ubuntu 14.04 (Trusty). There are three machines clustered together, ...
0
votes
1answer
35 views

MySQL slow connection

I am running a laravel application that is on a separate server than my MySQL database. If I run the query on the Mysql server it takes the expected 0.00 - 0.01 seconds to return. However when I log ...
0
votes
2answers
82 views

Can't Start/Restart MySQL. Even After Reboot

Can anybody please help me? I'm afraid of losing my data. MySQL just stop and when I try to restart or start it, I can't. When I look at the log file, I see the following info: 150712 6:36:15 ...
0
votes
1answer
111 views

Can't connect to mysql using ssl with compiled php [closed]

I have been bashing my head against a wall for a couple of days now. I just cant figure it out. I Run ubuntu 12 with plesk 12 and apache 2.2. I have tried compiled PHP 5.6.10 and PHP 5.6.11 with ...
0
votes
0answers
42 views

mysql replication stops without errors

I have this issue with master to master replication setup. Replication stops without errors, but when I make: slave stop; slave start; it is working again. mysql --version mysql Ver 14.14 Distrib ...
0
votes
0answers
5 views

ERROR 1045 (28000): Access denied for user root [duplicate]

All of my non root users can still connect and all of my websites and applications work fine. I recently discovered that I was no longer able to login as root when trying to login to phpmyadmin. I've ...
0
votes
1answer
60 views

unable to find driver - lamp debian

This is my php sample script: <?php try{ $db=new PDO('mysql:dbname=_mydb;host=localhost', 'root', 'xxxxxx'); }catch(PDOException $e) { echo "Error: ".$e->getMessage(); } ?> And I ...
1
vote
0answers
74 views

Advice Tuning my server

as many others I Learn many info from you in the past and now I manage to run server independently , now I am new to sql tuning and I been searching around the web a while now and tuning seems to be a ...
1
vote
0answers
77 views

JavaFX: Connecting MySQL database remotely on a hosting provider. SECURE? [closed]

My JavaFX Desktop Application is currently connected to a hosted MySQL database remotely on bluehost. I query "SELECT", "UPDATE", "DELETE" on my JavaFX Application and successfully done. I am using ...
2
votes
2answers
144 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
1answer
24 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
1answer
48 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
38 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 ...
1
vote
0answers
22 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 ...
1
vote
2answers
80 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
25 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] ---> ...
3
votes
3answers
192 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
48 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 ...
0
votes
2answers
69 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
33 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 ...
2
votes
1answer
100 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
79 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
58 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 ...
0
votes
0answers
20 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
41 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
23 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 ...
0
votes
0answers
75 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 ...
0
votes
1answer
84 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
59 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
64 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 ...
1
vote
0answers
34 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
52 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
134 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 ...
2
votes
1answer
40 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 ...
4
votes
2answers
331 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
24 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
46 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
111 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
125 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
26 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?
0
votes
0answers
14 views

monit mysql not monitored centos

I've been successfully using Monit for several months now and MySQL is one of the services that I've been monitoring without issue. My Monit config is all still in place: Check MySQL check ...
0
votes
1answer
101 views

What do “key buffer size” and “total MyISAM indexes” unit sizes mean?

I ran MySQLTuner on my database to check if things are working correctly and optimally, but I was confused as to the units used for these two values. Here is what the output looks like for ...
-1
votes
4answers
119 views

Check if remote mysql is running

I want a bash shell script that i can run using a cron job to check if mysql on a remote server is running. If it is, then do nothing, other start the server. The cronjob will be checking the remote ...
0
votes
0answers
23 views

mysql-ha in cloud failover

we have mysql linux 5.6 databases in AWS EC2 and we like to implement a multi region HA solution so we have no downtime and can fail over, what steps tool strategy you suggest?
0
votes
1answer
38 views

Load testing after 5minutes MySQL Access denied for user 'root'@'

We are running a load test using Loadrunner, for the first 5 minutes, everything was great but after 1600vus, I saw the MySQL log file contains the Access denied for user 'root'@'ip error. Anybody ...