Hot answers tagged

11

I'd say unified GUI integration. With MAMP, you've got a single window to manage Apache, PHP, and MySQL. Whereas with the built-in stack, you have to active PHP manually and have another interface for MySQL (with no easy way to turn it on or off)


7

Open terminal, then: sudo launchctl list | grep -i mysql launchctl remove xxx.xxx.mysql Where "xxx.xxx" is included in the output of the first command, for example "org.macports.mysql". The password for the "sudo" command is your own user account's password. True, sudo isn't needed to "list" but because you already gave a sudo password for the first ...


7

Here is why your current code is not working: export PATH=${PATH}/usr/local/mysql/bin/ You forgot the colon. export PATH=${PATH}:/usr/local/mysql/bin/ is the correct code.


6

The following assume your MySQL 5.1 is installed in /usr/local/mysql-5.1.46-osx10.6-x86_64 and that MySQL 5.6 will install in /usr/local/mysql-5.6.11-osx10.7-x86_64. The exact directory names might differ depending on the exact version number you are using. Download the MySQL 5.6 installer, for instance in DMG format, and run ...


6

This will do it: brew tap caskroom/cask brew install brew-cask brew cask install mysqlworkbench


6

If you are using the terminal client, generally you can do things like reset the root users password for mysql or create databases. A simple example can be found at the MySQL docs site, of which I will copy the highlights. To create a new MySQL user: Login to MySQL in Terminal:mysql -u username In the prompt:CREATE USER 'admin'@'localhost'; GRANT ALL ...


6

The disadvantage is that you're installing stuff that you already have installed. This can cause problems when - for example - you want to use PHP using the command-line. This will trigger the built-in PHP version by default instead of the one bundled with MAMP. If these are different the results can be unexpected. I would recommend using the default OSX ...


5

OK, so I found the culprit. It is amazing that no error message was visible in console or in the error logs, but I found a site which helped me a lot. http://blog.joshdick.net/2012/07/28/troubleshooting_apache_in_os_x_10.8_mountain_lion.html In that post, the author, Josh, suggested restarting apache using the following command: sudo bash -x ...


5

The correct answer is sudo launchctl unload -w /Library/LaunchDaemons/org.macports.mysql5.plist And you start it with sudo launchctl load -w /Library/LaunchDaemons/org.macports.mysql5.plist Thanks to kh13org for the pointer.


5

Actually, the #1 advantage to using MAMP is tremendous: Each time you upgrade your system, your environment won't break! There were a couple of Snow Leopard updates (or maybe it was Leopard to Snow Leopard, I can't remember) that broke Mysql. One was by moving the mysql.socket file. There was another update the broke PHP. In both cases I had to hunt around ...


5

MySQL is not installed by default, even though the included PHP is compiled with MySQL support. Check out this guide for MySQL installation.


5

There is no way to make Numbers get data from a database. (It's more of a consumer tool.) https://discussions.apple.com/thread/1827581 A workaround: you can use Excel to grab the data, and import the XLS file to Numbers for prettier chart-making.


5

export PATH="/usr/local/mysql/bin:$PATH" in .bashrc or .bash_profile file (cd ~/.bash_profile) This will tell your terminal where to find mysql command.


5

My favourite way to install and run MySQL is via the Homebrew package manager. With Homebrew installed it's as straightforward as: brew install mysql This gets you the server and the command line connection tool. It's setup to run with no password, so it's not suitable for production use, but it's perfect for developing with. Homebrew takes care of ...


5

Try adding the following line to your .bash_profile file. export PATH="/usr/local/mysql/bin:$PATH" You can do this easily with the following command, which will append the line if the file already exists or create a new file with the line if it doesn't. echo 'export PATH="/usr/local/mysql/bin:$PATH"' >> ~/.bash_profile


5

You may change the port in the file com.oracle.oss.mysql.mysqld.plist file in /Library/LaunchDaemons by editing it with sudo nano /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist Change the port at <string>--port=3307</string> near the end of the file to whatever you need it to be and reboot your Mac or restart the service.


4

Just create an alias in your ~/.bash_profile or ~/.profile file. Check with ls -la0 ~/ if one of the files already exist, else create one with: touch ~/.bash_profile After opening .bash_profile with nano ~/.bash_profile add the lines: alias iwanttostartmysqlwithareallyshortcommand='sudo /usr/local/mysql/support-files/mysql.server start' alias ...


4

I like the alias answer. This is another route I found whilst looking. sudo ln -s /usr/local/mysql/support-files/mysql.server /usr/bin/mysql.server can now stop and start with sudo mysql.server start sudo mysql.server stop


4

In Activity Monitor there is a dropdown menu in the top of the window. My Processes was selected. Changing it to All Processes solved the issue.


3

It is not ridiculous at all. I'd assume that, seeing you're coming from a Windows environment, you simply don't understand Unix sockets. An Unix socket file is created when mysqld is started up, and mysql.sock is that file. It is a faster alternative to TCP/IP for use on a local system. So yeah, it is actually totally normal that the file is deleted when ...


3

Depending on the uid mysqld is using, chmod 700 on the data directory might not help. You may do the following: chmod 777 /usr/local/mysql-5.5.15-osx10.6-x86_64/data/ Startup mysqld again ls -l /usr/local/mysql-5.5.15-osx10.6-x86_64/data/ to identify the owner of the created files chown OWNER /usr/local/mysql-5.5.15-osx10.6-x86_64/data chmod 700 ...


3

Feel free to copy one of the example files into the /etc directory or make your own. You won't have any problems until you ever want to have more than one version of mysql installed and running - then you can set up shell variables to keep things apart - but for the short run - one file in one place would be good. So let the Workbench make /etc/my.cnf and ...


3

Briefly; no there is no easy way to update them. (Assuming that compiling from source is not considered easy) I would strongly caution against modifying the system installed versions as you're likely to have your updated versions broken when Apple issues an update that updates them. (Usually Security Updates and has bitten some users/sysadmins when Perl has ...


3

You can use a GUI client, like Sequel Pro.


3

I had the same symptoms, but a different problem: perl, by default, runs as 64bit executable, but my mysql installation and hence all its libraries are 32bit only. Forcing perl to run in 32bit mode solved it: defaults write com.apple.versioner.perl Prefer-32-Bit -bool yes


3

The answer to this superuser question and this stackoverflow question both say approximately the same thing, that you need to perform the following actions: If you haven't yet rebooted your computer, the process could still be running. First, reboot. Then if MySQL is still showing up after a reboot, from the Terminal, issue the following ...


3

The log says it all: The script cannot write to the file /usr/local/var/mysql/xxx.local.err due to insufficient permissions. I assume the log file belongs to a dedicated mysql user while you are starting the process using your user account.


3

YES. Following homebrew caveats, did you setup launchd? To have launchd start mysql at login: ln -sfv /usr/local/opt/mysql/*.plist ~/Library/LaunchAgents Then to load mysql now: launchctl load ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist Well, now using mysql.server is pointless. It basically doesn't work, because (from my poor understanding) ...


3

Since upgrade to Yosemite updated your Apache, you have to update phpMyAdmin.conf to use new Access control syntax. Have a look at: http://httpd.apache.org/docs/2.4/upgrading.html In my case I need changed /etc/apache2/other/phpMyAdmin.conf Order allow,deny Allow from all to Require all granted More info here: ...



Only top voted, non community-wiki answers of a minimum length are eligible