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

learn more… | top users | synonyms

30
votes
3answers
31k 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. ...
25
votes
1answer
45k 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?
23
votes
5answers
21k 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?
20
votes
4answers
51k 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
62k 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
2answers
10k 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 ...
16
votes
4answers
2k views

MySQL command line color prompt

I want to add colors to the MySQL command line color prompt. I have so far in a script (database.sh): mysql -uroot -hlocalhost -A --prompt="\u@\h:\d> " I would like root to be red, @ to be ...
15
votes
2answers
8k 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 ...
15
votes
2answers
6k 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 ...
14
votes
3answers
18k 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.
14
votes
1answer
3k 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
7answers
42k 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 ...
12
votes
3answers
15k 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 ...
12
votes
4answers
15k 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
6answers
19k 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: ...
10
votes
2answers
120k views

mysql how to fix Access denied for user 'root'@'localhost'

Before I screw up something, when login using $ mysql -u root -p , and show databases, +--------------------+ | Database | +--------------------+ | information_schema | | mysql ...
10
votes
6answers
11k 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
14k 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
45k 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
9
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.
8
votes
9answers
22k 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 ...
8
votes
8answers
18k 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
4k 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
2answers
3k 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 ...
7
votes
4answers
29k 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 ...
7
votes
1answer
4k 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 ...
7
votes
5answers
12k 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.
7
votes
3answers
4k 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 ...
7
votes
4answers
494 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
1answer
12k 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 ...
6
votes
1answer
8k 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 ...
6
votes
1answer
5k 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 ...
6
votes
4answers
618 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
3answers
4k views

phpmyadmin symlinks error after ubuntu upgrade

After the upgrade of my ubuntu server to 13.04 my phpmyadmin is no longer reachable. the browser reports 500 (internal server error) and in the error.log it says: PHP Fatal error: require_once(): ...
5
votes
3answers
2k 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 ...
5
votes
3answers
4k 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?
5
votes
3answers
1k views

\G like vertical output in MySQL Workbench for show engine innodb status

show engine innodb status; is unusable in MySQL Workbench, as shown here: =====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second ...
5
votes
2answers
5k 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
584 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 ...
5
votes
1answer
2k 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?
5
votes
2answers
4k views

How to drop all MySQL tables from the command-line?

Usually I open Terminal.app and connect to a remote MySQL database. Then I use this command to drop a table: mysql> drop table [table name]; But what I need is the command line to drop all ...
5
votes
2answers
228 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
2answers
12k views

How do I clear all data in a MySQL database while maintaining the table structures?

Using MySQL CLI, how can I remove all data in a given MySQL database without changing any table's structures?
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
280 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
56k views

How can I start phpMyAdmin?

I have just installed phpMyAdmin on my Ubuntu (using sudo apt-get install libapache2-mod-auth-mysql php5-mysql phpmyadmin). I think installation went OK. So, how can I start the phpMyAdmin now? I ...
4
votes
2answers
9k 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
10k views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
4
votes
1answer
607 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".