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

learn more… | top users | synonyms

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 ...
9
votes
3answers
2k views

Advantages of using MAMP stack over Mac's native Web Sharing and downloaded MySQL

I'm wondering what are the advantages of using a MAMP stack instead of Web Sharing provided with Mac natively and MySQL downloaded and installed manually? I can see how in some cases MAMP can have ...
7
votes
4answers
3k 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 ...
5
votes
3answers
5k 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 ...
4
votes
1answer
1k views

Stopping a macports installed mysql daemon

I'm trying to reset my root password on a macports installed MySQL on OS X. But none of the ways to do this that I can find works, for various reasons. One reason common to all is that I can't stop ...
4
votes
1answer
259 views

Is it possible to update the preinstalled versions of both MySQL and PHP in OS X?

I'm running 10.6.4 and PHP reports itself as version 5.3.2 (5.3.3 is available) and mySQL reports version 5.1.45 (5.1.51 is available) I know they are minor releases but is it possible to easily ...
3
votes
2answers
9k 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 ...
3
votes
1answer
9k 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
4answers
26k views

How to create new mysql user/db in Mac OS X?

Can any one please let me know how to create new user and new db in MySQL? How to use mysqladmin in Mac OS X?
2
votes
2answers
601 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. ...
2
votes
2answers
210 views

Why does OS X's Apache server give different results using real and virtual addresses?

I'm developing a WordPress site on my Mac, running OS X 10.6.4. I'm using OS X's built-in Apache server to run the site locally during development. I've set up WordPress and connected it to OS X's ...
2
votes
2answers
259 views

Will Lion install MySQL with it?

I had MAMP running on my laptop. I use MySQL a lot. I kinda messed with the user file permission and I fixed it , in that process I changed some password in MySQL config files. So now SQL does not ...
2
votes
2answers
2k 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
4answers
2k views

phpMyAdmin 403 Forbidden Error after upgrade to Yosemite

I upgraded my Mac to Mac OS X Yosemite. I had a AMP stack installed via Homebrew on Mavericks and it worked fine. After upgrading to Yosemite, I have the following problems: when trying to load ...
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?
2
votes
1answer
416 views

Mac OS X Lion Server and Macports - Can they work together?

I've been using macports for my MAMP projects for quite some time, but I don't think that the command line server management for Apache and MySQL Server, both from macports, is the best way to do it. ...
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) ...
2
votes
1answer
343 views

how can i set up mamp or web sharing to show clients php application remotely?

I'm currently using mamp instead of web sharing and I'm trying to figure out the best approach to share php and mysql web application that I'm working on to clients. What is the best way to do this?
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 ...
1
vote
1answer
2k 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
2answers
4k 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 ...
1
vote
1answer
6k 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
1answer
41 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 ...
1
vote
2answers
8k 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
1answer
698 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
2answers
790 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 ...
1
vote
2answers
112 views

Where can I find a list of MAMPs?

I'm looking for a MAMP packaging = Apache + MySQL + PHP bundled together for Mac OS X (which is my OS). Where can I find it? Is there an "official" site where I can download it from? [ I know that ...
1
vote
2answers
3k views

How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on Mac OS X 10.7?

I'm running Mac OS X 10.7. How can I know whether MySQL, SQLite, PostgreSQL, etc. are installed on the system?
1
vote
2answers
869 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
2answers
2k views

How to get in to mysql prompt in mac os x

I have installed mysql in mac os x (10.6.6). How ever I dont know how to get in to mysql prompt (newbie). Sarbbottam-Bandyopadhyays-MacBook-Pro:bin sarbbottam$ pwd /usr/local/mysql/bin ...
1
vote
1answer
82 views

Finding mysql username and password

I have used the binary installer on my mac and use the following to start mysql. sudo /Library/StartupItems/MySQLCOM/MySQLCOM start It seems to start ok, but i haven't set up any passwords for users ...
1
vote
1answer
109 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 ...
1
vote
1answer
419 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 ...
1
vote
1answer
304 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 ...
1
vote
3answers
827 views

Installation failed when attempting to reinstall MySQL in OS X 10.6.6

I had earlier installed mysql-5.1.50-osx10.6-x86_64.dmg and then uninstalled it using the below command (found on Stack Overflow): $ sudo rm /usr/local/mysql $ sudo rm -rf /usr/local/mysql* $ ...
1
vote
1answer
415 views

MySQL fails to start at restart after Yosemite update

I have MySQL installed. When I had the previous version, it used to start after boot automatically. This is not the case after I updated to Yosemite. In System Preferences there is an icon for MySQL ...
1
vote
1answer
615 views

MySQL server (MariaDB) cannot start

I'm trying to start MySQL server (Maria DB 10.0.12, installed via Homebrew) but it's not working. When I run mysql.server start, it keeps running forever without actually starting the server. ...
1
vote
0answers
14 views

Mysql Workbench Model table height issue

having a weird issue with the model editor in mysql workbench. All the table name height are far too big. Its making working with the editor completely impossible. I've search and googled and can't ...
1
vote
0answers
137 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 ...
1
vote
0answers
88 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 ...
1
vote
0answers
93 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 ...
1
vote
0answers
233 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
2answers
8k 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"
0
votes
2answers
175 views

Where is MySQL installed for the included Apache server?

I'm trying to set up Web Sharing... phpinfo() shows MySQL is installed, but I can't find it. Terminal says "command not found" when I try mysql. I have no idea what I'm doing, or even if this ...
0
votes
1answer
419 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 ...
0
votes
1answer
1k views

mysql.sock gets deleted on restart

I have set up PHP and MySQL, however MySQL wants the mysql.sock file in /var/mysql, which is fair enough. I change the directory to /var/mysql however every time I restart my computer mysql.sock gets ...
0
votes
1answer
2k views

[MySQL Server] MySQL Workbench can't find my.cnf on (clean installation of) Snow Leopard

I have a clean installation of Snow Leopard on a MacBook and I want to get a MySQL Server running on it. I downloaded and installed the .dmg file provided by the homepage of MySQL and installed it. I ...
0
votes
1answer
286 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
502 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 ...
0
votes
1answer
496 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 ...