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

How to install MySql on Ubuntu 10

I have done the following: shell> sudo apt-get install mysql-server-core-5.1 shell> sudo apt-get install mysql-client-core-5.1 Both seemed to complete fine with no errors. I have the ...
3
votes
2answers
4k views

Convert MySQL DB from MyISAM to InnoDB

So I think I am having problems with a component of Joomla because I do not have my db setup to use the InnoDB engine. I think this because I have not changed anything in the running of MySQL and ...
3
votes
2answers
14k views

How Do I Reset My Root Password on MySQL on a Mac?

I'm using SequelPro (http://www.sequelpro.com/) and I would like to know how to reset my root password. I'm trying to log in as host: localhost username: root password: (BLANK) But I keep ...
3
votes
1answer
769 views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: ...
3
votes
2answers
377 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 ...
3
votes
1answer
7k 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 application, but it is saying "Starting MySQL..The server quit without updating PID file ...
3
votes
2answers
5k 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 ...
3
votes
2answers
2k views

save mysql logins

I have to log into multiple MYSQL DB's on different hosts via mysql cli. is it possible to save these logins so I don't have to trackdown/remember the credentials?
3
votes
2answers
915 views

What does ./configure do?

I am trying to install MySQL on Snow Leopard. The commands go something like this: cd mysql ./configure make sudo make install However, I am not able to get past the configure step because I get ...
3
votes
2answers
5k views

Do you know any MySQL (web based) online clients? [closed]

Do you know any online (web based) MySQL clients ? I mean an application that allows me to login to a remote MySQL server. (A third-party web hosted installation that allows me to specify the IP, ...
3
votes
1answer
1k views

Mysql service refuses to start - /sys/devices/system/cpu/ read fail

mysqld service refuses to start. sudo service mysql start See listing below. Running mysql_upgrade did not help. I found some forum posts that it happens after Ubuntu upgrade, but found no ...
3
votes
2answers
3k views

$PATH issues with OSX Lion

I'm having some issues with running mysql from terminal: macmini:~ michael$ which mysql /Applications/XAMPP/xamppfiles/bin/mysql macmini:~ michael$ mysql -bash: /usr/local/mysql/bin/mysql: No such ...
3
votes
1answer
4k views

Grant MySQL user ability to create databases, and only allow them to access those databases

Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
3
votes
1answer
2k views

Reduce MySQL memory usage on a development box

On my mac, after a fresh restart with zero connections, MySQL is currently using 40MB of memory, 188MB of virtual memory (on-disk database paged in?), and has 16 threads. Since there's only ever one ...
3
votes
1answer
331 views

Can you change the mysql prompt?

I use the "mysql" command-line tool all the time, and frequently forget what database (schema) I'm on. Is there a way to change the prompt? It'd be much more useful to see foo_bar_schema> than ...
3
votes
4answers
6k 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: ...
3
votes
3answers
2k views

mysql-python on Snow Leopard with MySQL 64-bit

Can't seem to get mysql-python to work on Snow Leopard for the life of me. Currently using the default version of python that ships with Snow Leopard (python 2.6.1). Installed MySQL 5.1.45 x86_64. I ...
3
votes
1answer
239 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
3
votes
1answer
908 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
113 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
1answer
1k views

How do I upgrade MySQL 5.0 to MySQL 5.1?

I need to upgrade my MySQL installation to version 5.1 from 5.0.37, and I have studied the documentation here and performed all the necessary preliminary steps but (call me stupid) I can't find ...
3
votes
2answers
6k views

Is it possible to modify the output column delimiter in MySQL query results?

Is it possible to modify the string used to delimit output columns in command line MySQL query results? E.g. could I change | to ! or ||?
3
votes
2answers
348 views

Access denied for user 'root'@'localhost' (using password: YES)

I am following the Moodle 3.0 dev installation. In the database setting process there is an error: Error: Database connection failed It is possible that the database is overloaded or otherwise ...
3
votes
2answers
3k 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 ...
3
votes
2answers
2k 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
102 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
3answers
11k 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
355 views

Does eCryptfs prefetch and/or buffer data?

I have been experimenting with using eCryptfs as the underlying file system for MySQL data to mimic transparent data encryption for MySQL. I ran some tests to measure the overhead of decryption when ...
3
votes
1answer
6k 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
864 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
19k 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
7k 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
320 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
27 views

Initialize MySQL database as non-root and run SQL server for testing

I want to do some MySQL-specific testing and need to run a fresh MySQL database as non-root user. I am using Debian Linux and expect one could start the mysql_install_db and other commands as normal ...
3
votes
1answer
464 views

Can't connect to local MySQL instance when ran as service

I've been running a local MySQL server for development purposes lately and for some reason never got around to running it as a service so I was constantly starting it up using the mysqld.exe every ...
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
2k 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
978 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
232 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
661 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
1answer
4k views

Installing MySQL 5.1 on Mac 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 ...
3
votes
2answers
129 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
21k views

WAMP MySQL Service will not start

I did a fresh install of WAMP (v2.1) and it works excep the MySQL isn't starting.... here: and everytime I press "Start/Resume Service", NOTHING happens. I go to my.ini and put in a password.Then ...
2
votes
2answers
581 views

How to automatically restart MySQL and MongoDB when being unresponsive?

I’m running a simple development server (Ubuntu) on which MySQL and MongoDB sometimes crash. I always restart them with sudo service mysql restart. Although I know I need to investigate why they ...
2
votes
4answers
199 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
150 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
12k 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
9k 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 ...