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

learn more… | top users | synonyms

3
votes
2answers
3k 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
27 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
1answer
1k 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. ...
0
votes
0answers
11 views

What is the default encryption in MySql on OSX?

I can't seem to see anywhere what the default encryption method used is with MySQL on my Mac. I'm encoding passwords in MD5 by hand then putting them into the database, which I'm told is obsolete. ...
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?
0
votes
1answer
39 views

Mac Ports fails to install mysql5

I am trying to install mysql via mac ports and having no luck: /sites $ sudo port install mysql5 Password: ---> Computing dependencies for mysql5 ---> Building mysql5 Error: ...
0
votes
0answers
8 views

Change MySQL Norton-Firewall Settings

When I was enabling MySQL on Mac and I was prompted by Norton with a message saying if I wanted to Allow any computer to connect, local computers, or keep firewall settings. I would like to edit ...
3
votes
3answers
11k 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 ...
1
vote
0answers
53 views

Fatal: Unknown scheme: SHA512-CRYPT - is This mac related?

You can see from the output of the samples shows in the first case, that SHA512-CRYPT seems to be Unknown. The code I used is from a Linux based tutorial on setting up Postfix+Dovecot+MySQL on a site. ...
1
vote
4answers
13k 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 ...
0
votes
0answers
184 views

MySQL no longer starts uninstall/reinstall doesn't seem to work

I had MySQL installed via the MySQL installer and it was working great. I managed to corrupt the database somehow and it wouldn't start up anymore. I didn't have any data I needed so I figured I'd ...
0
votes
1answer
41 views

Joomla not working on Localhost:8000

I was migrating a Joomla site to a new server. Before uploading to the new server, I wished to test it on my localhost php server. I have done this with Wordpress sites and other PHP/MySQL things with ...
2
votes
3answers
477 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 ...
1
vote
2answers
61 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.
0
votes
1answer
53 views

mysql: command not found [duplicate]

How do I use MySQL from the CLI? When I use the terminal, I get: Darrens-MacBook-Pro:~ thufir$ Darrens-MacBook-Pro:~ thufir$ mysql -bash: mysql: command not found Darrens-MacBook-Pro:~ thufir$ ...
0
votes
0answers
58 views

To use MySQL, system preferences must quit and reopen, and quit and reopen

How do I just get the MySQL Admin GUI to run: then: final loop: I can't seem to get out of whatever sort of infinite loop is in there.
0
votes
1answer
276 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
2answers
178 views

How to run a sudo command on mac? .. problem with mysql server

I 've installed mysql server with brew, and i need to run manually this command each time my computer start to make it work with an application that I can't edit. sudo mkdir -p -- /var/run/mysqld/ ; ...
1
vote
3answers
1k 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 ...
0
votes
1answer
144 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. :)
4
votes
4answers
4k 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 ...
0
votes
0answers
82 views

Problem with PATH after installing MySQL

I'm looking for help concerning a problem with my Terminal. After some researches on differents websites, forums, I'm not the first one in that case, but all the solutions I've tried sofar did not ...
0
votes
0answers
395 views

Borked my XAMPP upgrade after Yosemite, what now?

I had XAMPP running on Mavericks without a problem. Then unfortunately decided to upgrade to Yosemite (not a beta version, the final public version). As others have reported, MySQL stopped ...
1
vote
2answers
993 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
0answers
373 views

MAMP mysqld osx firewall / allow incoming connections

I'd like to make an exception to the osx firewall so that I don't have to specifically give access to mysqld every time I launch mamp. OSX throws the dialogue "Do you want the application “mysqld” ...
1
vote
1answer
3k 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
2k 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? ...
1
vote
3answers
879 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
0answers
24 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 ...
0
votes
1answer
39 views

Why do I need to type ./mysql even that I am in the folder? [duplicate]

So I am in a folder where mysql executable already is.. When I try mysql in terminal I get: -bash: mysql: command not found But this will work: Korays-MacBook-Pro:bin koraytugay$ ./mysql Welcome to ...
0
votes
1answer
88 views

How to create an alias for IP address for JDBC connection?

I have the “db” alias in my JDBC connection specified in the Java properties file for MYSQL. This alias does not currently work on my local computer. I would like not to change the properties file ...
1
vote
1answer
109 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 ...
0
votes
1answer
237 views

Do i need the 32 bit or 64 bit version of Mysql for use with php 5.5

First time Mac user, I am just about to download MySQL for Mac, which version do I need for use with PHP 5.5? Apologies if this is a really simple question. Thanks
0
votes
1answer
23 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
49 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 ...
0
votes
0answers
65 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
256 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 ...
2
votes
0answers
215 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
1answer
619 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
113 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
13k 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
2answers
1k 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
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 ...
8
votes
4answers
6k 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 ...
1
vote
0answers
112 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
377 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
1k 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
503 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
360 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 ...