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

learn more… | top users | synonyms

1
vote
0answers
146 views

is there easy auto config software for setting up postfix/dovecot/mysql? [closed]

I'm really pulling my hair out on this one. I have installed all of the apps mentioned above, along with webmin and postfixadmin. Webmin gives me settings for dovecot but asks for a sql configuration ...
2
votes
3answers
197 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
1
vote
0answers
498 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
1answer
40 views

What is the name of the daemon process of mysql in OS X?

I have just installed mysql in OS X and this code works fine: String url = "jdbc:mysql://localhost:3306/"; String dbName = "information_schema"; String driver = "com.mysql.jdbc.Driver"; String ...
0
votes
1answer
192 views

Mysql remote server with rights to WMI

I just fixed and got my MySQL running on my computer on port forwarded with all the grants. However, when I am enabling remote server Windows asks for user login information for WMI I need to enter ...
1
vote
1answer
107 views

Can't change MySQL/MariaDB server collation option

I am trying to change the server's collation_server variable default option from latin1_swedish_ci to utf8_general_ci by adding it into the /etc/my.cnf.d/mariadb-server.cnf config file under a ...
0
votes
1answer
225 views

Mysql port forward and access from any pc outside network

I created a application that use mysql and it will be public. I port forwarded mysql default port on my router and i want that anyone would be able to connect to mysql that is on my computer outside ...
0
votes
1answer
251 views

How to add regex aliases in Postfix when using MySQL

I need to create regex based catchall aliases in Postfix setup with MySQL. I have found examples of a mysql_virtual_alias_maps_regexp.cf with this query: query = SELECT goto FROM alias WHERE '%s' ...
1
vote
1answer
176 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 ...
2
votes
1answer
82 views

OpenSuSE 10.2: create MySQL database with “Access denied for user 'root'@'localhost'”

I have to install Wordpress on a very old OpenSuSE 10.2 web server. And for this I´m trying to create a mysql database. Unfortunately the mysql server tells me for every attempt "ERROR 1045 (28000): ...
2
votes
1answer
319 views

To edit commandline Anki flashcards in MySQL

I need to make a small change in 77777 Anki flashcards, preferentially programmatically, not by using their replace tool which is not sufficient. I imported data originally there as CSV files where ...
1
vote
1answer
63 views

Is there a way to run a perl script on a windows system without having to install anything?

I have a handy perl script that I use on my linux systems to check some database information in mysql. I'd like to have a portable version of this available for Windows (specifically Windows 2008 and ...
0
votes
1answer
320 views

Connect mysql database to Ms Access directly

I am trying to connect mySql database on our server directly to an msAccess database we have. I want to be able to download data from the mysql database directly and upload it too directly. I want ...
1
vote
1answer
232 views

Windows system restore and data lost on mysql

Is it possibile that a system restore in Windows 7 system may have lost some data in mysql tables? Mysql data is typically stored in C:\ProgramData\MySQL\MySQL Server 5.6\data folder, few days ago my ...
1
vote
0answers
167 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 ...
0
votes
2answers
61 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 ...
0
votes
1answer
191 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
223 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
1answer
372 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
77 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
35 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
79 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
654 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
67 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
88 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
493 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
288 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
935 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
114 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
274 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
135 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
23 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
504 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
204 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
112 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</...
1
vote
1answer
602 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
189 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
258 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 ...
4
votes
1answer
1k 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
595 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
24 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
196 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
2k 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 mariadb-libs....
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
106 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
169 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
275 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 domain.com/...
-1
votes
1answer
130 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
204 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
100 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 aaa....