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
10 views

Every hour my AWS EC2 instance stalls

During this time, connection attempts to my site wait indefinitely, until either my browser gives up after 5~ minutes or I will end up getting a Magento error such as: SQLSTATE[HY000]: General error: ...
1
vote
1answer
13 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 ...
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 ...
2
votes
1answer
786 views

mysql workbench visualization for schema

i have an existing database and have recently downloaded mysql workbench. I was wondering if anyone could walk me through how to navigate the workbench and how to get a visualization of the RDB. I'd ...
23
votes
2answers
216k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p , and show databases, +--------------------+ | Database | +--------------------+ | information_schema | | mysql ...
0
votes
0answers
11 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
1answer
2k views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
0
votes
0answers
18 views

MySQL Query to Select All and Convert Date [migrated]

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 ...
8
votes
2answers
20k views

How to exit MySQL command prompt?

I have installed MySQL. Now I am stuck inside the MySQL command prompt. I ran MySQL like this: C:\>mysql.exe mysql> Then I type in some invalid command like this: mysql> /version ...
0
votes
0answers
13 views

Use heroku instance as a Mysql database server

I have a hosting plan which limits disk usage and I see that heroku or some other free hosting plans could come as rescue , so that I would just use their Mysql database component remotely for my ...
0
votes
0answers
6 views

MySQL Freezes System Preferences then Crashes Mac OSX Yosemite

So I'm trying to set up my Mac Mini as a webserver, OSX Yosemite. Ive installed MySQL but when I try run it from the preferences pane everything freezes then eventually crashes. The version of MySQL ...
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
0answers
7 views

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

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
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?
2
votes
3answers
48 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
41 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
32 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 ...
4
votes
7answers
15k views

How do I split a large MySql backup file into multiple files?

I have a 250 MB backup SQL file but the limit on the new hosting is only 100 MB ... Is there a program that let's you split an SQL file into multiple SQL files? It seems like people are answering ...
0
votes
1answer
39 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
2answers
674 views

Creating mysql database for Drupal

I'm trying to create Mysql database for Drupal according to these instructions " First, you must create a new database for your Drupal site (here, 'databasename' is the name of the new database): ...
0
votes
2answers
6k views

Can't start MySQL server on OSX

I just installed MySQL Server and Startup tools from the DMG at the MySQL site on an OSX 10.6.6. I restarted the computer, but it seems it can't connect to its socket. $ /usr/local/mysql/bin/mysql ...
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
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
1answer
189 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
0answers
25 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
13 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
16 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
20 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 ...
0
votes
0answers
16 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 ...
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 ...
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 ...
7
votes
2answers
7k views

Auto-restart mysql when it dies

I have a rackspace server that I have been renting to run my personal projects upon. Since I am cheap, it has 256Mb of RAM and honestly can't handle alot. Every once in a while, when there is a sharp ...
-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
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 ...
1
vote
1answer
26 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
1answer
40 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 ...
2
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
43 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] ...
0
votes
0answers
119 views

Eclipse with XAMPP's MySQL and Tomcat

I want to create a Dynamic Web Project in Eclipse, but that option isn't available since Database and local server hasn't been configured. I downloaded XAMPP, how can I use the MySQL and Tomcat server ...
1
vote
0answers
16 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
5k views

Connect MySQL Workbench with XAMPP MySQL?

I spent two days trying to figure this one out. Basically I couldn't connect to the localhost MySQL database installed by XAMPP 1.7.4 using MySQL Workbench. I got a socket connection error (1061) or ...
0
votes
1answer
15 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
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 ...
-1
votes
4answers
39 views

how to remove multiple data in excel

I have a email list on excel that looks like this: 123@abc.com ad@aaa.com ydd@asd.com offf@rty.com 7ff@vvc.com ass@aaa.com yss@asd.com oas@rty.com I want to remove the below data from email list. ...
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 ...
7
votes
3answers
15k 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 ...