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 ...
11
votes
3answers
3k 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 ...
8
votes
4answers
9k 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
5answers
18k views

How to add MySQL to $PATH variable to resolve “mysql: command not found”?

I installed MySQL on my Mac, and now I would like to add it to my $PATH variable. I want to be able to type mysql anywhere. I tried adding the following to my .profile file: export PATH=${PATH}/usr/...
5
votes
2answers
8k views

Howto install 'MySQL Utilities' using brew or brew cask

I installed MySQL server and client using brew. I installed MySQL Workbench with brew cask. But I don't find MySQL Utilities (something new?). Howto install that using brew or brew cask? https://dev....
5
votes
1answer
2k 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 ...
5
votes
3answers
6k 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
4answers
6k 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 ...
4
votes
1answer
298 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 ...
4
votes
1answer
316 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 ...
3
votes
4answers
54k 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?
3
votes
2answers
608 views

Starting and stopping mysql server. Shorten and make automatic

Currently I start and stop mysql with the following command sudo /usr/local/mysql/support-files/mysql.server start sudo /usr/local/mysql/support-files/mysql.server stop It is quite a long ...
3
votes
1answer
12k 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?
3
votes
1answer
485 views

MySQL Preference Pane is specifying a port number when it runs mysqld

As it says above. When I run mysqld using the preference pane for MySql, one of the arguments it is providing is --port=3307. Does anyone know how I might go about changing this? Operating System is ...
3
votes
1answer
14k 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 /usr/local/...
3
votes
2answers
4k 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?
3
votes
3answers
16k 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
358 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?
3
votes
3answers
5k 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 ...
2
votes
2answers
25k 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"
2
votes
3answers
5k 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 ...
2
votes
4answers
2k 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
4answers
6k views

How to Properly Install MySQL Server onto OS X 10.10 Running OS X Server

I have seen numerous suggestions about using MAMP to install MySQL on OS X, but since I have the Server app and already have Apache and PHP, which I do not wish to mess up, I wonder how to properly ...
2
votes
2answers
227 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
120 views

Remove mysql 5.6.26-community

I installed this version of mysql with the script here, but I don't know how to remove it. It isn't in the applications folder. It's here: I wish if someone could tell me how to completely remove ...
2
votes
1answer
1k 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 com....
2
votes
2answers
2k 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
2answers
262 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
1answer
443 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) ...
1
vote
2answers
155 views

How do I install and run MySQL?

I installed MySQL: but MySQL certainly isn't on the path when I open a terminal, nor do I see it in applications, as I seem to recall Windows handles MySQL.
1
vote
1answer
5k 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
177 views

Why can't I execute mysql without the full path? [duplicate]

At my terminal, I can't cd to the folder containing mysql and call it. TimsMacBookAir:/ tim$ cd /Applications/MAMP/Library/bin/ TimsMacBookAir:bin tim$ mysql -bash: mysql: command not found If I ...
1
vote
3answers
3k 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
131 views

Trouble running MySQL on OS X 10.9.5

So I ran over a lot of post treating of this specific problem but none of the answer seems to work for my case. So this is the process : I installed mysql via homebrew that lead me to this : ...
1
vote
1answer
64 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
1k 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
123 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
1k 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
73 views

mysql fails to load on boot

I have a Macbook. Forever I’ve had mysql server installed and running on start (using El Capitan). Well now I’ve installed Wine. Since then mysql server fails to start on reboot. If I manually run ./...
1
vote
1answer
61 views

Script of mysqldump didn't work correct invoked by launchctl in OS X

Here is my question asked on StackExchange 2 days ago. http://stackoverflow.com/q/35839190/4772652 Someone suggested me to ask here. Could anyone give me a hand to solve this? ============ I had ...
1
vote
2answers
409 views

Visual MySQL compare tool for Mac

Is there any Mac app that can visually compare data like SQLyog's Visual Data Compare? One where you can literally select the rows to copy over and which not? Any recommendations appreciated. :)
1
vote
1answer
142 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
232 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
629 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
510 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
2answers
6k views

How to use the mysql I just installed?

I have installed mysql in Mac OS X 10.6.6. However I don't know how to get to the mysql prompt. Sarbbottam-Bandyopadhyays-MacBook-Pro:bin sarbbottam$ pwd /usr/local/mysql/bin Sarbbottam-...
1
vote
3answers
1k 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
2answers
118 views

Upgrade to El Capitan has broken MySQL and Apache

Due to unforeseen circumstances, I was forced to upgrade to OS X 10.11 (El Capitan). Here, the process I followed was to: install Yosemite onto an external hard drive; migrate data from MacBook Pro ...
1
vote
0answers
26 views

Getting error 403 on trying to activate PHP and Apache on Mac Pro

I followed the steps given in the following site to activate PHP and Apache on my Mac Pro: Get Apache, MySQL, PHP and phpMyAdmin working on OSX 10.10 Yosemite This is the screenshot of my terminal ...