MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

2
votes
0answers
823 views

MySQL root user localhost issue

I have a MySQL server (5.6) running on a virtual Debian box on my local computer. Connecting to MySQL from the localhost command line via the following command worked as expected: mysql -uroot ...
2
votes
0answers
376 views

Row is not deleted in PHPMyAdmin

I am having problem deleting a row in PHPMyAdmin. I click the 'Delete' button to delete the row, at the top it says Showing rows 0 - 0 ( ~1 total , Query took 0.0004 sec) SELECT * FROM ...
2
votes
0answers
17 views

mysql 5.1.44: -e not executing and exiting properly on OSX

This function works on 5.0.75 on Ubuntu, but not on 5.1.44 on OSX (Lion): mysql --database=sps --host=localhost --user=root --password=somepass -e "SELECT 1;" The expected output is this: +---+ | ...
2
votes
0answers
192 views

Problems with bash script, mysql inserts and launchd

I am developing a automated system, which consists of 3 parts: mysql, bash and launchd. Bash script takes folders of work related stuff, zips, archives and puts info about them into database that is ...
2
votes
0answers
386 views

MySQL crashes when connecting from localhost with tcp (UNIX sockets work)

I have Ubuntu 12.04 running MySQL server 5.5.24. I can connect with mysql --user root -p. status shows me : ... Connection: Localhost via UNIX socket ... When I try to connect with mysql --host ...
2
votes
0answers
175 views

How to get munin to alert for NaN

I am using this mysql slave status plugin and on the munin master I have added... mysql_slave_status.warning 30 mysql_slave_status.critical 60 So it alerts whenever the slave gets behind the ...
2
votes
0answers
163 views

PHP web application can't connect mysql installed with Zend Server CE on SuSE Linux 11.4

I had a running LAMP system. SUSE 11.4 with Apache 2, MySQL and PHP 5.3 Then I installed Zend Server CE. Everything is OK, but now I can't connect it to MySQL. The MySQL Server is running. If I ...
1
vote
0answers
8 views

Apache and MySql datbase memory consumption issue with Django

I'm writing a relatively simple web-application as a learning project to learn Django, Apache, Mysql etc. in practice. It consists of a web flash/html5 client which makes two API-calls to Django ...
1
vote
0answers
61 views

mySQL doesn't start in XAMPP on Windows 8

I installed XAMPP. Apache is getting active but when I try MySQL, it doesn't start. I will appreciate if someone can help me. Looks like RC=0 but it doesn't do anything. It gives the following ...
1
vote
0answers
101 views

Corrupted MySQL index caused data-loss! How to recover data?

Introduction to my problem is following. A few days ago I wasn't able to start MySQL service in Wamp! Well, I was google-ing a lot to find solution why it doesn't start and some guy suggested to ...
1
vote
0answers
10 views

encfs mysql datadir: Errcode: 13

I'm using encfs to encode the /var/lib/mysql data directory, but mysql returns Errcode: 13 at any attemp of create tables or databases. To do so, I moved all files to a temporary dir, created the ...
1
vote
0answers
41 views

How to keep mysqld alive with minimal memory?

I have a rackspace server that I have been renting to run my personal projects upon. Since I am cheap, it has 256Mb of RAM and honestly can't handle a lot. Every once in a while, when there is a sharp ...
1
vote
0answers
29 views

How to forward data to mysql server using socket module in python

How to forward data to mysql server using socket module in python, i have try to import socket and connect it to mysql server for test, but have no data received from it, my code like this def ...
1
vote
0answers
81 views

resolving host names from parallels (windows) to Mac (mavericks)

I was given a macbook for work that is running mavericks. We also do windows development. I'm currently running windows 8.1. I set up mysql on the mac side that both the windows 8.1 running on ...
1
vote
0answers
36 views

How to prevent mysql blobs from borking my terminal

When using the linux terminal client for mysql, every column with a blob prints out tons of control characters and the terminal has to be reset. This looks something like the following Map: �PNG ...
1
vote
0answers
491 views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
1
vote
0answers
766 views

Postfix: SMTP, use port 587 rather than 465

I have set up a mail server on AWS EC2 using the instructions from Flurdy: http://flurdy.com/docs/postfix/ it has mostly gone well. My issue is that I would prefer to use SMTP port 587 with TLS ...
1
vote
0answers
319 views

The server quit without updating PID file

I am trying to install MySQL on my Mac w/ Mavericks OS. Whenever I try sudo /usr/local/mysql/support-files/mysql.server start it shows an error The server quit without updating PID file ...
1
vote
0answers
44 views

Is there any harm in using the MariaDB client to connect to a MySQL server?

I installed MariaDB on my server (both client & server), and now want to also connect to an external MySQL server from it. It seems like although the client command is mysql, the version is ...
1
vote
0answers
96 views

Synchronizing folders, configurations, programs, local server and database on 2 debian machines

I am using debian both on a laptop and inside a virtual machine on another computer. I want to be able to synchronize those 2 systems in both ways so that I can do some work say on the VM, then ...
1
vote
0answers
37 views

How to dump all MySQL databases for one specific user?

I need to export a particular user's databases so that they can take them to a different server. I have 30 or so users and many dozens of databases. This particular user alone has about 20 or so. ...
1
vote
0answers
57 views

Define default column sort order in Sequel Pro?

I am using Sequel Pro 1.0.2 on Mac OS X. In the 'content' view of a table, I can click a column header to sort by that column. This always sorts the column in an ascending order. I would like to ...
1
vote
0answers
18 views

Spreadsheet to MySQL

I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and ...
1
vote
0answers
65 views

MySql dump restore from Run Dialog (not the cmd prompt)

I need to restore a mysqldump on a windows machine, which i perfectly know how. But I need to do it via the Run Dialog in one GO. So we open the Run Dialog and type : "[PathToMysql]\mysql.exe" -u ...
1
vote
0answers
135 views

Slow MySQL in VMWare, but Apache works ok

I have OSX running VMWare with W7 Pro. This machine is configured to bridge the network adapter, so it's in the same network of OSX but with a different local IP. I installed Apache and MySQL, and I ...
1
vote
0answers
63 views

Connect from Mac Rails app to MySQL running on Windows 7 machine?

I'm trying to connect my rails app running on my Mac to MySQL running on my Windows 7 machine. They are both on the same network at my house, and I can ping my Windows machine from my Mac. Trying to ...
1
vote
0answers
62 views

How do I display a newline in a mysql prompt?

I'm trying to make my mysql prompt look like this: root@localhost:3306 database $ [mysql commands…] How might I place the dollar sign on a newline? Here's my current prompt configuration, in which ...
1
vote
0answers
152 views

Unable to install MariaDB on Debian 7

I'm trying to install MariaDB on my Debian 7 development machine and I've hit a problem. Following this tutorial, and this workaround, I enter this command: sudo apt-get install ...
1
vote
0answers
120 views

After rebooting, why doesn't sudo prompt for password when I try to start MySQL server?

I'm having a minor problem, and I'm hoping someone can help me understand why my system behaves this way. By the way, I'm a MySQL + Terminal newbie, so please go easy on me! I've done some due ...
1
vote
0answers
41 views

MySQL create custom error logfile in Apache Root

The title of this question placed in superuser's search box returned "0 Results" What. Everybody in the world but me knows how to do that? :) From the reading I did for the last hour and a half, ...
1
vote
0answers
129 views

Is it possible to delete unused media from the file system in Django, systematically?

I have a django project in which the admins are able to upload media. As items sell, they are deleted from the site, thus removing their entry in the MySQL database. The images associated with the ...
1
vote
0answers
126 views

mysqldump alternatives --hex-blob doesn't convert geometry binary columns to hex

I'm trying to create a mysqldump in utf8 encoding. The table I'm trying to dump contains geometry columns. Now, when I use the --hex-blob option, the geometry columns don't get converted to hex. Are ...
1
vote
0answers
91 views

MySQL db management through FreePBX

Is there an already prebuilt library for adding realtime DB management to an Asterisk Web-based GUI, like FreePBX ?
1
vote
0answers
243 views

Suggestions for finding performance bottleneck on LAMP server

I know this question has been asked a thousand times and I've read through a bunch of the answers, but haven't found one that really helped me. I've used top and I'm not swapping at all, I've got ...
1
vote
0answers
371 views

How can I skip the root password prompt when installing mysql-server?

I am writing a bash script that involves installing the mysql-server package on Ubuntu. The package interactively asks the user for the root MySQL password desired, however this is not good for me as ...
1
vote
0answers
331 views

What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?

I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day. I've tried a couple of options. First, my specs: ...
1
vote
0answers
471 views

MySQL not starting on Mac OSX Mountain Lion (no mysqld process running)

I'm really frustrated about a problem I have with MySQL on my Mac, it's been like two weeks since it just doesn't start, I even tried creating another user account in my mac, with the same results. ...
1
vote
0answers
294 views

mysql remote connection on Amazon ec2 ubuntu

I installed a MySQL server in an Amazon EC2 instance. Then, I made the following changes in /etc/mysql/my.cnf: bind-address = 0.0.0.0 #skip-external-locking After restarting the server, I executed ...
1
vote
0answers
49 views

MySQL formatting problems with UTF8 on Mac terminal

When I do a select in MySQL on a column in Terminal on Mac, it appears like this: +-------------------+ | my_iso8859_column | +-------------------+ |.. ....... | | ..... .... | | .. ...
1
vote
0answers
279 views

Repeating mysql error in OSX console

I'm getting an endlessly repeating set of errors in my mac's console that go as follows: Jan 6 00:21:37 Air com.apple.launchd[1] (com.mysql.mysqld): Throttling respawn: Will start in 9 seconds Jan ...
1
vote
0answers
53 views

Does MySQL Server 64-bit require 64-bit connectors on Windows 7?

On a Windows 7 64-bit machine. Is it appropriate to install: 64-bit MySQL Server 5.5 and 32-bit MySQL Connectors? Or do 32-bit MySQL Connectors require the 64-bit version of the server?
1
vote
0answers
204 views

Apache Periodically Hangs

I have a small Rackspace-hosted Debian VPS running my personal web server. In the last few weeks, there have been several times where Apache (I'm running 2.2.16) appears to be just hanging ...
1
vote
0answers
71 views

fsck did not recover all files - anything else to try or fresh install?

yesterday a server of mine (debian) went into read-only mode because of problems with the main device (ext3). I contacted the hosting support and the guy told me to boot into rescue and do a fsck on ...
1
vote
0answers
168 views

KDE's akonadi sets mysql root password to a non-empty value and I can't find it

I recently set up an openSUSE 12.2 vm and I chose KDE as the desktop. KDE (4.3) happens to come with an application called 'akonadi' which happens to use mysql. The result is that mysql seems to come ...
1
vote
0answers
123 views

WAMP and WIN 8 issues on port 80

I have tried all to get WAMP running in WIN 8 due to the problems on port 80. I changed the settings in lmhost from 80 to 8080 but I get a error localhost 8080 is not allowed.... I am using chrome as ...
1
vote
0answers
50 views

Mysql InnoDB and quickly applying large updates

Basically my problem is that I have a large table of about 17,000,000 products that I need to apply a bunch of updates to really quickly. The table has 30 columns with the id set as int(10) ...
1
vote
0answers
651 views

Ubuntu 10.04: mysqldump: command not found and wouldn't install mysql-client

Some packages have gone missing from my Ubuntu server and few things are not working because of that. When I try to install mysql-client I get this error: # sudo apt-get install mysql-client-5.1 ...
1
vote
0answers
114 views

MS Access ignores confirmation dialog when updating linked MySQL table

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver). In MySQL I created a simple table like this: CREATE TABLE IF NOT EXISTS `test` ( ...
1
vote
0answers
553 views

installed mysql using yum but mysqld dowsnt start: Fedora 16

i installed mysql mysql-server and mysql-libs ... after installation i thought to start the mysql service using command systemctl start mysqld.service Failed to issue method call: Unit mysqld.service ...
1
vote
0answers
160 views

Easiest way to install the Ubuntu Mysql Security Patch

I am looking for a quick and easy way to install the security fix for CVE-2012-2122 on my Ubuntu boxes. I don't want to risk installing any of the other updates and I just want to install the ...