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
335 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
1answer
73 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 ...
1
vote
1answer
34 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 ...
0
votes
1answer
73 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 ...
3
votes
1answer
571 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 ...
-1
votes
1answer
61 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 ...
0
votes
1answer
85 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 ...
0
votes
1answer
453 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 ...
1
vote
1answer
268 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 ...
1
vote
0answers
752 views

Migrate Jira to MySql - Unknown system variable 'storage_engine' [closed]

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. ...
1
vote
2answers
107 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 ...
1
vote
0answers
249 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
2answers
122 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
22 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 ...
0
votes
2answers
427 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
196 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
109 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
578 views

Shell Script - Loop to make multiples MySQL Query at once

I've tried to handle this problem, I've a little script to connect 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 ...
0
votes
0answers
163 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 ...
1
vote
1answer
224 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 ...
3
votes
1answer
858 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: ...
2
votes
2answers
555 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 ...
0
votes
1answer
22 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?
0
votes
2answers
162 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
2answers
1k 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 ...
27
votes
8answers
4k 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 ...
1
vote
1answer
96 views

How to confirm apt-get confirmation during mysql-server installation

I am trying to write bash script that will install mysql-server-5.6 I want to ask user for password and then I will use it during installation mysql-server and some other configuration. But my script ...
1
vote
1answer
159 views

MySql service start fails without anything meaningful (CentOS 7)

[root@myserver my.cnf.d]# service mysql start Starting MySQL. ERROR! And this is all I get. I tried checking the logs but couldn't find anything related to this. The database worked perfectly fine ...
0
votes
1answer
258 views

Allowing remote connections for MySQL on Ubuntu 14

I am trying to connect to MySQL using a program called Heidi, I want to use this instead of phpmyadmin. It's better than phpmyadmin and I figured it would be more secure than going to ...
-1
votes
1answer
119 views

Incorrect syntax near 'AUTO_INCREMENT' [closed]

I get an error on AUTO_INCREMENT while creating the following table. Please help. CREATE TABLE Invoice( Invoice_No INT NOT NULL AUTO_INCREMENT, Order_ID INT NOT NULL, TotalPrice VARCHAR(30) NOT ...
0
votes
1answer
184 views

Google Maps API and bandwidth consumption

I have a site that uses 2 Google Maps APIs. https://maps.googleapis.com/maps/api/js and https://maps.googleapis.com/maps/api/geocode/json This "mapper" site communicates with 2 Google Maps APIs, ...
0
votes
1answer
81 views

Sub-domains keeps redirecting me to Main web-site

I have just upgraded my version of LAMP Environment. Rest all the things are working fine but with Sub-domains i have a challenge. I have a Main website abc.biz and 5 to 6 sub-domains with it as ...
1
vote
1answer
106 views

Unix permissions error when working with symbolic link and MySQL installation

I'm working to install MySQL on one of our servers. I'm the ec2-user, and I'm attempting to install in the ec2-user home directory, but allowing access to the directory to the mysql user. However, ...
2
votes
1answer
123 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. ...
0
votes
0answers
135 views

Starting MySQL database server: mysqldinstall: invalid user `mysql'

i have a problem with mysql on my Raspberry Pi running Linux raspberrypi 3.18.7+ #755 PREEMPT Thu Feb 12 17:14:31 GMT 2015 armv6l GNU/Linux. This is error I have when I run sudo service mysql start ...
0
votes
1answer
68 views

MySQL Cluster ndb_restore fails with no error

I have been working to migrate our current single instance database to a new clustered database running MySQL cluster. It is a large database (several billion records) and, while it seems to be ...
0
votes
1answer
283 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 ...
0
votes
1answer
40 views

Linux. MySQL command-line client. Set '--sigint-ignore' option forever

I think ctrl+c is required sometimes but I can't remember I needed it. Sometimes I'm trying to copy output text by pressing that "hotkey" automatically and losing db connection instead. It is very ...
0
votes
0answers
148 views

MySQL installed on debian (raspbian), is running in background, but “mysql: command not found”

I have a linux server running at home on a Banana Pi (very similar to a Raspberry Pi) with a few small websites and databases. Specifically; $ cat /etc/*-release PRETTY_NAME="Raspbian GNU/Linux 7 ...
1
vote
1answer
312 views

How to find out the user who changed the MySQL root password?

On my CentOS testing server, someone has changed the MySQL root password. Is there any way to find out, who changed the password and when?
0
votes
1answer
1k views

Cannot connect to port 3306 on a remote MySQL server using MySQL Workbench in Mac OS X

I want to access MySQL remotely: GRANT ALL ON *.* TO thufir@'192.168.0.16' IDENTIFIED BY 'hfdks4329vjkl'; When Workbench failed to connect, I took a look with ping and telnet: Brents-MacBook:~ ...
1
vote
0answers
173 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 ...
0
votes
0answers
29 views

boost application process in ubuntu

Are there other ways to boost an application process in Ubuntu other than "nice"? I want to backup a database without using import and export method and just use push and pull method instead. I tried ...
-1
votes
1answer
560 views

how to upgrade Mysql 5.5.30 to 5.6.21 in Amazon ec2

The current installation of mysql is 5.5.30 and it is in Amazon ec2 I want to upgrade it to 5.6.21 I used sudo apt-get install mysql-server=5.6.21 But it says: Version '5.6.21' for ...
0
votes
0answers
859 views

Getting error while start mysql in xamp

I am getting an error when try to start mysql in xamp 11:31:58 AM [mysql] Status change detected: running 11:32:03 AM [mysql] Status change detected: stopped 11:32:03 AM [mysql] Error: ...
1
vote
1answer
233 views

Uninstall specific version of mysql OSX

I installed mysql using .dmg, and then I realized I already have mysql installed. Now I have two versions, and I would like to keep the one that was shipped with OSX. Is there a way to do it and ...
0
votes
1answer
41 views

Will application version <X> be available natively in Ubuntu version <Y>?

Specifically I want to know if MySQL 5.7 will be available natively (fully integrated, no fiddling with repositories) in Ubuntu 15.04. But I'm really more interested in a general answer, like, is ...
0
votes
1answer
929 views

FreeRADIUS: custom SQL counter only partially working

I want to add to my FreeRADIUS installation a custom SQL check counter. Basically it's the same as Max-Daily-Session but limited to the current Called-Station-Id. I added this to ...
0
votes
1answer
375 views

Login script with PHP and MySQL doesn't work, users from database doesnt appear - probably rookie mistake

I am new at php and MySQL, and I might have a stupid mistake here, but I just cant find it.... The script returns that I have entered wrong password or username, but I am completely sure that both are ...
2
votes
1answer
432 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...