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
232 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
84 views

MySQL password restrictions?

I installed MySQL 5.5 on a fresh VM running Ubuntu 14 LTS through apt-get. During installation, I set a root user password generated by a password manager. After installation, I could not access any ...
2
votes
0answers
141 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
442 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
93 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
355 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 ...
2
votes
0answers
867 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
924 views

Row is not deleted in PHPMyAdmin

I have a problem deleting a row in PHPMyAdmin. When 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
18 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
645 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
287 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
184 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
11 views

MySQL doesn't seem to be executing commands

I am cleaning up a lot of my DB's/Tables, and have been running into an issue. When I execute most commands which change data on a table (i.e, DELETE FROM or UPDATE), the command returns as completed ...
1
vote
0answers
15 views

How to install MySQL on separate box from IIS 7

I've got two servers running Server 2008 r2. I've set up one sever as the webserver with IIs7.0, asp.net, php, nodejs, etc. And I have put MySQL and MongoDB on the other server. As best I can tell ...
1
vote
0answers
229 views

Secure wifi connection with FreeRADIUS, MySQL, EAP-PEAP, TLS

I'm trying to setup a wireless network as shown in the picture and I'm struggling how to secure it. Picture of Wifi Network: My basic question is: How I can securely store passwords into MySQL ...
1
vote
0answers
42 views

Could not initialize MySQL client library in Justhost

I am trying to configure redmine in justhost. following link was used for configuration. Link: https://my.justhost.com/cgi/help/redmine I am getting error - Could not initialize MySQL client library. ...
1
vote
0answers
39 views

How to know what application is injecting a script on html

I'm trying to figure out what application is injecting a javascript called http://queryjs.me/services/script.js into my pages on localhost and on my server. It only injects this script when the ...
1
vote
0answers
464 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
138 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
185 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
248 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
1
vote
0answers
171 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
239 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
1k 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
64 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
238 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
352 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
268 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
58 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
470 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
658 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
544 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
185 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
254 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
316 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
100 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
105 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
56 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
301 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
30 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
84 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
229 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
303 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
172 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
235 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
58 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
345 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
163 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 ?