Questions tagged [mysql]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
180 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 ...
2
votes
2answers
36k 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
2answers
657 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 checked ...
2
votes
1answer
2k views

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

How can I auto start mysqld I tried following https://stackoverflow.com/q/26476391/631619 but it didn't help It seems like I have a ownership/permission problem, possibly related to from having ...
3
votes
2answers
292 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 it. ...
4
votes
2answers
2k 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 command ...
3
votes
1answer
935 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 ...
2
votes
4answers
11k 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
1k 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
599 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
502 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
451 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
1answer
374 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 ...
1
vote
1answer
14k 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$ As ...
1
vote
2answers
521 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.
27
votes
6answers
94k 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
765 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
2k 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
7k 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
4k 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
51 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
49 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
618 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 ...
9
votes
2answers
27k views

How to 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?). How to install that using brew or brew cask?
1
vote
1answer
194 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
573 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
35 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
76 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 ...
4
votes
1answer
573 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
1k 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 ...
2
votes
0answers
179 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
4answers
554 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 ...
3
votes
4answers
5k 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. ...
9
votes
5answers
17k 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
1answer
531 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 ...
3
votes
9answers
45k 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
1answer
405 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
1answer
1k 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 /...
3
votes
2answers
30k 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"
3
votes
1answer
2k 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....
1
vote
1answer
359 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
1answer
8k 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. ...
3
votes
2answers
17k 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?
0
votes
1answer
2k 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 ...
1
vote
1answer
319 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 mys-MacBook-Air....
1
vote
2answers
3k views

Can not successfully re-install MYSQL 10.8.2

Removed the old installation as explained here: https://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 ...
3
votes
3answers
9k 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
1answer
584 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 ...
1
vote
1answer
1k 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 ...