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

learn more… | top users | synonyms

3
votes
2answers
681 views

How to access MySQL when I delete the root user on openSUSE 11?

Unfortunately I deleted MySQL users with the command delete from mysql.user and now I can't access MySQL. I tried looking at MySQL - ERROR 1045 - Access denied, but it is not proper for me because ...
3
votes
1answer
11k views

How to increase mysql max_allowed_packet for client?

I want to increase max_allowed_packet variable size for mysql client which is using remote server. I've googled it and the answers I could find only discussed changing the variable for server. My ...
3
votes
2answers
4k views

Error message: sudo: mysql_secure_installation: command not found

I'm trying to learn PHP and I'm just in the process of installing apache,msql and PHP. I'm on a mac osx 10.7.2 I downloaded: mysql-5.5.18-osx10.6-x86_64.dmg I'm now at the point of setting the ...
3
votes
2answers
2k views

connecting to mysql over ssh

All the computers involved are Mac OS X 10.6.x machines. I am on computer A, and have mysql running on it, and can connect to it as A~ $ mysql -u punkish -p database and so on. I have access to ...
3
votes
2answers
299 views

Can't install MySQL 5.5.11.7 (beta)

I've downloaded MySQL 5.5.11.7 installer from http://dev.mysql.com/downloads/. When launching the installer I get the following error message: This installation package could not be opened. ...
3
votes
2answers
2k views

Which DIR is the MySQL base directory after yum installed mysql

Seems that I cannot locate mysql DIR only bunch of binary files under /usr/bin I used yum to install mysql mysql-server mysql-devel and tried to install mysql and I used /init.d/mysqld to have ...
3
votes
1answer
1k views

Postfix: SMTP, use port 587 rather than 465

I have set up a mail server on AWS EC2 using the instructions from Flurdy: http://flurdy.com/docs/postfix/ it has mostly gone well. My issue is that I would prefer to use SMTP port 587 with TLS ...
3
votes
1answer
974 views

“mysqld_safe --user=mysql &” hangs after fresh install

I'm having issues getting my new MySQL server (v5.6) to start on Ubuntu Desktop 12.04 (64-bit). Description of the problem: The problem is that, after following instructions for installing to Linux ...
3
votes
1answer
711 views

Installing MySQL 5.6 Installer completely silent

I'm trying to execute the latest MySQL Community installer (mysql-installer-community-5.6.10.0.msi) silently, so I can then install it via the MySQLInstallerConsole. This way I can deploy it using ...
3
votes
1answer
117 views

Publishing an Excel Sheet to a Web Page

I have a dashboard in Excel which pivots off of a "Data" tab, which pulls a 65,000 record query from MySQL. The file itself is 100mb and too big for sharing via e-mail. My question is: What is the ...
3
votes
1answer
582 views

How to completely remove MySQL files from my windows computer

I have recently installed apache, php, and mysql. Apache and php are configured properly, but when I tried to configure mysql it shows that there is already a security file for mysql that is setup and ...
3
votes
2answers
120 views

MySQL optimisation in Linux

I am performing massive insertion operation towards a MySQL database (100+ million records). Afterwards, I select records out of the two tables using for the most part their primary key. I seek to ...
2
votes
4answers
193 views

What is the best way to convert a MySQL database to an access database?

I need to convert databases both directions and I also need to grab subsets of data on occasion. Is there an easy way to do this?
2
votes
3answers
145 views

Linux Web Server

I'm looking to set-up my own local web server using Linux, to allow me to run and develop PHP applications using Apache and MYSQL. Can anyone recommend the best distribution of Linux server to use. ...
2
votes
4answers
7k views

Can't create a MySQL dump on Windows, fails before password prompt

I'm trying to create a dump of a locally installed MySQL database on my laptop. I am aware of the command: %>mysqldump -u root -p --opt [database name] but I am not able to execute it. I might ...
2
votes
2answers
143 views

Why would a MySQL function be getting randomly dropped?

I have the following function that is used in several databases on my server. CREATE FUNCTION `fn_strings_intersect`(arg_str1 VARCHAR(255), arg_str2 VARCHAR(255)) RETURNS varchar(255) CHARSET latin1 ...
2
votes
1answer
117 views

SQL import size

I'm in the process of importing a couple of SQL dumps into my own mySQL server. The size of these dumps, from Wikipedia, are 2.3 GB and 22 GB. Is the size of an SQL dump file approximately the same ...
2
votes
3answers
1k views

Public MySQL servers for use in sample code

Similar to how the IETF's example.com domain's web and email services can be safely used in code samples, is there a public MySQL server I can safely(*) use in some sample code? ("Safe" in that it ...
2
votes
2answers
8k views

Where is MYSQL installed on Mac?

I've always used MAMP or XAMPP to install MYSQL so it's been fairly straightforward. The only most I've had to do is create a symbolic link. I'm now starting to learn Django and I would like to ...
2
votes
3answers
2k views

Free Wiki software that can easily convert to confluence

Simply: What is some good free Wiki software that can be quickly/easily ported over to confluence? More specifically: We need something free that we can use to build up a repository of documentation, ...
2
votes
3answers
1k views

What's difference between this: sudo find /usr/local/mysql/data -type f -exec rm {} ';'

What's difference between this: sudo find /usr/local/mysql/data -type f -exec rm {} ';' and this: sudo rm -rf /usr/local/mysql/data
2
votes
5answers
494 views

Safe remote mysql connection

As you know, keeping the mysql port 3306 opened is unsafe - but I would like to use a good mysql administrative program instead of phpmyadmin, which requires 3306 port to be opened. Of course I can ...
2
votes
1answer
1k views

Different output when redirecting

$ mysql -e 'select a,b from tablefoo' databasename yields +---+---+ | a | b | +---+---+ | 1 | 0 | | 2 | 1 | +---+---+ whereas $ mysql -e 'select a,b from tablefoo' databasename > file ...
2
votes
1answer
3k views

How do I give a single user permissions over a schema in MySql Workbench?

I have a MySql server installed on a server along with MySql Workbench. About a year ago, I managed to do this and I felt like slapping myself as it was something so simple, but, I just can't ...
2
votes
3answers
5k views

How to copy MySQL database from one server to another?

I just finished making a website in Joomla! 1.6. Web sites in Joomla! consist of two basic parts. There are files which are used by HTTP server and there is the database. I have FTP access to the ...
2
votes
4answers
9k views

MySQL query builder? (like Access has in Design View) [closed]

Is there any free tools that would let me build queries like one can in Access?
2
votes
1answer
5k views

OSX Mavericks: MySQL homebrew after native install

I recently upgraded my iMac to Mavericks, and I realized I needed to reinstall MySQL. I installed the native DMG version and it was working well, and I should have left it there. But I neglected it ...
2
votes
2answers
296 views

Weird behaviour with mysql port forwarding

I have set up MySQL port forwarding in my machine as: ssh -f -N -L :9906:localhost:3306 <ssh login> Now, if I try to connect to MySQL from my localhost as: mysql -u<user> ...
2
votes
1answer
3k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
2
votes
1answer
257 views

awk: equivalent of mysql's “\G” to print tabulated data in multiple lines

Is there an equivalent to mysql's "\G" at the end of the query but awk (or similar) that will to print tabulated data from a text file in multiple lines with the header next to it? Something that will ...
2
votes
3answers
6k views

MySQL Workbench, start with auto commit off

I'm running MySQL Workbench 5.2, and whenever I make a connection to a database auto commit is toggled on. Is there any way to have the default behavior be changes so that auto commit is toggled off, ...
2
votes
4answers
4k views

How can I install mySQL on CentOS without being root/su?

I want to install mySQL on CentOS. I do not have a root account on that machine. How can I install mySQL on CentOS as a user, ie. without being root?
2
votes
2answers
2k views

Ubuntu, user can't write to a directory and I don't see why not

I've got a directory, /var/www/someProject/backup/mysql, and I want the user mysql to write to it. Each time I try to write to it with the mysql user, I get a "can't read/write" error. Yet the ...
2
votes
1answer
82 views

Terminal automatically moving me out of a directory?

I'm noticing a strange issue where I appear to be forcefully cd'ed out of my MySQL data directory every time I cd to it. I'm using Terminal.app on OS X 10.6.1. joebmaclap:mysql joeb$ cd ...
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 ...
2
votes
4answers
1k views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
2
votes
1answer
161 views

How can I enforce atomic inserts?

I'm working on an application backed by a MySQL instance, and I've encountered strange behavior involving what seems to be "phantom" inserts. Given a table with an auto-incrementing integer key, I ...
2
votes
1answer
2k views

issue on starting of mysql

I have installed "mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz" in user specified directory. I tried to start the lam, but it is saying "Starting MySQL..The server quit without updating PID file ...
2
votes
1answer
119 views

How to abandon current command in MySQL CLI?

In the MySQL/MariaDb command line client, if I have the cursor in the middle of a long query and I want to abandon that command I have to reposition cursor at the end of the line check whether the ...
2
votes
2answers
2k views

MySQL won't start because it can't find mysql-bin.000006 (Errcode 2), how do I fix this?

MySQL (part of AMPPS) suddenly stopped working. Looking at mysql.err it says it can't start because it cannot find mysql-bin.000006 (error 2). Here is the full log from mysql.err: 130401 17:00:47 ...
2
votes
4answers
3k views

Installing MySQL without root access

I am trying to install MySQL without root permissions. I ran through the following steps: Download MySQL Community Server 5.5.8 Linux - Generic Compressed TAR Archive Unpack it, for example to: ...
2
votes
4answers
2k views

I want find a good mysql Manager use on Ubuntu

On Windows, i use SQLyog. And I am new to Ubuntu. Is there any mysql manager programs as good as SQLyog?
2
votes
2answers
4k views

Why isn't my port forwarding with mysql working on my server?

I have a mysql server running on some server in our network. Now, only connections from localhost are accepted by the server and I can't connect to it remotely. Now, I want to set up a port ...
2
votes
1answer
2k views

Export MySQL database structure

I have a MySQL database. I would like to export the tables/structure to a script. I don't need the data, just a script to create all tables I have. I have access to PhpMyAdmin.
2
votes
3answers
489 views

MySQL Workbench equivalent for OS X

Is there any equivalent of MySQL Workbench for OS X? The current version is very slow and hangs up even with 8GB RAM.
2
votes
3answers
5k views

How do I start a MySQL Server in Windows ?

I've installed a MySQL server onto my computer and when I first installed it, it ran automatically, now I've restarted my computer it is no longer running, what file do I need to run to get it back up ...
2
votes
1answer
118 views

How can I reimage my virtual server to not have size caps to individual directories?

As a prenote, I am extremely new to networking in general, and my knowledge is very minimal, even for things you guys would consider basic. I will try my best to keep up with any advice you have to ...
2
votes
1answer
3k views

Error installing mysql 5.5 FATAL ERROR: Could not find my_print_defaults

I installed Mysql 5.5 using Homebrew, specifically Homebrew versions - https://github.com/Homebrew/homebrew-versions. After the installation, I attempted to run the commands it suggests: Set up ...
2
votes
2answers
379 views

MySQL query fails instantly

I recently loaded a large (~5GB) database from an SQLdump into a local MySQL server database. Loaded fine after a couple of tries, and initially I could query without a problem, although queries took ...
2
votes
1answer
505 views

apt-get fails at everything in Ubuntu due to postgresql error - how to fix?

I've got a server with zoneminder, mysql, ffserver and some ffmpeg instances running on it, but for some reason everything seems to be tied to PostgreSQL. I noticed an error when loading the ...