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

MySql database from usb stick

I recently installed a portable WAMP server on my usb stick. Really nice, I can do some php programming on my girlfriend's windows7 laptop without installing anything on it. I also have a LAMP ...
3
votes
2answers
3k views

MySQL localhost connect works but 127.0.0.1 does not

Does anyone know what the error could be when I can connect to my MySQL server via localhost but not via 127.0.0.1? AFAIK, these should be routed identically and no additional TCP layer should be ...
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
3answers
498 views

How to store the data of mysql on OS X in an encrypted state?

I have mysql 5.1 installed by macports with it's data dir in the default location, which is outside my user directory that's protected by filevault. I'd like to store the data in an encrypted state ...
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
16k 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
2answers
37 views

How to check every directory size using one shell command?

I want to get database sizes for - test, mysql, performance_schema, sakila, information_schema [root@linux data]# ls -ltrh 总用量 32M drwx------ 2 mysql root 4.0K 4月 27 17:44 test drwx------ 2 ...
3
votes
2answers
419 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
5k views

MySQL Notifier High Severity Error at startup

When I start MySQL Notifier up, an error like this is shown: "High Severity Error" "Object reference not set to an instance of an object." And when I click over "Show Details" I can see the ...
3
votes
1answer
8k 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
36k views

http://localhost:8080 is not working on running apacher Server through XAMPP

I am unable to configure a PHP/MySQL/Apache environment on my local machine using XAMPP. In my xampp control panel the Apache and MySQL status is shown as started, but localhost URL is not working. ...
3
votes
2answers
949 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
665 views

Replace contents of Excel column with realtional data from another column/sheet?

I have two excel sheets that have been exported from MySQL, with relational data in them, and I need to replace the reference ID's with the actual data from the relative column. For example, in one ...
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
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
355 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
7k 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
256 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
1k 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
114 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
717 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

phpMyAdmin cannot login - keeps asking for credentials

I have phpmyadmin on my Arch linux box, it is running, so is apache with php and mysql. When I go to http://localhost/phpmyadmin/, it shows the usual login prompt. However, no matter what I enter, ...
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
106 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
12k 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
377 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
7k 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 22:07:...
3
votes
2answers
870 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
20k 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
8k 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
321 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
38 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
493 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
3k views

Initial administrator log in to horde

I have installed horde webmail on my debian wheezy machine using the jessie packages and this guide: https://wiki.debian.org/Horde I have set up a database skeleton in mysql - just created a horde ...
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
1k 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
235 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
672 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
130 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 ...