An open-source and free relational database management system based on Structured Query Language (SQL)

learn more… | top users | synonyms

0
votes
2answers
488 views

Can not successfully re-install MYSQL 10.8.2

Removed the old installation as explained here: http://superuser.com/questions/129193/how-do-i-uninstall-mysql-on-mac-os-x-snow-leopard Installed the package contained in the mysql 5.1.67 DMG ...
0
votes
1answer
8 views

Can't download over MacPorts

So I'm trying to install the PDO drivers for PHP via Macports. I am using install php5-mysql, but when I hit enter I get usage: install [-bCcpSsv] [-B suffix] [-f flags] [-g group] [-m mode] ...
1
vote
1answer
32 views

Homebrew Replaced MySQL

I had mysql running fine on OS X until I accidentally installed it via homebrew as well. I cant start mysql using preference pane and I cant login to phpmyadmin using my root password. Is there ...
2
votes
2answers
2k views

How to stop xampp mysql server?

I just installed xampp on my mac os x. When I tried start mysql it displays a message that mysql is already running on this computer. In order to start mysql stop first mysql. I tried following ways ...
0
votes
0answers
18 views

MySQL instance is being used?

I would like to know which instance is being used, which version is responding the the mysql commannd. I am on OSX 10.9.1 I have homebrew MySQL 5.6.16 installed at : /usr/local/Cellar/ But I also ...
0
votes
0answers
14 views

how to build mysqlsniffer in os x 10.9

I'm trying to build that (hackmysql.com/code/mysqlsniffer.tgz) in my mac. I see only errors during compilation. I understand that is because of some gcc keys/options. Based on Google search i've ...
0
votes
4answers
77 views

Visualizing Data on a Mac? (MySQL db is source)

I'm having difficulty finding a promising OS X app for connecting to and visualizing data which resides in a MySQL database; it seems like there are various options for Windows, but not so much for ...
0
votes
0answers
32 views

Building mysql with readline instead of editline

I'd really like to be able to use readline instead of editline with the mysql client, but I can't find out how to do this. The bottled mysql that brew installs by default for mavericks is using ...
0
votes
1answer
32 views

Uninstalling all instances of apache, php and mysql

So When I first got my mac mini, I installed things like apache, mysql and php - not knowing that apple either came with these or had a tool called mamp that would allow you to run these. I thought ...
1
vote
0answers
63 views

Mac Pro running MySQL: Error 2013 Error 32

This is mysql running on an Mountain Lion OS X with server.app v2 that set up the server. We suddenly have an issue where only one of anything can seem to connect to mysql at anytime. The problem ...
0
votes
2answers
3k views

MySQL not working on mountain lion

I'm using mountain lion, I have installed MySQL. GUI It shows MySQL is running, but when I type mysql --version It gives error "mysql: command not found"
1
vote
2answers
155 views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
5
votes
3answers
4k views

MySQL does not start on startup

In the System Preferences panel, I have the MySQL there. I chose it to start up every time my Mac starts up, however this doesn't work, I have restarted MySQL many times, but it will not start up ...
0
votes
1answer
154 views

Mac Server setup for small office

We have a Mac Mini with OSX server for our small web design company's office. We want to move toward a local setup and to then push up to the live server. In the past I have used MAMP PRO and Sequel ...
0
votes
0answers
38 views

Allowing any admin user to run MySQL server on startup

I recently installed MAMP on our server in order to launch a Wordpress site. Though everything is working fine I am not the computer's main user, something which results in long downtime when it has ...
3
votes
5answers
824 views

How can I disable MySQL from starting at boot?

I have a mid 2013 MBA running OSX 10.9. The process that starts on every start up is mysqld. I believe it was from an old version of MySQL I had installed (via AMPPS). I then installed MAMP Pro and I ...
0
votes
0answers
62 views

install mysql for php 5.5 after install php with php-fpm and without mysql at first

I've installed nginx, php-fpm with brew via this command brew install --without-apache --with-fpm --without-mysql php55 now I need to adding MySql driver/adapter so my PHP code could connect to my ...
0
votes
0answers
86 views

10.9 Mysql serving content stunningly slow on restart until data has been loaded once

I have a 2012 iMac (12,2) with 20GB RAM running a little server at work. Since I installed Mavericks (a terrible, terrible error in judgement I wish I'd never made), every time I restart Spotlight ...
0
votes
0answers
49 views

Mavericks Server update from 10.8 Server - Is it safe on 3rd party additions

I posted this originally to discussions.apple.com but saw no traction. So, please forgive for the repost: I am running 10.8 + Server and am getting ready to update to 10.9. I have also installed ...
1
vote
2answers
4k views

The server quit without updating PID file (/usr/local/var/mysql/NAME.pid)

I have installed mysql via brew. First start works, but after reboot, I got the following error: The server quit without updating PID file (/usr/local/var/mysql/NAME.pid) I start mysql with sudo ...
1
vote
0answers
68 views

Heavy MySQL usage causes Dock process to freeze system

This problem has been aggravating me for several months, and I've gathered a lot of information about it, but I can't find the solution. I'm running XAMPP 1.8.2 on Mountain Lion, and I'm running a ...
15
votes
0answers
35k views

Is there a relational database with GUI for Mac similar to Microsoft Access or the like? [duplicate]

I need a desktop database that will have a need for extensive 1-many, many-1, and many to many relationships. I've built this kind of app with Microsoft Access, which I don't love, but does combine ...
0
votes
1answer
179 views

Mysql process takes 500 mb of primary memory

I have a MBA 2013, and its not more than few days that I installed MySQL. I have not created any database in mysql yet, but still it takes a lot of memory on RAM. I have configured it to start ...
0
votes
1answer
834 views

How to Automatic Backups of a MySQL Database

I am using the version of MySQL that came with Snow Leopard Server. I am running Time Machine on that server, but I know that it's not backing up the MySQL databases due to strict permissions issues. ...
0
votes
0answers
425 views

localhost MAMP OS X 10.8.4 upgrade tips

Follow the instructions exactly at http://documentation.mamp.info/en/mamp/installation/updating-mamp... 'COPY' and do not drag folders across to htdocs or from one folder to another. I dragged a ...
0
votes
2answers
282 views

MySQL - installation from source failed on ./configure

I'm following this How-to on installing MySQL on Snow Leopard but instead of using MySQL 5.1 I'm downloading the source for MySQL 5.5.11 so when I go into the source directory and run: ./configure ...
0
votes
1answer
307 views

Database app, accessible from Mac, iPad and Web

I feel very out of my depth with this query, but not being able to do it isn't really an option so I am going to have to learn how one way or another. I have been tasked with building an application ...
1
vote
1answer
412 views

MySQL (Percona) and homebrew:

I'm trying to run MySQL server (Percona) by launchctl load -w ~/Library/LaunchAgents/homebrew.mxcl.percona-server.plist and I see the following message in /var/log/system.log: Aug 9 01:36:14 xxx ...
1
vote
1answer
80 views

Problems with resizing terminal

I have a recurring problem with the Mac terminal. Start terminal mysql Ctrl + Z mysql Resize the width of the window Ctrl + Z fg 1 (switch back to first mysql) Type some text that reaches the end of ...
3
votes
2answers
8k views

Starting MySQL produces “The server quit without updating PID file”

I've literally looked all over Stack Overflow, Superuser, I cannot find a solution to my problem that I'm experiencing right now, when I want to start MySQL, it produces this error: ERROR! The ...
0
votes
0answers
17 views

organising books via browser

I'm looking for something similar to I, Librarian. Essentially it creates a database for pdfs, which you can access via your browser. I would like something more straightforward to install and, more ...
0
votes
0answers
212 views

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither ...
1
vote
1answer
1k views

Problems with apache after update of php and mysql using homebrew

I am hoping someone here can assist me. I upgraded php and related files using brew upgrade on my mac which is running Mac OS X 10.8.3. Everything was working fine before and I just wanted to update. ...
1
vote
1answer
3k views

How can I upgrade my MySQL 5.1 to MySQL 5.6, and migrate data

I previously installed MySQL 5.1 using the installer, since then created a number of users/databases, and now would like to upgrade to 5.6. What is the procedure to do so?
1
vote
0answers
193 views

MySQL server wont start

For some reason, MySQL won't start anymore. Suddenly happened out of the blue. This is what is written in /var/log/system.log right after I try to open MySQL. Feb 8 16:07:31 ...
0
votes
1answer
1k views

MAMP Pro failing to launch (mysql)

Issue: I try to launch MAMP Pro, enter my system password then it sits there trying to connect to MySQL. This has been running fine previously. Background: I'm running OSX v10.8.2 and Path Finder ...
0
votes
2answers
437 views

MySQL - Ruby on Rails mysql gem not working on snow leopard

i have installed mysql 5.5.11 and i'm running on Snow Leopard (10.6.7) when i create my rails application everything wokrs fine: rails fooTest -d mysql then cd fooTest then rake db:create and ...
1
vote
2answers
778 views

Cannot start MySQL server with AppleScript - Snow Leopard

I've sucessfully installed MySQL server (5.5.11) on my MAC Snow Leopard. I can start the server using PreferencePane, using command line sudo /usr/local/mysql/bin/mysqld_safe but cannot use the same ...
1
vote
1answer
287 views

starting mysql from the console and my.cnf

Is this possible to start mysql from the console. I tried with mysqld start but it fails to start, how to start it? I didn't find my.cnf in Mac, I wanted to change datadir settings, if there any ...
2
votes
2answers
1k views

Is the performance of Lion + SSD + Filevault2 good enough for a system primarily used for application developemnt?

I'm looking to buy a MacBook Pro w/ SSD. I was wondering if anyone out there has noticed any significant performance drop with FileVault2 enabled for the following tasks: Small (under 2 GB) ...
1
vote
2answers
3k views

Getting Perl DBD::mysql working on OS X 10.7?

I can't seem to get Perl & MySQL to talk to each other on OS X 10.7 Lion. I did all the installs by the book, I used Oracle's PKG installer for the latest MySQL Community Server, and I installed ...
0
votes
1answer
475 views

Install Apache, PHP and MySQL on Mac w/o MacPorts?

For some reason I can't use MacPorts. So the question is if it's possible to install Apache, PHP and MySQL on Snow Leopard w/o using MacPorts? Please don't offer MAMP or other bundles. Thanks in ...
0
votes
1answer
370 views

MySQL won't start on Snow Leopard

I'm getting this error while trying to start the mysql server $ sudo mysqld_safe --user=mysql 110425 23:11:33 mysqld_safe Logging to '/usr/local/mysql/data/unknown-e0-f8-47-0c-04-a0.lan.err'. 110425 ...
0
votes
1answer
330 views

Why do httpd and mysqld processes not show up in Activity Monitor?

I'm running Mountain Lions built in Apache2 server. I have started the server and I can see the web pages but I can't see any httpd process in the Activity Monitor. Same goes for MySQL. I can't see ...
1
vote
1answer
309 views

Connect to MySql over Airport Wireless LAN

I have installed MySql on a Mac Mini that I want to use as a dev database server. I have created a toy database on the server. I have created a wireless network using Airport. I now want to connect to ...
-2
votes
1answer
253 views

MySQL GUI Tools Recommendation

What is your recommendation for MySQL GUI Tools? I'm looking for software has interface similar to MySQL Workbench. Have tab query editor without reconnect to database Can easily add new row Can ...
0
votes
2answers
1k views

SQL-Coding App for iPad

I'm searching for an iPad App where i can write and proceed SQL Statements. I want to connect to my own Server. Are there any Apps out there? I can only find MySQL Apps which are offering ...
2
votes
1answer
7k views

How do I give mysqld write access to a directory?

I am running OSX right now and trying to run a mysqld process and seeing the following error: $ /usr/local/mysql/bin/mysqld --user=root 111026 11:05:08 [Warning] Can't create test file ...
2
votes
2answers
1k views

MySQL Preference Pane control for MySQL installed via Homebrew

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 through homebrew. How can I achieve this?
2
votes
2answers
1k views

Uninstall MySQL

I'm trying to get a working copy of MAMP. But I once installed the MySQL server seperately, and I can't find a way to uninstall. How can I uninstall this version of MySQL?