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
8 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 ...
-2
votes
0answers
12 views

What's is the most suitable python CMS framwork for my content management? [on hold]

I have four tables in mysql, this is not very big. The main table consists of a few properties of a video information, such as url and shortcut. Now I want to do a CMS which can help content operator, ...
0
votes
0answers
8 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
20 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
38 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
23 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
2answers
26 views

Apache - Access disk/directory is outside of the DocumentRoot and moving my.ini [on hold]

System: Windows NT 6.3 build 9200 (Windows 8.1 Home Premium Edition) i586 Installed:... DataBase Server: MySQL 5.6.20 Community Server (GPL) Web Server: Apache/2.4.10 (Win32) PHP/5.6.0 ... ...
0
votes
0answers
8 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
8 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 ...
-3
votes
0answers
11 views

SQL Database doesn’t work right [closed]

I tried increasing the size of one of my disks. I booted using a LiveCD and used gparted to set the desired size. When I rebooted LiLo failed, but I was ready for that and fixed it, but now MySQL ...
-2
votes
1answer
26 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
25 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
13 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
18 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
32 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
27 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
46 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
28 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
34 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
9 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
21 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
31 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
44 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
45 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
13 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
12 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
17 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
19 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
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 ...
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
44 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
37 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
22 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
148 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
64 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
158 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
60 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
14 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
21 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
39 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
67 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
27 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
20 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
21 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
1answer
24 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 ...