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

learn more… | top users | synonyms

1
vote
1answer
19 views

Cannot execute this binary file

appreciate any assistance, I'm a Mac Noob Im trying to upgrade MySQL in MAMP to 5.6 according to the these instructions When I try to run the .command script as per #2 I get the following output: ...
0
votes
0answers
22 views

Help fix my xampp/mamp/mysql installation

I've installed xampp,mamp on my iMacbook air running OSx 10. At first they seem both running well, but several months later, there are a lot of problems going on and they seem interwined. I can't ...
0
votes
0answers
28 views

mysql / phpmyadmin connection problem on mac yosemite

iam new on mac os, i find many thing that i want, but now have a problem around using mysql and phpmyadmin, i work as bellow Setup/Configure mysql: brew install mysql brew info mysql launchctl ...
0
votes
1answer
46 views

Does MAMP installation create conflicts with standalone MySql?

I have just installed MAMP. And I have just now realized that I already have a MySQL server and a database that runs under it. Do I now have two MySQL servers? Will they interfere with each other (and ...
1
vote
2answers
143 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
1answer
144 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 : ...
0
votes
1answer
291 views

MySQL fails to start after update

I am on Yosemite 10.10.5 and just now I updated my outdated MySQL to the latest version. I made a copy of my existing databases /usr/local/mysql/data/ somewhere safe. I have tried to setup MySQL both ...
1
vote
1answer
97 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
71 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 ...
0
votes
1answer
219 views

How could I remove mysql from manually installation version

I manually installed the MySQL without homebrew However, I still installed another mysql server by homebrew. which mysql /usr/local/bin/mysql How could I remove the manual installed mysql server, ...
0
votes
2answers
159 views

localhost loads default apache page

I'm setting up a localhost and everything looks like it should work but whenever I go to site.local it loads the default Apache localhost page (It works!). Here's a copy of my hosts file: ## ## # ...
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 ...
0
votes
1answer
56 views

Unable to install with admin

I am trying to update MAMP MySQL from this link, but when i double click the file as mentioned in the blog. I get message saying, The file “Install_MySQL_5.6.25.command” could not be executed ...
0
votes
1answer
180 views

How to get started with MySQL on Mac

I'm all very new to mySQL. I've installed it from the Oracle website, and I think I managed to run the server with the command: sudo ./mysqld_safe --console But it's impossible to open the client ...
0
votes
0answers
105 views

After removing mysql, when I execute mysql my prompt changes?

I am not sure why this is happening. I made a mistake and I installed mysql with brew, then I forgot and I installed again but with the dmg package. Then I wanted to remove completely both and make ...
0
votes
2answers
89 views

MAMP PRO uninstalled but Terminal commands still exist. How to remove them as well?

Source: To "uninstall" MAMP, you only have to delete the MAMP directory and everything returns to the original state I uninstalled MAMP using the Uninstaller from Applications/MAMP PRO. I ...
1
vote
1answer
799 views

How to start auto start mysql? Getting “Path had bad ownership/permissions”

How can I auto start mysqld I tried following http://stackoverflow.com/q/26476391/631619 but it didn't help It seems like I have a ownership/permission problem, possibly related to from having ...
2
votes
2answers
122 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 ...
0
votes
0answers
171 views

How to clean out mysql instances

OSX 10.10, Macbook Pro. I can't connect to mysql database: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) When I view Activity Monitor I have two ...
1
vote
0answers
189 views

Problem loading php56 instead of php5 under MacPorts

I am running MacOS X Mavericks, where I manually created a MAMP stack by installing mysql5-server, php5, etc., under MacPorts. I was recently forced to upgrade this configuration to mysql56-server ...
0
votes
0answers
22 views

Permissions sharing between MySQL and myself in Yosemite

I would like to have full access (read/write) on everything in the MySQL data directory (/usr/local/mysql/data). Then an application running as "me" could create/edit/delete every data. I tried to ...
3
votes
2answers
663 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
502 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 ...
0
votes
0answers
302 views

OSX Homebrew MySQL Installation Gone Bad

I'm having issues with getting mysql installed properly under homebrew. I want homebrew to manage it, and I had it installed manually using the .dmg installer beforehand. I've backed up my data into ...
2
votes
4answers
7k 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 ...
0
votes
1answer
537 views

403 forbidden on Apache vHost

I'm using Mac OS X 10.6.8 and I'm trying to configure a vHost. I configured it and it gave me a 403 Forbidden, and I'm having trouble giving _www permission to read/write in ~/Document/workspace/dev ...
1
vote
1answer
187 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 ...
0
votes
1answer
222 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: org.macports....
1
vote
0answers
193 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. ...
0
votes
0answers
669 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
204 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 ...
0
votes
1answer
2k 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
159 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.
1
vote
2answers
162 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.
6
votes
5answers
20k 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/...
0
votes
2answers
377 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
2answers
419 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
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 ...
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 ...
1
vote
2answers
3k 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. mysql....
1
vote
1answer
37 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
47 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
308 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 ...
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....
1
vote
1answer
145 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
456 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
29 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
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 ...
0
votes
0answers
85 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 ...
4
votes
1answer
324 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 ...