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
29k 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
424 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 ...
12
votes
2answers
5k 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
3answers
13k 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
6k 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 ...
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 ...
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
182 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
58k 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 ...
2
votes
1answer
1k 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
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, ...
2
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 ...
1
vote
0answers
710 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
5answers
71 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 ...
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 ...
3
votes
3answers
50 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
4answers
6k 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
144 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
490 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
401 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
8k 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
151 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
6k 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
551 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
1answer
15 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
1answer
1k 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 ...
0
votes
2answers
824 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
75 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
505 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
133 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
476 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
426 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 ?