MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

2
votes
2answers
296 views

Partial sync of Mysql databases on two remote computers

Does mysql replication supports delayed sync if remote slave server is OFF? For example I want to make my developing server have a fresh copy of databases each morning. It should be partial sync, ...
0
votes
1answer
31 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 ...
0
votes
1answer
2k views

Run mysqld under a different user (linux)

I've been trying to start mysqld under a different user as well as with a different data path. I've done so by modifing the my.cnf file as follows: [mysqld] datadir=/bob/database ...
2
votes
3answers
2k views

How can I synchronize 2 web server files with load balance?

I need to setup a website with load balance to accommodate more visitors, I've seen on forums that varnish(balance)->apache(web1&2)->mysql(dbserver) is the way to go. I know how to setup ...
2
votes
2answers
1k views

When to increase AWS RDS MySQL Server instance to larger CPU/RAM?

I'm wondering at what stage do I need to increase the image for the RDS MySQL server to a larger CPU/RAM instance. The CPU utilization graph is near 0. The Avg Free Memory is around 150MB. The Avg ...
0
votes
0answers
35 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 ...
1
vote
0answers
62 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 ...
4
votes
3answers
9k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
0
votes
1answer
45 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 ...
0
votes
1answer
479 views

Magento Installation on Xamp results in a Blank screen

I was installing magento on my Windows 7 where Xamp 3.2.1 is installed Copied Magento folder to htdocs Create MySQL database with a user and called localhost:8001/magento where 8001 is the port ...
1
vote
0answers
51 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 ...
0
votes
3answers
3k views

How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts

I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's going to be an offline install so there's no access to the repository. The only MySQL package ...
1
vote
1answer
89 views

Debian server, Workbench client or server side?

We have a server running Debian squeeze with mysql and until now we manage the db through phpMyAdmin. In this question I was told that Workbench represents a better choice than PMA in terms of ...
1
vote
2answers
63 views

Is it possible to use workbench to connect to a linux server and send the output to a csv or text file?

I have a user that is using workbench to connect to a Linux MySQL Server and would like to have the query results sent straight to a csv or text file on his computer. I know how to do it if I were ...
0
votes
1answer
423 views

Sharing Mysql Workbench configuration among multiple machines

Suppose I have many employees who connect to the same set of about 20 or so changing mysql servers using Mysql Workbench. I want to keep the connections, and other configuration info synchronized ...
1
vote
1answer
1k views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have MySQL installed on Ubuntu 11.10. I has been working fine for months but yesterday I started getting the following message ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
0
votes
1answer
35 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
34 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 ...
2
votes
3answers
1k views

How to speed up Drupal 7 with remote DB (not DNS resolving)

we have Drupal 7 on Ubuntu LTS virtual machine (VMWare) with MySQL 5.1 server on the same physical server, but on a different virtual machine. The Drupal website is currently under development, ...
0
votes
2answers
1k views

Apache2 Debian server falls. Out of memory

help me please with my apache problem. I got an droplet at DigitalOcean with 512mb of RAM (Debian). There are 3 sites on MODX CMS (works on php). Today morning as i think system discovered an out of ...
1
vote
2answers
69 views

Reducing the size of MyISAM table

I have a MyISAM table that currently contains about 54 million records and is 20 GB in size. Poor choices were made when this database was designed. I'm no DB pro but since this table is constantly ...
1
vote
0answers
17 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
2answers
2k views

Variable 'general_log_file' can't be set to the value of '/var/lib/msyql/ubuntu.log'

I changed the value of mysql's general_log_file variable to something else, and now I'm trying to change it back to what it was originally, /var/lib/mysql/ubuntu.log. But when I do: SET GLOBAL ...
1
vote
2answers
46 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
3k views

Can not restart mysql service after getting Error 2002 Can't connect to local mysql server

Starting yesterday, I'm getting this error when connecting to mysql: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I haven't touched my ...
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] ---> ...
0
votes
1answer
2k views

installing mysql5.6.12 in ubuntu 12.10 error:/etc/mysql/conf.d is missing

I am trying to install mysql in ubuntu 12.10. Downloaded 'MySQL-5.6.12-1.linux_glibc2.5.i386.rpm-bundle' from http://dev.mysql.com/downloads/mysql/. Extracted it and tried to install using rpm -i ...
3
votes
3answers
166 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 ...
-2
votes
2answers
689 views

mysql not runnning [closed]

i have windows 7 i just installed wamp Server 5.1 my php pages are running fine nut when i go to phpmyadmin i get this error MySQL said: Documentation #2002 - The server is not responding (or ...
0
votes
1answer
389 views

MySql Membership provider - Missing or incorrect schema

We have an ASP.NET site running on IIS 7.5 with a MySQL database using the .net connector, the membership/role providers are set in the web.config correctly and they work - but only temporarily. ...
0
votes
1answer
1k views

MySQL port 3306 became filtered when configured with Keepalived on Ubuntu server 12.04 lts

I'm configuring two load balancer (lb01 & lb02) with keepalived for my two mysql server (db01 & db02) with standard port 3306. There is virtual ip address (192.168.205.10) to access it also ...
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 ...
-2
votes
0answers
18 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
0answers
39 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 ...
6
votes
3answers
7k views

Which MySQL users have access to a database?

How can I tell which MySQL users have access to a database and what privileges they have? I seem to be able to get this information from phpMyAdmin when I click "Privileges". . . ...
0
votes
2answers
49 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 ...
2
votes
1answer
79 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
2answers
2k views

Install Navicat for MySQL on Linux Ubuntu 12.04

How do I install Navicat on Ubuntu Desktop 12.04? I have just configured a new Ubuntu 12.04. Because I'm not so familiar with the command line, I prefer to use Ubuntu Desktop so that I can have a ...
0
votes
0answers
27 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 ...
0
votes
2answers
6k views

Lost connection to MySQL server at 'reading initial communication packet', system error: 0 with windows

I found similar questions but none of them helped me with a windows machine. I originally posted this on stack overflow but it was suggested that I ask here. I was able to connect to mySQL through my ...
-1
votes
0answers
11 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 ...
-1
votes
1answer
469 views

How to release the physical and virtual memory used from the mysql server? [closed]

Several php scripts are executed via crontab on my CentOS 6.5, every php script contains a least one database request. Depending on the size and type of the php object, too much physical memory is ...
0
votes
0answers
53 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 ...
4
votes
2answers
3k views

How to avoid mysqldump warning “Skipping the data of table mysql.event”

After a recent Debian upgrade on my LAMP webserver to Wheezy, mysqldump is throwing a warning: -- Warning: Skipping the data of table mysql.event. Specify the --events option explicitly. Events ...
14
votes
3answers
43k views

How to setup a MySql server to accept remote connections?

I am installing a MySql server in Ubuntu desktop. I could connect MySql Query Browser to it when specifying the Server Hostname as localhost, but when I replace it by the machine's IP it stops working ...
0
votes
0answers
14 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 --> ...
1
vote
1answer
33 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 ...
5
votes
3answers
4k views

Couldn't execute 'show events' on mysqldump

While trying to backup all MySQL databases with mysqldump I get the following error: Couldn't execute 'show events': Access denied for user 'user'@'localhost' to database 'performance_schema'
0
votes
2answers
305 views

Why my emails being block by yahoo and hotmail?

I received a lot of complaints from my users, they say that they can't find the activation email. I didn't do any blast emails or send spam emails. But I do send over 1000 emails daily, that's because ...
0
votes
0answers
28 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 ...