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
3k views

Installing phpmyadmin package ERROR 1045 (28000)

I need to create a new mySQL db for a local site, I thought I'd do that with phpMyAdmin so I installed that package like so: sudo apt-get install phpmyadmin During this process I get a couple of ...
3
votes
1answer
465 views

How do I run mysqld as a regular non-daemon program?

I'd like to run a local copy of mysql, to keep software development environments isolated. However, I can't seem to get the mysqld server to start up. I've created a database directory with ...
3
votes
2answers
109 views

According to current knowledge where should you store passwords on your server and how do you protect them?

Given is a system of PHP and MySQL on a virtual server. I want to save passwords there. Frequently you hear people speak about their system being hacked and credit card information being stolen. ...
3
votes
2answers
995 views

Start MySQL from the command line without losing prompt

I'm on Windows 7. I'm trying to run a .bat file where I stop and start MySQL and run some other commands. However, running "C:\Program Files (x86)\EasyPHP\binaries\mysql\bin\mysqld.exe" results in ...
3
votes
1answer
6k views

Installing MySQL Server on a Mac with Homebrew

As a total newbie I am trying to get through this tutorial: http://net.tutsplus.com/tutorials/python-tutorials/python-from-scratch-creating-a-dynamic-website/ I'm at the point where I've used brew ...
3
votes
1answer
89 views

Installed mysql from source on linux and then how to get it work with php?

I installed apache and php from source and got them working together a month ago. Because I'm learning both of them this term. Now I need mysql to do more works. And I installed mysql from source just ...
3
votes
2answers
6k views

WAMP MySQL service does not start

My question is similar to this. But none of the posted solutions worked. my.ini file is pasted here. 'mysql.log' is pasted here. The problem seems to be caused for no reason. I don't remember ...
3
votes
1answer
5k views

MySQL doesn't start

I've installed Portable Xampp on my flashdrive. Here is what I'm getting when I try to start MySQL on portable XAMPP server. (Apache starts without any fail) And log looks like that 121003 ...
3
votes
2answers
720 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
13k 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
3answers
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
305 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
1answer
2k 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
1k 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
804 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
0answers
223 views

Problems with bash script, mysql inserts and launchd

I am developing a automated system, which consists of 3 parts: mysql, bash and launchd. Bash script takes folders of work related stuff, zips, archives and puts info about them into database that is ...
3
votes
1answer
608 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
124 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
194 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
2answers
9k 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
4answers
8k 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
145 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
3answers
20k views

Creating a .bat file to execute mysql and other commands

I'm looking for a way to reduce the amount of typing I do to check mysql entries and other things. For example, I wanted to create a .bat file that will execute the following commands. mysql -u user ...
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
4answers
7k 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
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
4answers
203 views

Accessing a mySQL database on an external server

I have a large (multi-gigabyte) SQL database on an external server. I can access it through SSH, but manually querying the data will be a major pain. I really need a GUI. I'm using Ubuntu 13.04, but ...
2
votes
5answers
530 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
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
10k 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
2k views

View existing indexes using phpMyAdmin

Using phpMyAdmin, is it possible to view existing indexes on a table? If so,how? One of my tables should have an unique index with two keys, and I want to confirm it exists.
2
votes
1answer
229 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
2answers
343 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
270 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
4answers
6k views

How do I reset the MySQL password under Windows?

When trying to restart my MySQL password I get the following output in the console (this is also the input that caused the output): C:>"C:\MySQL\bin\mysqld" --console ...
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
120 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
1answer
3k 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
147 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
3k 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 ...