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. ...
3
votes
3answers
437 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 ...
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 ...
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 ...
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
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?
3
votes
2answers
2k 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 ...
2
votes
2answers
55 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 ...
1
vote
2answers
2k views

mysqld will not start

This is the error I get when attempting to start the mysql server: # mysqld start 130105 8:51:28 [Note] Plugin 'FEDERATED' is disabled. 130105 8:51:28 InnoDB: The InnoDB memory heap is ...
1
vote
1answer
1k views

Can't install MySQL on Mountain Lion

I have clean 10.8 OS X (with Retina MacBook Pro). I have totally the same situation like here Can't re-install MySQL on OS X Leopard after uninstalling and similar with that ...
0
votes
2answers
187 views

Linux permissioning issues

I'm trying to create a MySQL table on a different hard drive than the default. I get a permissioning error when MySQL tries to create the file. I think I can boil it down to the following lines of ...
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 ...
10
votes
2answers
118k 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 ...
4
votes
1answer
9k 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 ?
3
votes
1answer
4k views

launchctl: Dubious ownership on file (skipping) (Mac OS X)

I installed mysql recently and added its start command in my .bash file. But when I tried running the command, that's when I encountered this error: launchctl: Dubious ownership on file ...
3
votes
5answers
7k views

Free Mac OS X MySQL GUI [closed]

I'm looking for a good GUI app like Heidi SQL on windows for mac os x, snow leopard specifically. It can support more DBs than MySQL but needs to at least that. I'd like to be able to manipulate DBs, ...
1
vote
0answers
1k views

Why can't I access MySQL server with port forward rule in router?

This is my setup (the relevant parts, anyway): I have port forwarding rules in place (in the Linksys) for all the relevant ports and I've restarted that router multiple times, each time hoping that ...
0
votes
3answers
4k views

Export spreadsheet and import as table into mysql

What's the easiest way to export a table from either MS-Excel or OpenOffice calc and import it into a mysql database, where: The table will be imported as a table in Mysql The headers of the table ...
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 ...
3
votes
3answers
53 views

Why do I need ./ for commands to run on Mountain Lion? [duplicate]

Possible Duplicate: What does “/” , “./”, “../” represent while giving path? Why do I need ./ for commands to run on Mountain Lion? For example, when using mysql I have to type in the ...
2
votes
2answers
15k 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. ...
2
votes
4answers
7k 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 ...
1
vote
1answer
546 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 ...
1
vote
1answer
3k views

MySQL can't create pid file: Permission Denied

I'm using MySQL on my macbook pro, which worked fine for the last 2 years. A week ago it suddenly stopped and I'm not able to restart it again. I've changed the permission on /usr/local/mysql to 0777 ...
1
vote
1answer
582 views

Connecting mysql via 127.0.0.1 instead of localhost

I connected mysql on Mac OS X using this command: mysql -u root -p -h 127.0.0.1 After I logged in, I fired up this command: select user(); and it showed: root@localhost and even wired, I ...
1
vote
1answer
415 views

Can't re-install MySQL on OS X Leopard after uninstalling

I'm running Leopard (10.5.8) on a Macbook (not Pro) and I had MySQL running ok, but the Preferences pane wasn't working. I thought a fresh install would be a good idea, so I went through the uninstall ...
1
vote
2answers
10k 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 ...
1
vote
2answers
154 views

Installing MySQL on MacOS

I want to install mysql. Big Internet told me that I should do it via MacPorts. I've downloaded MacPort's dmg and it asks me to install XCode which I can buy via App Store. It is ridiculous to pay ...
1
vote
1answer
7k views

How to change mysql port

I'm using wampserver. And suddenly mysql wouldn't work. I checked curports from nirsoft and it has red highlight on it. What does it mean?How do I solve this so that I could use mysql again. I'm ...
1
vote
1answer
1k views

mysql doesn't stop on mac os x

I have mysql installed on 10.6 Snow Leopard. The problem is that I cant stop the server. Its running all the time. How can I solve that? I tried to install mysql again, but this didn't solve the ...
1
vote
1answer
583 views

MySQL ERROR 1045 Access Denied

I recently installed MySQL on Fedora13. Now, when I try to create a database, it denies me access. I tried resetting the password and it does not recognize my system root. I tried resetting password ...
1
vote
3answers
2k views

Lightweight MySQL Qt GUI frontend for Linux [closed]

I'm looking for a lightweight MySQL Qt4/PyQt4 GUI frontend for Linux. Ideally it will be very similar to sqliteman. I did some google searches but it only finds Java monsters and herds of shareware ...
0
votes
5answers
190 views

Mysql resolving 127.0.0.1 to hostname

I'm trying to connect to mysql using the command mysql -h 127.0.0.1 It comes up with the error ERROR 1045 (28000): Access denied for user 'root'@'mydomain.com' (using password: NO) Why is ...
0
votes
1answer
31 views

how to add mysql to path global variables [duplicate]

I have recently installed MySQL and am trying to access it through my command prompt by simply typing in MySQL. I believe I need to add it to my PATH globals. How can I do this?
0
votes
2answers
1k views

How to access local mysql server from the internet

I configured a router R1 to work as a repeater, I connected an internet router R2 from an ISP to it (R1). The internet router R2 was assigned a static IP (41.58.163.84) by the ISP. I run an intranet ...
0
votes
0answers
88 views

Reinstalling Mysql On Ubuntu 10.10(Stuck with bad repositories)

I recently configured NDB-cluster with mysql and Mysql just crashed ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) tried re-installing ...
0
votes
1answer
533 views

Cannot Login To phpMyAdmin

I'm running a simple LAMP server at home from which I host a personal blog. The server is running Arch Linux, with the latest-and-greatest versions of Apache, MySQL, and PHP. In order to easily ...
0
votes
1answer
134 views

How do I create a shortcut for a find and replace command in vim?

I have a vim (well, sed really) find and replace pattern I use for resetting the AUTO_INCREMENT property in mySQL CREATE TABLE statements: :%s/AUTO_INCREMENT=[0-9]*/AUTO_INCREMENT=1/g I use this ...
0
votes
1answer
504 views

utf8 hebrew on mysql console on debian (via putty on windows)

I have a my sql server running on a debian linux hosted at linode.com some of my data has hebrew characters in it. I am connecting to the server via putty ssh on windows 7. when I run the sql admin ...
0
votes
2answers
448 views

Why can't I install MySQL on my computer?

I have read a lot of tutorials, but I am still having problems. What I tried: I downloaded mysql-5.5.9-winx64. All that I read says that I can run Setup.exe, but there is no such file in the ...
0
votes
3answers
269 views

Free MySQL Comparer? [closed]

Is there any FREE MySQL Comparer for schema and / or records ?