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
226 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
38 views

Logon and Logoff scripts not running

I have set SQL queries to run on logon and logoff using group policy editor. But sometimes scripts do not run. logon.bat @echo off echo INSERT INTO UPTIME(INTIME) VALUES(NOW()); > abc.sql mysql ...
2
votes
0answers
289 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 ...
2
votes
0answers
57 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
2k 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
681 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 ...
2
votes
0answers
707 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
571 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
239 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
180 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
89 views

Windows 7 web browser cannot access localhost

I'm using windows 7 and installed xampp, but I can't access localhost from all web browser (IE, Chrome, Firefox), it always give me "ERR_CONNECTION_REFUSED". I already googling it and found many ...
1
vote
0answers
37 views

Using the same connection on AMPPS and MySQL Workbench

I am using AMPPS 3.2 and MySQL Workbench 5.2.31 on Windows 7. I have installed MySQL as a service, running "C:\Program Files (x86)\Ampps\mysql\bin\mysqld.exe" install in Administrator mode, and I have ...
1
vote
0answers
31 views

Is there any chance Workbench has a case sensitive setting for Queries?

So I have been using MySql workbench for an online database I was able to set everything up but to my suprise and my boss' amazement, Workbench was actually case sensitive. We wrote two select ...
1
vote
0answers
32 views

Manual SQL install error

I am receiving the following error when trying to manually install my SQL: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
1
vote
0answers
64 views

Mysql- Changing file name to include date/time stamp when query is run

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE ...
1
vote
0answers
103 views

Set up sftp mysql authentication with chroot

How do I set up an openssh SFTP server that authenticates against a MySQL table where the users are jailed? Each user will need to have its own jail: /home/sftp/john /home/sftp/jane etc.. However ...
1
vote
0answers
673 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
1
vote
0answers
42 views

can filling up a disk and then freeing up space cause filesystem problems a month later?

I had an incident happen not too long ago with a server running mysql. Someone had enabled slow query logging on the server but never bothered to implement a log rotation, so the log files slowly ...
1
vote
0answers
126 views

PHP exec() causing memory usage to stay high?

I am quite new to using exec() command in php. I am using it along with this script called phantomJS (http://phantomjs.org/) to run a process which creates a pdf of my website's pages. The problem ...
1
vote
0answers
249 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
192 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
51 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
34 views

watch mysql output w/ tabular columns

how come when I run a mysql query and dump the results to stdout I get a pretty printed table ie: > mysql -e "describe <table>" <database> ...
1
vote
0answers
328 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
509 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
1k 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
373 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
116 views

Importing pygments' highlighting to vim

Usually, vim does very good job in highlighting, using the packaged syntax files. Unfortunately, it does bad job with MySQL. At first, I looked everywhere for a better MySQL vim syntax file, with no ...
1
vote
0answers
149 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
215 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
77 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
84 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
53 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
192 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
25 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
81 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
215 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
183 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
168 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
195 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
54 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
241 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
243 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
138 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
8k 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
509 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
972 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
469 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
64 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 | +-------------------+ |.. ....... | | ..... .... | | .. ...