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

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

what this datetime is used for in DB query

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
15 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
7 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
11 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
19 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
14 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
21 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
15 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
15 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
23 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
8 views

How to make MySQL log to 2 seperate remote servers? [migrated]

Documentation on this topic is scarce at best. I have two syslog servers and i need to send MySQL logs to them. Currently, i believe the logs are stored at either .mysql_history and/or mysqld.log Does ...
-1
votes
0answers
7 views

How to use sqleo with multiple mysql schemas

By default SQLeo is using only one mysql schema when building a query. To be able to use many schemas please use mariadb driver provided in lib directory of SQLeo, choose the "use multiple schema" in ...
0
votes
0answers
15 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
45 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
31 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
7 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
17 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
18 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
33 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
46 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
19 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
18 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
14 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
14 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
28 views

Remote MySQL database connection

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
19 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
35 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
28 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
27 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
29 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 ...
0
votes
0answers
15 views

restore MySQL Excel add-in

In a really bone-headed move I was trying to add an add-in to Excel 2010 and accidentally REMOVED the MySQL add-in (The remove button doesn't ask for confirmation). I tried to browse to the MYSQL ...
-1
votes
1answer
21 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
27 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
0answers
28 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
7 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' ...
3
votes
0answers
77 views

Can't connect to local MySQL instance when ran as service

I've been running a local MySQL server for development purposes lately and for some reason never got around to running it as a service so I was constantly starting it up using the mysqld.exe every ...
0
votes
1answer
12 views

Autostart multiple apache2 instances on start up

I have an OpenSUSE 13.1 installation, on which I am running multiple instances of apache under a proxy instance of apache. Currently I can start the proxy instance of apache and its MySQL database on ...
0
votes
0answers
18 views

Installing mysql - Fedora20 - Where is the installation directory

I am trying to install mysql on to a Fedora 20 box. I am using the below guide which states the following; First, MySQL was replaced by MariaDB since Fedora 19 ...
0
votes
0answers
28 views

Multiple webservers on one machine

I am attempting to setup a Dell Poweredge R720 with a variable number of separate instances of apache/mysql. This is because we wish to be able to update some of our systems, without affecting others. ...
0
votes
2answers
145 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
2answers
38 views

Ubuntu - Secure PHPMyAdmin in Nginx

I followed the instruction on this site for installing PHPMyAdmin. However, this configuration is for an Apache, and I am using Nginx. I can't find any tutorial online on how to restrict the allowed ...
0
votes
0answers
14 views

Redmine reports intermittent Internal Error

I've been using Redmine/Apache for a few months now. Occasionally a page will not load, and instead I will get Internal Error 500. Refreshing generally fixes this. When I look in the log file on the ...
0
votes
0answers
7 views

tango taco next generation objects

I installed Tango on Windows 8, and successfully created the database on a MySQL server. But when I launch the start-db.bat script, I get the message C:\Program Files\tango\bin>start-db.bat ...
0
votes
0answers
10 views

TANGO : TAco Next Generation Objects

I installed Tango on Windows 8, and successfully created the database on a MySQL server. But when I launch the start-db.bat script, I get the message C:\Program Files\tango\bin>start-db.bat ...
0
votes
1answer
35 views

analyzing htop data in ubuntu

i am trying to find bottleneck in my server, specifically in my web application of why things are running super slow. Here is a screenshot of my htop: As far as I can tell mysql here is almost ...
0
votes
0answers
20 views

Am I using this command correctly? Can't understand why I get the error I am getting. Myqsl - Centos 6

So, I am trying to connect to a database through mysql ssh, but whenever I run the command Connect postfix@127.0.0.1 on postfix It returns with: ERROR 2005 (HY000): Unknown MySQL server host 'on' ...
0
votes
1answer
57 views

Difference between connecting to 127.0.0.1 and server ip

I am brand new to php, databases, and linux and had a problem where I could not connect to mysql databse with the php mysql_connection function. When I used the ip address of my VM I kepy getting a ...
0
votes
0answers
11 views

Error while trying to create an album in MySQL in Trovebox

When trying to create a new album in TroveBox I just get an simple error message in the ui notifying me that it failed. No information is in logs from Apache and MySQL. The current user can write in ...
0
votes
0answers
15 views

MySQL is installed but it is not detected as being installed

I think one of my friends had installed mySQL on the RHEL 6.2 OS I'm working on, but when I tried running it or uninstalling, it says the rpm is not installed, and when I try installing the rpm, it ...