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

Command prompt freezes when I open mysql

I have searched the net and this site, but I haven't found a solution yet. I installed XAMPP, but this wasn't visible through the command prompt. I then installed 32-bit MySQL on my 64-bit machine ...
0
votes
0answers
15 views

XBMC: How to share only the librarys between 2 PCs?

So that's it, how do I do that? I mean, yes, I know how to share my library between 2 or more PCs but it also shares the Watch states and resume points and I don't want that. I want to share the ...
0
votes
0answers
27 views

If my firewall is switched off,what else could be blocking access to mysql?

I want to have remote access to my mysql server but when i telnet my server from my computer i get this C:\Users\USER>telnet 197.000.0.00 3306 Connecting To 197.000.0.00...Could not open ...
0
votes
0answers
8 views

Wordpress How to display all posts in category, with specific tag posts at top [on hold]

I am trying to show the all Posts in the Category. With the specific tag posts at the top. For example:- I want to show all the Posts in the Category 'CAR' Now, I want that when i Click On 'CAR' ...
2
votes
2answers
24 views

Will a query which may take hours to execute keep executing on remote server if I close the connection after executing the command?

If I connect to a remote database server via ssh, start mysql client and execute a query which may take a couple of hours to execute, then close the connection, will the query continue to execute ...
0
votes
2answers
26 views

How to execute multiple multiline mysql queries with a shell script?

I want to run multiple MySQL queries from a shell script. I'm using the following code: mysql -u <redacted> -p<redacted> servermail << EOF CREATE TABLE `virtual_domains` ( `id` ...
0
votes
0answers
24 views

Mysql listens to all yet remote connections not possible

I am running this command on Centos netstat -an|grep 3306 | grep LISTEN and it gives me tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN yet when I try to connect to ...
-1
votes
0answers
21 views

Missing MySQL Database after Windows Upgrade

First of all, please bear with me as I am quite new to HeidiSQL, MySQL, and the concept of relational databases as a whole. I recently started using HeidiSQL in order to create tables for import into ...
0
votes
0answers
8 views

Apache compilation from source followed by php compilation as DSO and suphp. Pull up a phpinfo file under both configurations

I've followed all the steps specified here. I've done the following steps as per the link: Compile apache from source (using httpd-2.2.24.tar.gz, apr-1.4.6.tar.gz, apr-util-1.5.2.tar.gz) Compile ...
1
vote
1answer
15 views

Oracle SQL Select: If not exist, leave blank

I have two tables: Table1 [ID] [Number] 1 40 2 100 3 7 and Table2 [ID] [Number] [Name] 1 40 A 3 7 C Data originates in Table1, then gets copied to ...
0
votes
1answer
13 views

Fatal error (bad field count) while configuring Postfix

I'm using this tutorial to configure a mail server using postfix, dovecot and mysql. While configuring Postfix I have to uncomment the following lines and then restart Postfix with service postfix ...
1
vote
0answers
36 views

After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)

I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
0
votes
0answers
10 views

Use mysqdump to backup table with a new table name [migrated]

Is there a way to back up a table using mysqldump so the table that is being backed up can have a new name in the sql script created by mysqldump. So that If I back up the table 'test_table' like so. ...
0
votes
0answers
32 views

sqlmap os-shell help needed

I am asking this question just for educational purposes. I run this command to upload php shell: ./sqlmap.py -u http://target.com/myfile.php?id=1 --os-shell And it succeeded: The shell uploaded ...
-1
votes
3answers
32 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
0answers
6 views

PhpMyAdmin and cake on AWS Ec2

Question - I have Cake PHP installed and phpmyadmin in the same root directory (/var/www/html). Now when I try to navigate to my elastic ip/phpmyadmin I get Cake PHP telling me : Error: ...
0
votes
0answers
9 views

mysql flush tables with read lock verification

this seems like a dumb question and perhaps I'm not googling this correctly but I'm trying to figure out what the table status or database status should show after i issue flush tables with read ...
0
votes
0answers
15 views

Barnyard - Database Warning

I installed snort and barnyard. When I start snort and barnyard services, barnyard could read snort.log file but it doesn't write to mysql database. So I run tail -100 /var/log/messages and I ...
0
votes
1answer
18 views

what this datetime is used for in DB query [closed]

I acme across a db query @retVal = (DATEDIFF(s, '19700101', GETUTCDATE()) - dateTime) what this datetime used for ?? n what this query returns
-1
votes
0answers
20 views

Python coded batch files

I know this is more suited to Stack Overflow but I'm not allowed to ask any questions there so here seemed like the next best thing. I'm creating a batch file for the first time and don't understand ...
0
votes
0answers
14 views

How to restore Debian server's /var/lib datas

I made a big mistake : While administrating and making settings, I accidentally deleted /var/lib folder. The result is that I can no longer use any dpkg commands, so I"ve lost my mysql database. I of ...
-1
votes
0answers
12 views

Mailing list with dynamically generated addresses

I am trying to implement a dynamic mailing list from a database that changes quite often. Conditions: Postfix is the MTA Email addresses are in a MySql Database Postfix only allows senders whose ...
0
votes
1answer
25 views

How to backup MySQL databases when the MySQL server is off?

My MySQL server does not start, as according to the guides I found over the internet, the best solution is to re-install MySQL server (with apt-get purge). However, this process will delete my ...
0
votes
1answer
32 views

Can't get php script to connect to asterisk internal mysql database

I'm trying to get a PHP script to connect to Asterisks internal sql database. I tried the to use the standard method for example $con = mysqli_connect("192.168.1.126","root","mysql","asterisk"); ...
0
votes
0answers
27 views

Barnyard Service - MySQL Error

I installed barnyard2 and saved as a service. When I run service barnyard2 start, Barnyard2 is failed. After I run tail -100 /var/log/messages and I encounter a fault like this. ERROR database: ...
0
votes
1answer
20 views

MySQL / DBServer

I'm trying to match services running on Windows servers using the executable path returned by WMI. I'm getting MySQL through a path like C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld.exe I ...
0
votes
1answer
16 views

How to create a mysql database that can contain any character, also different languages

I'm trying to create a database that has to contain articles in different languages. I'm using Mariadb as my server and I know bits of SQL. My knowledge doesn't really cover details like the ...
0
votes
0answers
91 views

Can't start mariadb in centos 7

in the systemctl status it shows: systemctl status mariadb.service mariadb.service - MariaDB database server Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled) Active: failed ...
0
votes
0answers
37 views

How to change the background color in MySQL Workbench on Linux?

In Windows Workbench there is a "Theming" tab in Preferences where one can choose the color scheme. In Linux version this tab is missing and the default background color is black. How one can change ...
0
votes
0answers
112 views

Can't install MySQL in CentOS 6.5

When I try to install MySQL in CentOS 6.5 it gives me this error: Error: Multilib version problems found. This often means that the root cause is something else and multilib version checking is ...
0
votes
1answer
45 views

mediawiki: LDAP Authentication error

am using, php5+mysql+ldap . i had configured php and mysql with mediawiki. its working fine. But iwant to provide LDAP users authentication login and aswellas general users login. i was installed ...
0
votes
0answers
12 views

How to open PHP myadmin in XAMPP for linux?

I am running Linux Mint 17 (based on Ubuntu), and i have successfully installed Xampp. I would like to now work with MYSQL, so i was wondering how to open the PHP myadmin page in my browser. ...
0
votes
2answers
21 views

How to finding words that are near other words? [closed]

I am going to create a dictionary that users can find each words that are near each other from pronouncing and word Letter. For example When user searched near my site return other words that are ...
0
votes
1answer
19 views

When you log into MySQL is the password encrypted?

I'm using an insecure wireless network (because the secure network is currently down). I wanted to know: When you log into MySQL, does the client program encrypt the password before sending it? ...
0
votes
2answers
38 views

MySQL on Windows - Questions about binaries

I'm trying to gather identifying information for processes running on Windows. I've been unable to discover the difference between the 'mysqld.exe' and 'mysqld-nt.exe' binaries. What is the ...
0
votes
1answer
59 views

MySQL partition is full

I've just installed MySQL (with Apache) on my new Raspberry Pi. When I tried starting it I immediately got this error: df: `/var/lib/mysql/.': No such file or directory df: no file systems processed ...
1
vote
1answer
26 views

How to extract certain database from full Mysql dump?

I have regular backups of my mysql server.For convenience I set it up as a single Mysql nightly dump. Now I need to restore one of the databases from the dump. How do I restore a single database ...
0
votes
1answer
19 views

Checking LAMP Installation in Linux

I had installed PHP, MYSQL and APACHE in linux server, How can I check the installation and running status of Apache, MYSQL, PHP are correct in Linux server?
0
votes
0answers
17 views

Broswers loading a page that doesn't appear to exist in DocumentRoot

This is driving me bonkers. I have Apache running on a Raspberry Pi and I'm working on a website that has a user log in that leads to a page where users can enter data and send it to a MySQL database. ...
0
votes
0answers
20 views

Cannot remotely access MySQL

I tried every solution posted online, but nothing works. Here is what I did. I use the www.noip.com to continuously update my local's computer IP address to a dummy URL, say myComp.ddns.net. Next, ...
0
votes
2answers
35 views

Remote MySQL database connection [closed]

I have a MySQL server running on server1 (centos) and php/MySQL running on Server2 (centos). Both these servers are on 2 different cloud hosting providers. I want to connect my php code on server2 to ...
0
votes
1answer
23 views

How to remove few tables from a large SQL file?

I have a SQL file with size around 3 GB. So this takes some long time to restore every time when i took recent dump from production. In this one table 'access_log' itself took 2.2 GB which is just a ...
1
vote
1answer
39 views

How to connect MySQL in Linux Server?

I've been trying so hard just to connect with MySQL in my Linux server account. However when I run mysqladmin -u root -p, it generates this prompt: mysqladmin: connect to server at 'localhost' ...
0
votes
1answer
33 views

Installing Mysql with Nodejs

I am new to nodejs. I have installed the nodejs on my window 8 system. The path is C:\Program Files\nodejs. I want to install Mysql module for nodejs, But when i type command in search. Two command ...
1
vote
1answer
44 views

Mysql isn't accepting remote connections

I've configured MySQL on my CentOS 6.5 64 bit server and configured it to accept remote connections from any IP. When trying to connect through HeidiSQL it shows this error: SQL Error (2003): Can't ...
0
votes
0answers
59 views

Installing PHPMyAdmin on AWS EC2

I followed Amazon's instructions http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/install-LAMP.html to install a LAMP stack on a Micro EC2 instance running Linux. Installation was successful. I am ...
-1
votes
1answer
32 views

Mysql window closing immediately after clicking on it

I have done mysql installation like ten times now every time the installation is success but while trying to open it the window closes immediatelty. I have read the various post about starting the ...
1
vote
3answers
31 views

Limit the size of tmpdir

I need to limit the disk usage of MySQL tmpdir so it does not "eat" all available disk space. There are around 30G available but i have seen mysqld using all of it to create a temp table. My first ...
0
votes
1answer
64 views

How do I create & restore a mysql database dump with Chef?

Environment Ubuntu 12.04 Precise64 Enterprise Chef opscode-cookbooks/mysql opscode-cookbooks/database Wordpress 3.9 Objective I am trying to replicate/clone my production Wordpress server. I'd ...
0
votes
0answers
8 views

Pentest SQLi: how cand you get the number for culumns if order by and union don't work

Pentest SQLi question: how cand you get the number for culumns if order by and union don't work? id=5' or 1=1 --+ works but when I try id=5' order by 1 it doesn't show anything. I also tried id=5' ...