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
881 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
4k 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
3k 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
1k 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
318 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
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
215 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
4answers
7k views

bind-address = ::1 # however, netstat shows 0.0.0.0:3306 LISTENING

I'm running MySQL 5.6 on 64-bit Windows 7 with IPv6 and IPv4 enabled. In my.ini: port=3306 bind-address = ::1 I was hoping to use IPv6 and restrict to the loop-back adapter. I used ::1 instead ...
3
votes
2answers
5k 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
3answers
26k 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 ...
3
votes
1answer
815 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
9k views

How can I split a large SQL file into smaller chunks? [duplicate]

Possible Duplicate: How to split large file on Windows? I have a 100MB SQL file which my host won't let me upload all at once (2MB per upload). The database is on a different server so I ...
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
81 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
1k 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
98 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
10k 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
347 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
852 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
18k 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
318 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
40 views

Connection failed, Access denied connecting to MySQL via ODBC on Windows

I know nothing about MySQL or Linux and am tasked with migrating a MySQL DB to MS SQL. I found a tool for that but it requires an ODBC connection so I downloaded the MySQL Connector/ODBC and installed ...
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
946 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
229 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
653 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
127 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
197 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
2answers
434 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
3answers
148 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
3answers
18k 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
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 ...
2
votes
2answers
151 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
2k 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
3answers
3k 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
2k 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
3answers
165 views

Can't include an HTML link in PHP script, but works fine as MySQL query

I'm using the following as part of a PHP script: mysqli_query($con,"UPDATE table SET description='<a href="http://123456.biz/index.php/123/321/456/*/789">text</a>' WHERE description IS ...
2
votes
4answers
235 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
611 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
4k 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 ...