MySQL is an open-source database owned by Oracle.

learn more… | top users | synonyms (2)

1
vote
2answers
15 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
0answers
6 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: ...
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
22 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 ...
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 ...
1
vote
3answers
124 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
3answers
679 views

mysql not runnning [on hold]

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
367 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
12 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
21 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
6k 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
22 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 ...
1
vote
1answer
44 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
7 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
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 ...
-1
votes
1answer
406 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
20 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 ...
-1
votes
0answers
32 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
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 --> ...
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 ...
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
0answers
14 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
2answers
304 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
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
18 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 ...
0
votes
0answers
321 views

MYSQL IS NOT RUNNING, Wampserver icon yellow [closed]

Wamp Icon is yellow and when I check MYSQL, it shows not running. Please someone help!!
0
votes
1answer
964 views

Installing mysql-devel to match MySQL version

I'm running MySQL 5.1.52 on CentOS 4.6 and I'm trying to install mysql-devel to match my MySQL version. If I do yum install mysql-devel it wants to upgrade MySQL to 5.1.58, yet if I do yum search ...
-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 ...
1
vote
2answers
1k views

Horrible PHP/MySQL Query Performance On Ubuntu Server 10.04

I just did a clear install of Ubuntu Server 10.04 with the standard LAMP config.. Then I made a small script to test insert speeds into a table with 3 columns. When I run the script on any of my ...
2
votes
2answers
6k views

Server crashed, some MySQL databases are broken. Trying to recover with InnoDB recovery, but ibdata1 seems corrupt

I've a problem. Some days ago my root server crashes after a power outage. I realised that the MySQL server won't start. In the logs I find out that an error occured with InnoDB's ibdata1. I've ...
0
votes
2answers
1k views

How do I sync a subset of tables between two databases on the differnet mysql database server?

I have the main MySQL database which has the following columns in one of the car table: +---------------+-----------------+------+ |carId |name |model | ...
4
votes
2answers
1k views

vsftpd - PAM - MySQL and pam_mkhomedir to create directories

I've been successfully using vsftpd with virtual users connecting with PAM to my mysql DB. Now I'd like to automate creation of user directories with successful vsftpd connection. Here is ...
2
votes
1answer
80 views

searching for the correct way to compile postfix

I am experiencing issues while compiling latest version of postfix from source code. At the moment I'm trying to compile version 3 because Debian 7 and latest Ubuntu 14,10 (version 2,9 and 2,11 for ...
0
votes
1answer
1k views

MySQL (local) owner and permissions

I asked this question on the MySQL forums and got no answer. I asked on StackOverflow and received a recommendation to try on ServerFault. So here I am. I recently successfully installed the 64 bit ...
-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
22 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
22 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
33 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
0answers
14 views

SQL Queries vs HTTP Requests [closed]

i have big problem deciding what approach to take, i have many pages on my site that uses tabs. for example a page with 5 tabs (horizontal tabs). now every tab takes data from different table in the ...
0
votes
1answer
1k views

Troubleshooting MySQL Performance Issues

Environment: 1 physical machine 8GB RAM some older Core2Duo CPU 1 HDD Windows Vista 64 bit 1 Virtual Machine 16 GB RAM 2 vCPUs Windows 7 64bit Both machines running MySQL 5.5.28 (64Bit) with ...
0
votes
5answers
2k views

MySQL my.cnf file not being read, Ubuntu 10.04 64bit

I've been researching this for a few hours with no luck. Basically it looks like my server's my.cnf file isn't being read at all. I've searched my server, and there's only one my.cnf file on it, ...
2
votes
1answer
48 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 ...