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

mysql 2 databases synchronization

I've got 2 databases, one in local server and one in internet: local) server1 : DB1 { table1(40lines) } Net) server2 : DB2 { table2(30lines) } So how can I get those 10 lines from table1 in ...
1
vote
1answer
5 views

No output / stdout / feedback in mysql prompt on Ubuntu 14.04

I'm running Ubuntu 14.04 and Nginx, and I recently installed mysql-server while following Digital Ocean's LEMP stack setup guide (I intend to run a WordPress site with it). When I try to log into an ...
-1
votes
1answer
23 views

sql query to calculate total VAT and total sales

I need to estimate the total VAT expected based on all of my sales in my current sales table. The VAT is estimated as 15% of the total value of sales. So far i have tried this but i dont think it is ...
0
votes
0answers
18 views

Why is it not recommended to use zero in an id column in MySQL?

If you're building out a project from scratch, what are some reasons that one would not recommend using zero (0) in an id column for MySQL? Assuming that the MySQL database/server is in strict mode ...
0
votes
0answers
18 views

borked XAMPP upgrade — any way to rebuild my database if i saved var/mysql folder?

After I upgraded to Mac OS X Yosemite, the mySQL server on my XAMPP install stopped turning on. XAMPP released an upgrade that fixed this. So, I copied and pasted my "htdocs" and "var/mysql" folders ...
-1
votes
0answers
282 views

PhpMyAdmin shows error 1146 after upgrading to OS X Yosemite

I was working with XAMPP 1.8.3-3 on OS X Mavericks. After upgrading to Yosemite, MySQL server stopped working. And an upgrade to XAMPP 1.8.3-5 fixed the problem and MySQL server started working. Now ...
0
votes
1answer
21 views

PHP site doesn't work on Linux Mint

I started using a Linux Mint and I'm having a little problem. I have a project, where the main folder contains PHP files, and inside this folder there are other folders with images, JS files and CSS ...
-1
votes
1answer
32 views

Website slowing down when many users access simultaneously [closed]

I'm new to web development. I have hosted my website through a free web hosting service providing free subdomain. The free hosting service says that they provide 100 GB bandwidth. I just upload files ...
-2
votes
0answers
16 views

Recommend local server for 50 user [closed]

I am new to the server side. I am asked to setup a local server for 50/60 users max. The server will be running linux, mysql and a java application server (for a CRUD application, using spring, ...
0
votes
0answers
8 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?
0
votes
0answers
17 views

How to select from mysql tables randomly? [closed]

I am working on a quiz app image 1 shows the index.php page image 2 shows the first question image 3 shows the second question image 4 shows the third question image 5 shows the result after ...
-4
votes
0answers
17 views

How to Configure MySQL in Fedora 19?

When I try to run mysql at terminal, it is showing the following error. ERROR 2002 (HY000): Can't connect to local MySQL serverthrough socket '/var/lib/mysql/mysql.sock' (2)
0
votes
1answer
29 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 ...
0
votes
0answers
25 views

localhost or 127.0.0.1 in XAMPP

I've used XAMPP quite a lot over the past year but just recently installed it on my new laptop running Windows 8.1. After installing everything I tried to change the root password using the link ...
1
vote
1answer
30 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
32 views

Accessing mysql behind firewall with ssh port forwarding

I have an architecture which looks like this: | - DMZ - | ________ | ________ | _______ | CLIENT | | | SERVER | | | MYSQL | |________| | |________| | |_______| ...
1
vote
1answer
42 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 ...
-3
votes
0answers
24 views

Access Mysql service of my local server over internet.!

I need a help regarding connecting to the mysql server which i have setup as LAMP and now want to make it accessible over internet but unable to do so. The sever is setup as a VM and is able to ...
0
votes
0answers
12 views

Why do webhosts make you explicitly add which IP addresses can remotely connect to their MySQL databases? [migrated]

In order to connect to a MySQL database, you typically use the following command: mysql -h host_address database_name -u db_user -p where db_user is associated with the database in question. ...
0
votes
1answer
19 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
92 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
17 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
16 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
0answers
48 views

Play 2.3, Amazon EC2: Can't connect to MySQL

I'm developing an application using the Play Framework (2.3), and now I'm trying to deploy it on Amazon EC2 for a live demo type of thing. However, it refuses to connect to the MySQL database. Here's ...
-1
votes
0answers
59 views

Can't access MySQL command line after yum update Centos

I need help I just run yum update on my centos 6.5 still not Reboot system and i can't login by command mysql [root@localhost]# mysql mysql: relocation error: mysql: symbol strmov, version ...
0
votes
1answer
68 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
25 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
12 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
32 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
52 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
15 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
22 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
38 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
35 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
73 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
34 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
52 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
12 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
39 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
99 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
59 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
95 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
33 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
17 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
22 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
21 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
20 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
18 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
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
85 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"); ...