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

learn more… | top users | synonyms

0
votes
1answer
2k views

Can I output results of a MySQL query to a Excel file via Putty?

I'm on a local windows machine. The MySQL DB is on a CentOS machine elsewhere on the same local network. I want to output the results of the query that I'm typing directly into Putty into an Excel (or ...
0
votes
2answers
14 views

How does libreoffice express a linebreak when saving a csv?

I’m attempting to save a CSV using LibreOffice Calc to be imported to a MySQL database. Saving it as a CSV is pretty straightforward in LibreOffice but I don’t know how the resulting document ...
7
votes
3answers
12k views

How to drop all MySQL tables from the command-line?

Usually I open Terminal.app and connect to a remote MySQL database. Then I use this command to drop a table: mysql> drop table [table name]; But what I need is the command line to drop all ...
0
votes
1answer
6 views

MYSQL Connector J in Ubuntu

I'm relatively new to Ubuntu and am developing an application using MySql Server. My question is, where do I put the file? I know in Windows the connector goes in the 'lib' file of the project. Does ...
1
vote
0answers
12 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 ...
0
votes
0answers
6 views

How to change ports in UniserverZ and/or Uniserv?

I'm asking this because every single time i need to update the program, the configuration file is updated too and the port must need rechanged, but my question is honest because: 1) When i try to use ...
0
votes
1answer
26 views

centos7 not installing mysql

I've installed centos7 recently, but, when I am trying to install Mysql using the command: yum install mysql-community-server I keep getting Exiting on user cancel while I am not hitting any ...
0
votes
2answers
2k views

MySQL ODBC driver 5.1 and Windows 7

I successfully installed the MySQL ODBC 5.1 driver for Windows: But unfortunaly it doesn't appear in the ODBC Data Source Administrator of Windows (yes, I even did a log off + log on): Why?
1
vote
1answer
23 views

Does windows 7 stop services/processes if low on ram?

I am having an issue with some customers where a service is stopped (Mysql). Mysql uses a fair amount of memory and I am wondering if windows decides to stop it when low on ram. Is there any other ...
-1
votes
1answer
22 views

Install mysql on windows on windows 7

When I had a job, MySQL was installed on the Linux server and I used to connect using Xshell. Now, I want to install it on Windows 7 and have a good command line interface (better than cmd). I have ...
1
vote
2answers
44 views

MySQL connection works on CLI, but not on Workbench

Fedora release 20 (Heisenbug) 3.19.3-100.fc20.x86_64 Packages: mysql-workbench-community.x86_64 6.1.7-1.fc20 mariadb.x86_64 1:5.5.41-1.fc20 ...
0
votes
1answer
20 views

PHP installation issue on a Windows Server hosted in the Azure cloud

I am trying to setup PHP and MySQL on a Windows Server that is currently in Azure cloud using the information from this blog post. Now I am testing the PHP installation using the methods specified in ...
2
votes
1answer
27 views

Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column. For example, in one ...
0
votes
1answer
25 views

Command Line utility for MySQL

I want to download only MySQL command line utility. I tried searching but unable to find. I even downloaded the entire MySQL Community edition and tried installing only MySQL Utility but the installer ...
-2
votes
0answers
19 views

Any updates on this book's publication time? [closed]

Does anyone know the details behind this book's rather ... creative revision of publication times? Current delay: http://www.mhprofessional.com/product.php?isbn=0071775781 Previous delays: ...
4
votes
2answers
4k views

launchctl: Dubious ownership on file (skipping) (Mac OS X)

I installed mysql recently and added its start command in my .bash file. But when I tried running the command, that's when I encountered this error: launchctl: Dubious ownership on file ...
0
votes
1answer
20 views

Converting MSSQL Dump to MySQL Dump on Ubuntu

I only have Ubuntu to work with, so Windows programs are not going to work for me. But basically I have both the .bak file and the .sql file from a MSSQL server and I need to import this data into a ...
0
votes
0answers
6 views

Sequel PRO remote connection to a VPS

I'm using Sequel PRO to establish remote connection to my clients servers but every time I try to remotely connect to a VPS server it gives me the following error: Unable to connect to host ...
1
vote
1answer
19 views

Error 10053 on wampserver after sleeping the computer

I use WampServer for development testing purposes on my local computer (windows 8). I don't usually turn off the computer, I just close the cover (a laptop) and it sleeps. When I open it again, the ...
0
votes
0answers
15 views

Migrate Jira to MySql - Unknown system variable 'storage_engine'

I'm migrating JIRA in Windows from HSQL to MySQL and i got stuck with message Unknown system variable 'storage_engine'. Though i created backup, installed MySQL, copied J connector to libs of JIRA. ...
0
votes
1answer
4k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
0
votes
1answer
24 views

MySQL server copied from Windows won't start on Ubuntu Linux

I have an external hard drive (formatted NTFS) to which I copied the MySQL data folder from a machine running Windows 7. I have been successfully able to start/stop/use MySQL on the Windows machine ...
0
votes
2answers
27 views

Services don't have MySQL Server. How to run it?

I need to run MySQL Server on a new for me laptop. There's Windows 7. And MySQL have been installed on it. In order to verify this, I opened the Programs and Features window and saw it there: But ...
0
votes
1answer
3k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
0
votes
2answers
29 views

SSH Connection is established on port 22, but service is not working

I am having this recurrent issue on one of my MySQL Cluster Servers, actually always happens in any random MySQL server of this cluster, on many countries where we have this same configuration. I ...
0
votes
0answers
42 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 ...
0
votes
0answers
8 views

Result grid in right sidebar in MySQL Workbench

I am using MySQL Workbench. The result grid is always shown below the script window. Can I somehow place the result grid in the secondary sidenav, having the script window and result grid as a split ...
2
votes
2answers
6k views

Can't delete MySql service on Windows using sc from the command line

I removed MySQL but there is still a service running. I stopped the service and ran SC Delete MySQL. This is the error that I receive: [SC] OpenService FAILED 5: Access is Denied OS: Windows ...
0
votes
1answer
13 views

MySQL: Port issues on an domain network setup

I am looking for options to have a MySQL server on corporate environment where opening a port in the Windows Firewall is quite difficult (a lot of red tape). At this point I am not looking to have a ...
2
votes
1answer
66 views

phpmyadmin not displaying schema

I have a server with a large number of mysql databases. Recently some of the schemas have stopped displaying when logged in as Root. If I use the login for that specific database then I can see it. ...
2
votes
0answers
235 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 ...
1
vote
1answer
2k views

MySQL Notifier High Severity Error at startup

When i start MySQL Notifier up and error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when i click over "Show Details" I can see the ...
0
votes
3answers
340 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
0answers
27 views

How to remotely connect to MySQL database running on Windows Server 2012?

I've been developing my web application locally, but now I need to test remotely. I have a Windows machine running Windows Server 2012 with XAMPP installed and configured. How can I connect remotely ...
1
vote
1answer
47 views

How do I edit an xmlTV file using sed (or a similar tool)?

I have an xmlTV file that looks like this: <channel id="10125.dvb.guide" <!-- number="62" type="0x1" flags="0xf" bouquet="4097" region="4a" sid="10125" -->> <display-name>ITV ...
1
vote
1answer
54 views

Shell Script - Loop to make multiples MySQL Query at once

I've tried to handle this problem, ive a little script to conect into a list of host stored in a file. #!/bin/bash num=$(wc -l < ip.txt) while read ip; do mysql --login-path=login -h $ip ...
1
vote
1answer
4k views

Installing MySQL 5.1 on OS X 10.7 Lion

I am trying to install MySQL 5.1. I am on Lion, and when I remove all files associated with MySQL on my machine it still tells me that I have a newer version installed when I try to install it from ...
0
votes
0answers
14 views

asp connection to asphostportal mysql database

I'm trying to connect via asp to a asphostportal mysql database on their server. I've created the database and added a users table. I have an opensource intranet (UAPortal) that is really ...
0
votes
1answer
6k views

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I've installed xampp on my MAC computer in my table I saw a word named user I clicked it and I saw that I was able to change from not having a password by default to using a password. I clicked it and ...
0
votes
0answers
16 views

Mysql service is not starting on windows 7

on windows 7, i have started the mysql service (mysql server 5.5) which is running quite fine but when i am trying to start another service named as mysql4 (mysql server 5.1) on same system it gives ...
0
votes
0answers
29 views

Will a homebrew installation of mysql conflict with xampp or netbeans?

I had mysql installed on my OS-X machine via macports a while back. I think it ended up conflicting with something I used for a wordpress test site (something like XAMPP), and I wasn't able to ...
0
votes
2answers
42 views

Wrong IP address present when connecting from localhost to localhost

I have a Linux server with Ubuntu installed on it. When I connecting to some service (MySQL, apache, icecast for example) from the same machine at address 127.0.0.1, they all show that I connected ...
1
vote
1answer
28 views

Recover broken MySQL database after setting Windows back to an earlier date

Yesterday after a driver update my Windows crashed and I got a BSOD right at startup so I didn't had a choice I set Windows back to the last working point but sadly my last working restore point was ...
2
votes
1answer
118 views

odbc error connecting mysql: “sql server does not exist or access denied”

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
1
vote
1answer
3k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
0
votes
1answer
63 views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

Our MySQL server keeps giving us this message. And it's a constant thing, I will restart it then 5 minutes, or 30 minutes later I will just get this error again. I've been googling like crazy to fix ...
1
vote
1answer
38 views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: ...
0
votes
1answer
5k views

Curl Returns “Connection Refused” when trying to access localhost

I am running Xampp (Apache, Mysql and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following: curl -v -i ...
27
votes
8answers
3k views

Can a massive MySQL data import on an SSD damage it?

I have to import quite a lot of data (~100 million rows, ~100 times) into a MySQL database. Currently, it is stored on my hard disk drive, and the bottleneck of my import seems to be the hard disk ...
0
votes
1answer
15 views

how to save mysql dumps for N days?

Is there any best practice for saving mysql-dumps daily backups for 30 days and then delete them, without writing scripts that checks date and delete? maybe a builtin tool?