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

How not to start MySql server on EasyPhp startup?

I'm using EasyPhp 14.1 on Windows XP. I would like to know how to configure EasyPhp to start Apache webserver, but not MySql server when the app starts?
1
vote
1answer
40 views

MySQL in OS X Terminal.app — how to exit mysql command prompt but continue using the Terminal?

I type mysql and enter the mysql command prompt (denoted ~mysql) (I have ohmyzsh installed also). But I can't seem to do anything within it. No commands work. To exit, I type 'exit', and get [Process ...
1
vote
1answer
113 views

Openoffice / Excel combine multiple worksheets into one

I have not yet found the exact answer to my specific problem, so let's give it a shot : The Layout : 1 SharePoint Farm on which a report was run, returning 6 Excel Files with each containing 250 ...
0
votes
1answer
57 views

Accessing mysql behind firewall with ssh port forwarding

I have an architecture which looks like this: | - DMZ - | ________ | ________ | _______ | CLIENT | | | SERVER | | | MYSQL | |________| | |________| | |_______| ...
1
vote
1answer
72 views

How do I use MacPorts' Perl installation with MAMP?

I have MAMP 3.0.6 and MacPorts 2.3.1. There are some Perl modules that I need to use (through some CGI scripts), I installed them on the MacPorts Perl installation (e.g., p5.16-dbd-mysql), but I can't ...
0
votes
1answer
54 views

How do I tell if mysql replication is occurring over SSL

We have a SQL server replication in place. I'm trying to ensure that the replication is occurring over secure channels. Given that MASTER_SSL_Allowed is true ("Yes"), does this suggest things are ...
0
votes
1answer
553 views

EC2 instance Linux, MYSQL log error:InnoDB: Unable to lock ./ibdata1, error: 11

I have a working server running Ubuntu 64bit with apache2 on a t2 micro EC2 instance. The problem is that MYSQL (version 5.5.38) has some bug...I tried everything, delete completely and restart ...
0
votes
0answers
29 views

Connect to MySQL from localhost and external IP

I'm struggling to get my MySQL server to accept connections from localhost and external IP adresses at the same time. It's either only local or only external IP, but never both. I have read several ...
0
votes
0answers
28 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
1answer
364 views

gcc error Python.h: No such file or directory

I have python-dev (or, as I'm on Centos, python-devel) already installed. sudo yum install mysql mysql-devel mysql-libs sudo yum install python-devel sudo yum install MySQL-python How come this ...
0
votes
0answers
43 views

OS X MySQL '/tmp/mysql.sock' error after sudo chown -R myname usr

On OS X 10.6, when installing NGINX I inadvertently (hastily, stupidly) ran sudo chown -R myname usr, and think I repaired it with Applejack (app, run from command line). However, Running the ...
0
votes
0answers
14 views

Missing Management options in MySql Workbench

I've installed MySql Workbench 6.1 and for whatever reason, I don't have any Management options (like database restore). The tab exists, but there are no items in it. My colleague has the exact same ...
-2
votes
1answer
41 views

How does social media sites store posts [closed]

Do social media sites such as Facebook and twitter, store posts in a database? Like mysql? Wouldn't the database be extremely large? Does Facebook or social media sites remove old post?
2
votes
0answers
136 views

Microsoft Excel to SQL using Pentaho: syntax error in 'OPTION SQL_SELECT_LIMIT=DEFAULT'

I've been using Pentaho Kettle version 5.1 to transfer Excel data to SQL by following these steps (answered by Edgar: Launch Pentaho Kettle (Typically) click on 'No Repository' Create a new ...
0
votes
0answers
21 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
33 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
53 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 ...
2
votes
2answers
55 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
166 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
35 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
1answer
89 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
17 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
78 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
284 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
87 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
241 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
36 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
34 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
1answer
38 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
43 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
24 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
0
votes
0answers
26 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 ...
0
votes
1answer
26 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
157 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
99 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
27 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
18 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
445 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
176 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
303 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
164 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
24 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
25 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
28 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
49 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
241 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
40 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
26 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
18 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
35 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, ...