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

learn more… | top users | synonyms

3
votes
0answers
161 views

Can't connect to local MySQL instance when ran as service

I've been running a local MySQL server for development purposes lately and for some reason never got around to running it as a service so I was constantly starting it up using the mysqld.exe every ...
2
votes
0answers
47 views

Microsoft Excel to SQL using Pentaho: syntax error in 'OPTION SQL_SELECT_LIMIT=DEFAULT'

I've been using Pentaho Kettle version 5.1 to transfer Excel data to SQL by following these steps (answered by Edgar: Launch Pentaho Kettle (Typically) click on 'No Repository' Create a new ...
2
votes
0answers
21 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 ...
2
votes
0answers
1k 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 ...
2
votes
0answers
1k 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
451 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
207 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
493 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
193 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
168 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
58 views

After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)

I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
1
vote
0answers
117 views

Mysql Failed to started after mysql dump restore process

i tried to restore a db backup to a newly created database, suddenly its starts showing error. Can't connect to local MySQL server through socket /var/run/mysqld/mysqld.sock so i checked ...
1
vote
0answers
24 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
191 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
307 views

Mysql socket error 2002 on Linux Mint - Access denied

My apache and xampp servers are running on port 2145 and 16443 respectively. sudo /opt/lampp/lampp restart Restarting XAMPP for Linux 1.8.2-5... XAMPP: Stopping Apache...ok. XAMPP: Stopping ...
1
vote
0answers
857 views

I have a MySQL 5.6.17 server on OSX 10.9.2 that “sometimes starts”, and most of the time don't

I have setup a MySQL 5.6.17 server on my Mac OSX 10.9 to run some demo (I usually do not attempt MySQL and Apache things on a Mac), using Homebrew. Everything went just fine (apart usual stinky parts ...
1
vote
0answers
240 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
46 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
52 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
119 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
45 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
1k 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
330 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
56 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
107 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
44 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
86 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
21 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
69 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
169 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
83 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
157 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
141 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
44 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
156 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
162 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
107 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
3k views

Specified port 3306 is already in use when installing MySQL 5.6

How can I solve the problem when I try to install MySQL 5.6 and it tells me that the specified port 3306 is already in use. I uninstall my previous MySQL which is version 5.1 already and I do not have ...
1
vote
0answers
313 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
447 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
380 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
683 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
331 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
53 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
341 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
54 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
227 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
79 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
188 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 ...