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

learn more… | top users | synonyms

24
votes
3answers
28k views

Disable MySQL startup in Ubuntu 10.04

I want to prevent MySQL from starting in Ubuntu 10.04 I have used update-rc.d -f mysql remove and confirmed that there is no link to the /etc/inid.d/mysql script from any of the rc?.d directories. ...
20
votes
4answers
43k views

Sync Two MySQL Databases

What is a good way to sync two MySQL databases? I would like to sync the data in my production website's database to my local development database. Right now, I am just using the PHPMyAdmin ...
19
votes
4answers
53k views

What steps do I need to take to completely uninstall MySQL?

I have installed and uninstalled MySQL Server for about 100 times. Each time I reinstall the thing, it shows the same configurations, which I think cause problems. I would like to get rid of all ...
16
votes
5answers
14k views

How do I stop services from starting on boot on Ubuntu?

I have lots of servers installed (Apache, MySQL, etc.), but I don't want them all to start at boot time (they drain power, and I'm on batteries most of the time). How do I configure this?
15
votes
3answers
29k views

How do I log out of `sudo su` in Ubuntu?

I am semi-new to Ubuntu and I am using sudo su to start mysql and do some homework with it. When I quit mysql I then am still in sudo. How do I "log out", so my prompt changes back from # to $?
14
votes
2answers
6k views

create mysql database with one line in bash

Is it possible to create an empty database with one line of command in bash? My newbie attempts have failed: mysql -uroot $(create database mydatabase;) I end up having to mysql -uroot create ...
13
votes
1answer
2k views

MySQL Preference Pane control for MySQL installed via Homebrew

this is a repost of my question at apple.stackexchange.com I have installed MySQL via homebrew: brew install mysql. I'd like to get the MySQL preference pane hooked up to my installation of MySQL ...
13
votes
3answers
2k views

mysql command line color prompt

mysql command line color prompt: I want to add colors to my MySQL prompt: I have so far in a script (database.sh): mysql -uroot -hlocalhost -A --prompt="\u@\h:\d> " I would like root to be ...
12
votes
1answer
30k views

How to remove 1000-row limit in MySQL Workbench queries?

During execution of an SQL Query in MySQL Workbench, the query is automatically limited to 1000 rows. How does one prevent the tool from imposing this limit?
12
votes
3answers
14k views

How do I uninstall MySQL on Mac OS X (Snow Leopard)?

I had installed MySQL from the command line when I setup a local web server with custom modules on my Snow Leopard box. I recently discovered MAMP and its just easier to work with it than with the ...
11
votes
5answers
13k views

systemctl enable differs from systemctl start, how?

I am running an Arch Linux (latest, up-to-date) box, and attempting to get MySQL to start at boot. With the systemd package installed I have systemctl available, and as such I can do things like this: ...
11
votes
3answers
11k views

how do I see which user I am logged in as in MySQL?

I have multiple text console session open and log in as different users into different consoles. I forget after while which consoles belong to which user, it would be nice to not have to quit and log ...
11
votes
2answers
13k views

How to export mysql schema from phpmyadmin?

I have a huge db that hangs the server if I try to export it, is there a way I can export it without all the data? Only the tables structure.
10
votes
7answers
30k views

How to remove MySQL service from Windows

I've removed all MySQL programs from my Win7 64bit desktop and I still have the MySQL service.How can I remove it? MySQL programs I removed: MySQL Community Server 5.1 MySQL Community Server 5.5 ...
10
votes
2answers
4k views

Pipe gunzip and mysql to gunzip a dump and import it

I have a .gz sql dump file (example: foo.sql.gz) that i want import in my database with the classic mysql command. gunzip -c foo.sql.gz > foo.sql mysql -uroot -ppassword foo < foo.sql foo is ...
10
votes
2answers
5k views

Symlink error when installing MySQL via Homebrew

Trying to install MySQL via Homebrew. The install seems to work fine but i get an error: "Error: The linking step did not complete successfully The formula built, but is not symlinked into /usr/local ...
10
votes
6answers
10k views

MySql client for Linux

What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code ...
9
votes
3answers
13k views

How to install the MySQL Ruby Gem on Ubuntu 9.10?

I am having a problem installing the Ruby Gem for MySQL. This is the command that I am running: sudo gem install mysql and this is the output that I'm getting: Building native extensions. This ...
9
votes
6answers
42k views

Install MySQL 5.5 on Ubuntu 10.04

How to install the MySQL 5.5 on Ubuntu 10.04? apt-get install mysql-server is only allows to install 5.1.41.3ubuntu12
8
votes
7answers
14k views

MySQL won't start!

I'm getting this error when trying to log into MySQL from the command line: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) I think this ...
8
votes
3answers
3k views

I can't open phpMyAdmin, get error 301 or 500

I've installed phpMyAdmin, but I can't open it on any browser: I get a 301 redirect(*) if I browse to http://localhost:8080/phpmyadmin. If I add a / to the end of the addres, I get a 500 error status ...
8
votes
5answers
2k views

How can i retreive a mysql database from a hard drive?

My mythtv box crashed because of a corrupted hard drive. I can see my data when connected it to another computer. I need to know how I can retrieve the database so I can load it on my new drive.
7
votes
9answers
20k views

Configuring a MySQL 5.1 Instance on Windows 7 Professional x64 Fails

I'm trying to set up my laptops to function as mobile development environments. Installing the software on my Linux machine and getting it configured was fairly straightforward, however I'm having ...
7
votes
4answers
442 views

I'm managing SQLite, MySQL and PostgreSQL databases and want a tool for this locally

I develop web applications on Mac OSX in SQLite, MySQL and PostgreSQL and these are then put on the webserver. I want to be able to take the brunt out of looking at the terminal locally when dealing ...
6
votes
4answers
19k views

How to restart MySQL

I am running MySQL 5.1.54 and installed it on Ubuntu through the terminal using the command sudo apt-get install mysql-server I changed the my.cnf file and would like to stop and then start the ...
6
votes
1answer
3k views

File not found error with mysqlimport

I'm setting up a local database for gene annotation following the instructions on this page. They provide an .sql file to create some MySQL table structures (step 4) and several data files to populate ...
6
votes
3answers
3k views

Debian - Can't stop MySQL; permissions?

I just tried to upgrade from debian squeeze to unstable by replacing 'squeeze' with 'unstable' in /etc/apt/sources.list. The upgrade went smoothly except for mysql, which failed because it couldn't ...
6
votes
2answers
2k views

How can I limit the number of child processes that MySQL spawns?

Is there a way to limit the number of children than mysqld spawns? Or should one not worry about that? My VPS only has 512MB of RAM. Here's the output of htop, after I set max_connections to 6 and ...
6
votes
4answers
426 views

Flash drive friendly (portable) XAMPP alternative?

I'm trying to setup a portable MediaWiki wiki on a flash drive using XAMPP portable as a server. http://lifehacker.com/354005/run-your-personal-wikipedia-from-a-usb-stick When I try to start apache ...
5
votes
2answers
4k views

What does the MySQL “max_allowed_packet” setting actually control?

We've been cleaning up database problems for the last four hours, thanks to a broken mysqldump that wasn't sufficiently erroring out. We were getting these errors: mysqldump: Error 2020: Got packet ...
5
votes
1answer
5k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...
5
votes
5answers
9k views

Alternative to MySQL Workbench? [closed]

Is there a free alternative to MySQL Workbench? I really need a visual database designer that doesn't crash every five minutes.
5
votes
2answers
200 views

is there any way to find out how I was hacked? What was the weak point?

one of my site hacked few times :( first I lost all databases, some tables were cleared and some of table's data had changed! than at the second hack, all tables were cleared and some php files' codes ...
4
votes
6answers
1k views

Is MySQL installed by default with OS X Leopard 10.5 or 10.6

If so where can I find the installation?
4
votes
2answers
257 views

Is there a good RAM health scanner available?

I have an issue that I'm trying to figure out with MySQL Workbench 5.2.34 on Win7 64-bit Ultimate. The exception information says System.AccessViolationException was unhandled Message=Attempted to ...
4
votes
3answers
1k views

How to script a database migration using an SSH tunnel?

I am trying to create a sync.sh script that coordinates with our less-than-ideal version control for our website. This script will migrate a live copy of the database to our development environment ...
4
votes
2answers
8k views

PHP Warning: PHP Startup: Unable to load dynamic library php_mysql.dll, Mac 10.6, Apache 2.2, php 5.3.0

I'm trying to use the PHP CLI, and when I enter something like php test.php in the command line it returns: PHP Warning: PHP Startup: Unable to load dynamic library ...
4
votes
1answer
483 views

Is MySQL login via the -p switch insecure?

I want to login to a MySQL database from a shell. Normally I use mysql -p But I just noticed the following in the the MySQL help: -p, --password[=name] Password to use ...
4
votes
4answers
3k views

SQLyog alternative [closed]

Do you know any app similar to SQLyog (sql gui admin tool)? Especially, I am looking for opinion from users who had used SQLyog and found "something better".
4
votes
1answer
3k views

How to escape MySQL command prompt

I have installed MySQL. Now I am stuck inside the MySQL command prompt. I ran MySQL like this: C:\>mysql.exe mysql> Then I type in some invalid command like this: mysql> /version ...
4
votes
1answer
3k views

Trying to install MySQL, lots of brew doctor errors

In OS X Lion I couldn't install mysql. I get this when typing brew install mysql Error: You must `brew link cmake' before mysql can be installed so then I type brew link cmake ...
4
votes
3answers
2k views

Difference between mysql, mysql-server, mysql-client in Linux

I've installed mysql, mysql-server or mysql-client on Linux. What is the difference between them?
4
votes
2answers
5k views

Rails: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

So I've got a Ruby on Rails application that I am trying to run (in development) on Snow Leopard. I've got it working on my Ubuntu computer, but now I need to get my Snow Leopard environment set up. ...
4
votes
2answers
2k views

Can't start mysql (xampp) after installing on external drive

I decided to move my XAMPP installation to external drive. It's USB3 3TB Seagate drive. Unfortunately mysql doesn't want to start. All works fine if I install XAMPP to C drive but doesn't work when I ...
4
votes
1answer
458 views

Being 'nice' with I/O: limiting a processes I/O resources in *nix

I'm working on a big shared Ubuntu server and am annoying my colleagues. One of my processes is making a lot of inserts into a MySQL database and it's bogging the whole server down. MySQL is not ...
4
votes
1answer
1k views

MySql Workbench and SSL support

I want to connect to Amazon's RDS MySql service using MySql Workbench 5.2.33 running on Windows. I want to connect using SSL. How do I do this? How can I verify that I am connecting using SSL?
4
votes
1answer
161 views

Which TAR to install - IA-64 or X86 64bit?

I just installed 64bit Ubuntu Server 10.04. Server is Dell PowerEdge R710 with Intel Xeon 5506 Quad Core CPU. I am trying to install MySQL server 5.5 now, just wondering which TAR file I should pick - ...
4
votes
1answer
2k views

MySQL completely uninstalled and reinstall but database still exists on Ubuntu 12.04

I need to completely remove MySQL all databases and installation and reinstall, because root is broken. I followed this instructions: sudo apt-get remove --purge mysql-server mysql-client ...
4
votes
1answer
45 views

Autostart PtokaX at boot only after mysqld has started

I've the following script in /etc/init.d/server.sh #!/bin/bash ### BEGIN INIT INFO # Provides: PtokaX server # Short-Description: PtokaX P2P server ### END INIT INFO ...
4
votes
3answers
2k views

can't stop or start mysql on fedora 17

I have recently setup a fedora 17 machine with Gnome and installed Mysql using the add/remove software GUi included. Mysql seems to be working - I can login, select databases, do queries etc but if I ...