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
5 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", but ...
0
votes
1answer
11 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
4 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
3 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
10 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
22 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
26 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
5 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. ...
-5
votes
0answers
12 views

Plz help me i want tyo know the solution of my mysql query [closed]

Write a mysql query where condition is that...A employee table in which the so many employee and some employee salary between 5 to 10, I want that on date 31/12/2013 which employee salary 5 to 10 ...
0
votes
2answers
15 views

How to finding words that are near other words? [on hold]

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
17 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
32 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
43 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
16 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
13 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
22 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
30 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
22 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
24 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
21 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
12 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
19 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
25 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
26 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
70 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 ...
-1
votes
0answers
31 views

Undefined class constant 'MYSQL_ATTR_MAX_BUFFER_SIZE'

I have EasyPHP 14.1 configured and running properly on a Windows 7 x64 machine. Trying to open a web-app called Open Device Manager, I get the following error Fatal error: Undefined class constant ...
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
26 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
101 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
33 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
11 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
31 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
19 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
55 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
13 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 ...
-1
votes
1answer
26 views

SQL remove everything behind a comma in string [closed]

I have a mysql table storing some data. One column stores strings containing a comma. I want to get rid of everything (including the comma) in this string and save it, but I don't get it to work. I ...
1
vote
1answer
27 views

Will re-installing MySQL remove or delete existing databases?

If I reinstall MySQL, without removing the actual MySQL installation, would it rewrite all files without deleting my databases? My problem is my mysqld is broken, due to the fact that I accidentally ...
0
votes
1answer
20 views

How to get access to MAMP mysqldata base when 1045 access denied error is posed?

Been stuck for a few days now. I've been SCOURING google for solutions and have tried many things. Basically I was editing my users in phpMyadmin and I think I erased the user 'root' which is my ...
0
votes
0answers
13 views

InnoDB O_DIRECT on NTFS external drive

I have a MySQL database with a table that has about 170 mil rows. I have it partitioned into 32 partitions with hash(id div 10000000). I created and imported the rows and then moved the data to an ...
0
votes
2answers
117 views

Trovebox (OpenPhoto) setup hangs/fails at final step 3

I've been following the install instructions found here about how to install and configure Trovebox on a Ubuntu server running Apache: Ubuntu 14.04 LTS Apache: 2.4.7 MySQL: 5.5.37 PHP: 5.5.9 ...
0
votes
1answer
34 views

mysql backup verification

Im not a dabase admin or advanced database user or advanced linux user.. but I would like to know how to verify mysql dumps because I am backing up my own sites manually. Normally when backing up lot ...