MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

2
votes
0answers
16 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
0
votes
0answers
8 views

MySQL database dumps on Windows 7 when one doesn't know the username, password, database name and host name

I've read this http://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/ but the problem is I don't know the username, password, database name or local host name as I ...
0
votes
1answer
23 views

My SQL Workbench crash when I want to save

Sorry for bad grammar, first at all, English is not my native language. :) First, I'd installed MySQL Workbench in my computer Windows 8.1, but when I want to save like a model for example, Windows ...
1
vote
1answer
4k views

Installing MySQL 5.1 on OS X 10.7 Lion

I am trying to install MySQL 5.1. I am on Lion, and when I remove all files associated with MySQL on my machine it still tells me that I have a newer version installed when I try to install it from ...
0
votes
1answer
4k 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
0answers
8 views

unable to open phpmyadmin Error during session start; please check your PHP …etc

I have installed xampp on ubuntu. I can access on firefox localhost/xampp. However when I go to phpmyadmin on the left it comes up with "phpMyAdmin - Error" Then underneath that it has this: "Error ...
0
votes
0answers
22 views

phpList is not showing Initialize Database Option

I just installed phpList on server. Also created mysql database. Now, I am opening it through ip-address/phplist/admin, It is showing just header. I can't see any option to Initialize Database. Soo, I ...
1
vote
1answer
2k views

Can phpMyAdmin be used to connect to a remote database?

I recently read this tutorial, which explains how one can easily reconfigure a local installation of phpMyAdmin to connect to a remote database. The functionality seems to be supported, but not ...
1
vote
1answer
99 views

install glassfish independently, or from netbeans?

I'm running Ubuntu on a desktop and laptop, and use Netbeans as an IDE. On the desktop, $/glassfish-4.1 has everything configured properly. I may have copied a JAR for MySQL over to the libs folder, ...
27
votes
2answers
48k views

How to remove 1000-row limit in MySQL Workbench queries?

During execution of an SQL Query in MySQL Workbench, the query is automatically limited to 1000 rows. How does one prevent the tool from imposing this limit?
0
votes
0answers
10 views

Metasploit: MySQL_Login USERPASS_FILE OptionValidateError - won't load any list files

I'm currently working through the Metasploit Unleashed course on offensive-security. I am stuck on this certain part here with some unexpected behaviour ...
-1
votes
0answers
41 views

How to drop whole tables in a database using batch script ( Windows)

I would like to know how to drop the whole tables in mysql database using batch script. I've already searched on how to do this in linux and this is what i've found: mysqldump -u$User -p$Pass ...
0
votes
1answer
4k views

Curl Returns “Connection Refused” when trying to access localhost

I am running Xampp (Apache, Mysql and PHP) on my Windows Vista computer. I have curl installed on my machine. When I try to curl my localhost in the command prompt, I get the following: curl -v -i ...
7
votes
4answers
31k views

How to restart MySQL

I am running MySQL 5.1.54 and installed it on Ubuntu through the terminal using the command sudo apt-get install mysql-server I changed the my.cnf file and would like to stop and then start the ...
1
vote
2answers
40 views

No package available when installing packages on CentOS 6.6

I wanted to install mysql-server on CentOS 6.6 (64bit). When I run yum install mysql-server, I get the following error: root@ip-50-62[/home/syn]# yum install mysql-server Loaded plugins: ...
0
votes
1answer
33 views

Can MySQL handle a string 2 million characters long in BLOB

A search using the title returned 1 question on Stack Overflow, which was not related, and with the MySQL docs 65535 characters was mentioned as a max; but is that ... normal characters or would it be ...
0
votes
0answers
6 views

Modify data values in a MySQL database by means of MySQL workbench?

I'm using MySQL workbench 6.0 on Xubuntu 14 I have tried to create a Database but I don't manage to insert values on the fields by means of the workbench. In fact in my template I have inserted some ...
0
votes
0answers
29 views

Connecting to mysql server at 127.0.0.1:3307 with iptables port redirect

I have a ruby application which, for various reasons, connects to a mysql server running at 127.0.0.1:3307. This works perfectly on the server side, but now I want to run this application on my ...
0
votes
3answers
258 views

Avoid starting MySQL on startup on Raspbian

I have a MySQL server running under Raspbian on my Raspberry Pi. How can I prevent the MySQL server starting on system startup? I read everywhere that I have to make changes in the ...
1
vote
3answers
52 views

Can a database be too relational?

I have a question about database design. I'm asking here because I'm an enthusiast/hobbyist and not a "professional" so I don't want to post it on the "Database Administrators" stack exchange ...
0
votes
0answers
38 views

phpmyadmin export from two tables where data in one column matches?

I'm running MySql server 5.6.2 with phpmyadmin 4.3.7 on a Windows 2012 server. I have one database - "tsl". Within "tsl" I have a table named "apps" and another table named "flat_apps". The "apps" ...
1
vote
0answers
79 views

Can't grant MySQL privileges to Debian system maintenance user [migrated]

I have a dedicated Debian 7 server running multiple websites with MySQL as the database server. When I tried to install the latest updates, MySQL couldn't be updated because the server failed to stop. ...
4
votes
2answers
682 views

Shell script of mysqldump works fine when run manually, but does not run in the cron job?

I have a shell script to get a MySQL database dump. This script works fine when run manually #!/bin/sh fqn=/home/Mysqluser/daily_dumps/bookstore_`date +%Y%m%d_%H%M%S`.sql.gz mysqldump -u root -h ...
0
votes
1answer
10 views

FTP and WWW services don't acknowledge connections

I have Lubuntu 14.04 LTS with vsftpd and the lamp stack (apache2, etc.) installed. Everything works fine on the LAN. Externally, the services don't acknowledge connection attempts. I can see packets ...
1
vote
0answers
137 views

How to recover MySQL database on xampp/windows using ib/frm files?

I'm using xampp on Windows 7. Couple of tables of my Wordpress database got corrupted. When I view the database in phpmyadmin, the tables have the message "in use". I tried ...
1
vote
0answers
20 views

Set up sftp mysql authentication with chroot

How do I set up an openssh SFTP server that authenticates against a MySQL table where the users are jailed? Each user will need to have its own jail: /home/sftp/john /home/sftp/jane etc.. However ...
17
votes
2answers
11k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
1
vote
1answer
3k views

MySQL ERROR 2002 (HY000) on CentOS 5

I have problem with starting up mysql. When I type service mysql start All I got is ERROR 2002 (HY000): Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock' (2)** ...
0
votes
0answers
9 views

How to identify the database and took backup from another server?

Please guide me in this situation. I have two domains domain1 and domain2, both domain are registered from the different provider but hosted on the same server (server1). My question is that if I ...
0
votes
1answer
100 views

Apache couldn't be started because port 8888 is in use by some other software

I am having an issue starting up MAMP, when I attemp it, I get this error message: Apache couldn't be started because port 8888 is in use by some other software I have been trying for the last 2 ...
-1
votes
0answers
31 views

Dependancy requires libmysqlclient.so.18, but already present

I'm trying to install HHVM via a yum repo, but the server keeps saying that the installer needs "libmysqlclient.so.18", yet if I run locate libmysqlclient.so.18 The server finds it, does anyone ...
0
votes
1answer
3k views

phpMyAdmin removes the primary key for MySQL table

My problem is this: I create a table in WAMP Server's phpMyAdmin, I always make the first column as name: id type: int index: primary auto_increment: true then I add other columns , mostly harmless ...
0
votes
0answers
31 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 ...
2
votes
1answer
30 views

Why mysqld set user/group of /var/log/mysql with ā€˜sā€™ rights?

In Ubuntu, sudo apt-get install mysql-server, the package will: create an account mysql create storage directory /var/lib/mysql with permission drwx------ 4 mysql mysql create log directory ...
0
votes
2answers
48 views

How do I use ssh ProxyCommand to connect to remote MySQL server behind bastion host?

Three machines are involved here. Localhost where I do my development. AKA laptop. Bastion host where you must connect first. AKA jump. MySQL server where I want to connect to. AKA DB. My ssh ...
0
votes
1answer
324 views

install php-fpm on centos after remoe it

i install php-fpm and php-mysql and nginx then i remove it and update servers kernel. now, when i want to install php-fpm ,.. dont install $>uname -a 2.6.32-504.3.3.el6.x86_64 #1 SMP Wed Dec 17 ...
0
votes
1answer
20 views

MySQL dump permission error

It seems strange but when doing mysqldump -h host -u backup -p database | gzip > /tmp/test.gz I get Access denied for user 'backup'@'%' (using password: YES) when using LOCK TABLES When ...
0
votes
1answer
43 views

Can't get MySQL server running on Windows 7

I had MySQL up and running several days ago with the help of a friend, but after a reboot I can't get it to startup. My understanding is that I am to run a command prompt as administrator, go the bin ...
0
votes
1answer
325 views

Database tables exist but MYSQL says they don't

When I log into MySQL and SHOW TABLES, I see a list of the tables. But, when I run a query against any of them, I get the message: ERROR 1146 (42S02): Table 'dbname.tablename' doesn't exist If I ...
0
votes
1answer
34 views

Asterisk Ivr menu mysql build

I would like to implement an IVR menu to see if the call comes in and announces a text waiting 6 numbers. Then the number 6 is controlled by a MySQL database. If "Active" or "Valid" the status will be ...
0
votes
1answer
532 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
vote
1answer
42 views

MySQL data on ramdisk partition

I'm using Docker with Ubuntu for my CI and development environment. I would like to put the database on a ramdisk partition to speed up the builds, since I have to reload my fixtures a lot, so data ...
-1
votes
0answers
28 views

php secure session management

I want to to write login scripts for clients websites to make them more secure. I want to know what best practices I can implement into this. There are password protected control panels in abundance, ...
0
votes
1answer
40 views

Why do I get this error installing MySQL server?

So I have a empty VPS running Debian 7 32bit. The VPS has just been created so nothing is installed but the base OS. I run apt-get update and then apt-get install mysql-server and i get this error: ...
0
votes
1answer
30 views

Mysql Connector crash on SQL Server 2008

I would like to create a linked Server betwenn my MYSQL Server and a SQL Server 2008. I already installed the MYSQL Connector ODBC drivers 5.1 (previously the 5.3 Version but same problem) on my SQL ...
0
votes
1answer
23 views

Mysql won't show my databases (MYSQL-WIN7)

I create a database using workbench and don't find this database at ODBC list, I'm able to see only information_schema database. I tried to restart my machine but don't solve the issue. Could you ...
2
votes
1answer
177 views

Do .frm files represent the entirety of a MySQL database?

So let's say I copy /var/lib/mysql and save it somewhere else, then uninstall/reinstall MySQL and put the original /var/lib/mysql back where it was. Will I have all of my databases without any ...
1
vote
3answers
4k views

Clear screen for MYSQL command line client

I am unable to clear the screen of the mysql command line client like I know in case of java it is 'cls'.
5
votes
2answers
20k views

MySQL InnoDB lost tables but files exist

I have a MySQL InnoDB which has all the database table files, but MySQL doesn't see them, and isn't loading them. The problem happened because I deleted these three files: ibdata1, ib_logfile0 and ...
0
votes
0answers
9 views

Suggestions on how to set up my dev server for dev clients (Linux and WIndows)?

I am creating web intranet systems and have always struggled with developing on multiple clients with moving files and databases over back and forth trying to keep everything in sync. I have now set ...