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
0answers
7 views

Sync a field data from database of local host server to remote server after establish network connection [on hold]

I want to make offline web application. On offline mode, i entered some data by form filling which save to local database. Now I want to sync this data automatically to remote server whenever internet ...
0
votes
0answers
8 views

Change MySQL Installer for Windows update prompt period. Daily is too often

MySQL Installer for Windows - Community opens a console window about once per day to prompt the user to update a catalog and other things. A once per day prompt is very annoying. How can I change ...
1
vote
3answers
43 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
39 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 ...
0
votes
0answers
26 views

MySql Remote. WMI connection setup does not work?

Hello i want to do a remote server on mysql that is on my computer soo i can connect to it outside network but i have a problem that i cannot solve my self. PROBLEM When i enter my windows 8 login ...
1
vote
0answers
9 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
38 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 ...
0
votes
0answers
19 views

MAC OSX Terminal (TERM)

I am using debian wheezy, I installed mysql but when I login to mysql using command mysql -u root -p and then after typing my password, I don't see any output. According to log file I am successfully ...
1
vote
1answer
12 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
0answers
11 views

RAM allocation in WHM/Cpanel using SSH

I have a server(VPS) with 4gb ram. I would like to create 4 cpanels with allowed RAM as 1gb each, so that they use their individual memory. How can i do so using ssh?
0
votes
1answer
116 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
16 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
0answers
18 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
21 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): ...
-1
votes
0answers
6 views

How to set function in HTML while outputing HTML with PHP [migrated]

Sorry for little weird tittle, english is not my native language, and its little hard for me to express myself about this, so I hope i'll get clearer in explanation :) I have this piece of code, to ...
0
votes
0answers
15 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 ...
-4
votes
0answers
13 views

PHP/MYSQL INSERT FORM [migrated]

PROBLEM: as soon as you enter the webpage it enters into the SQL table, even if you do not submit, immediatly after you enter the webpage it sends a blank to the SQL table, here is the codes ...
1
vote
1answer
19 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
0answers
12 views

MySQL Query to Select All and Convert Date

How would I write a query in MySQL to select all and to convert 2 UNIX date columns to something readable, i.e. - from_unixtime(received_date) without needing to manually write out each of the other ...
0
votes
1answer
35 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
23 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 ...
0
votes
0answers
41 views

Changing MySQL default data storage directory gives error in CentOS

I installed mariadb in CentOS. I would like to store all my databases in a directory located in a NFS device. I have my my.conf in /etc/. My /etc/my.conf is the following one: [mysqld] ...
1
vote
0answers
14 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
votes
0answers
4 views

How to create a sub project in weblate?

I just setup a new server with weblate software send I have no clue how to set correctly a sub project with github source. Can anyone please post a model to follow? The documentation at weblate is ...
0
votes
0answers
17 views

Configuring a centralized rsyslog server with MySQL database, gathering events from multiple servers

I'm trying to configure my rsyslog server to collect logs from many servers and write them to a local database. The problem is, the server writes the data to the DB as local (host, ip, etc) I'm ...
0
votes
2answers
15 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
19 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
20 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
37 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
14 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
26 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
27 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
39 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
25 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
33 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
0answers
13 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 ...
0
votes
1answer
43 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
29 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
39 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
29 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
0answers
65 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
32 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
0answers
13 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 ...
0
votes
1answer
16 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
73 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
49 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
56 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
96 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 ...
0
votes
0answers
19 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
0answers
18 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 ...