0
votes
1answer
13 views

How to get access to MAMP mysqldata base when 1045 access denied error is posed?

Been stuck for a few days now. I've been SCOURING google for solutions and have tried many things. Basically I was editing my users in phpMyadmin and I think I erased the user 'root' which is my ...
0
votes
1answer
57 views

Mysql server won't start after Mavericks upgrade

I am unable to start MySQL server after upgrading from OSX 10.8.5 to 10.9.3 prompt: sudo ./support-files/mysql.server restart ERROR! MySQL server PID file could not be found! ...
0
votes
2answers
73 views

Command-line access to remote MySQL server

I administer a website on a remote, shared host. My web host offers MySQL, and I am able to access this from my Mac OS X computer using a GUI program, Sequel Pro. That works great. But I want to ...
0
votes
1answer
46 views

Launch a daemon after another daemon on Mac OS X

How one would create a dependency between two daemons launched on system start? I would like to launch sonar when the system starts but it requires mysql server to be already up and running. I ...
0
votes
0answers
221 views

I have a MySQL 5.6.17 server on OSX 10.9.2 that “sometimes starts”, and most of the time don't

I have setup a MySQL 5.6.17 server on my Mac OSX 10.9 to run some demo (I usually do not attempt MySQL and Apache things on a Mac), using Homebrew. Everything went just fine (apart usual stinky parts ...
0
votes
1answer
21 views

Where can I download the MySQL prefpane source code for Mac OS X

I have been poking around for a while and I have been unable to find the source code for the MySQL prefPane for Mac. I found this for PosgreSQL https://github.com/jwang/pgpane which is helpful but ...
0
votes
1answer
85 views

Error starting MySQL server through commandline on Mac OS X 10.9

I am installing MySQL manually on my Mac and during that I started MySQL through command line using this command $ /usr/local/mysql/support-files/mysql.server start Starting MySQL . ...
0
votes
1answer
99 views

MySQL does not work on MacBook Pro after restoring from Time Machine

I just used Time Machine to restore my hard drive. However I am not able to connect to MySQL. I get the following error when I type mysql -u root -p. ERROR 2002 (HY000): Can't connect to local ...
1
vote
0answers
81 views

resolving host names from parallels (windows) to Mac (mavericks)

I was given a macbook for work that is running mavericks. We also do windows development. I'm currently running windows 8.1. I set up mysql on the mac side that both the windows 8.1 running on ...
0
votes
1answer
46 views

Allowing any MAC admin user to run MySQL server on startup

I recently installed MAMP on our server in order to launch a Wordpress site. Though everything is working fine I am not the computer's main user, something which results in long downtime when it has ...
2
votes
3answers
268 views

MySQL Workbench equivalent for OS X

Is there any equivalent of MySQL Workbench for OS X? The current version is very slow and hangs up even with 8GB RAM.
1
vote
1answer
3k views

OSX Mavericks: MySQL homebrew after native install

I recently upgraded my iMac to Mavericks, and I realized I needed to reinstall MySQL. I installed the native DMG version and it was working well, and I should have left it there. But I neglected it ...
0
votes
1answer
158 views

Double MySQL Running on Mountain Lion

After I've done a full restart, my Apache PHP server doesn't connect to Local MySQL ( connecting via 127.0.0.1 because localhost for some reason fails always ). So I did this today: ➜ ~ mysqladmin ...
0
votes
0answers
25 views

Alert for MySQL jobs

This might be either a simple or exceedingly complex question and searching has produced no results. I use Sequel Pro on OSX to run a lot of queries some of which can take, e.g. >8 hours. A lot of ...
1
vote
0answers
57 views

Define default column sort order in Sequel Pro?

I am using Sequel Pro 1.0.2 on Mac OS X. In the 'content' view of a table, I can click a column header to sort by that column. This always sorts the column in an ascending order. I would like to ...
2
votes
1answer
2k views

Mysql 5.6 server via MacPorts won't start

I've been happily using MacPorts' mysql5 and mysql5-server. Now it's time to upgrade. I followed standard procedure, but the server won't start. sudo port unload mysql5 sudo port install mysql56 ...
0
votes
0answers
58 views

symlinks keep breaking and creating self-referential loops

I'm using a new 27" iMac with Mountain Lion 10.8.4, mostly for database work and scientific computing. I've noticed some strange behavior, in which symbolic links to directories will break such that ...
1
vote
2answers
92 views

MySQL cannot recognize variable on file option

I'm using MySQL 5.6 on Mac OS X 10.8 and trying to configure mysql to log genreral_log into a file. However, it always throws an error when I start it. Here is the .my.cnf file looks like (located at ...
1
vote
1answer
445 views

Connecting mysql via 127.0.0.1 instead of localhost

I connected mysql on Mac OS X using this command: mysql -u root -p -h 127.0.0.1 After I logged in, I fired up this command: select user(); and it showed: root@localhost and even wired, I ...
0
votes
1answer
719 views

What does this line do? [export DYLD_LIBRARY_PATH=”$DYLD_LIBRARY_PATH:/usr/local/mysql/lib/]

I'm trying to get MySQL-python working on my mac. I have to put this line in the terminal to fix an error, specifically "_mysql.so image not found". The source of this line tells me I should put it in ...
0
votes
1answer
486 views

Homebrew MySQL error: ERROR 1018 (HY000): Can't read dir of '.' (errno: 13)

I have installed MySQL using Homebrew on my Snow Leopard Mac OS 10.6. I have run through the commands that it mentions: unset TMPDIR mysql_install_db --verbose --user=`whoami` --basedir="$(brew ...
1
vote
1answer
22 views

How to get mysql running for real. basics

In connection with the question at: Where is MYSQL installed on Mac? I have a question too. The widget in the startup item says mysql is running and I can use it to stop it, apparently. But the ...
0
votes
2answers
367 views

Can I create a socket file on mac?

I am missing /tmp/mysql.sock. It has signature srwxrwxrwx. Is it possible to create this file by hand?
0
votes
1answer
239 views

Mac 10.8: Cannot Run MySql

I previously had mysql running on my machine. I had to wipe my machine clean yesterday, for an unrelated reason. After I reinstalled mysql today, I received the error -bash: mysql: command not found ...
1
vote
3answers
3k views

OSX 10.8.2 Wiki Server file and database locations?

OSX 10.8.2 with the Server.app installed. Wiki server running. where do these files live? (so that I can customize the CSS as well as back everything up.) What databases so I need to backup and ...
1
vote
0answers
279 views

Repeating mysql error in OSX console

I'm getting an endlessly repeating set of errors in my mac's console that go as follows: Jan 6 00:21:37 Air com.apple.launchd[1] (com.mysql.mysqld): Throttling respawn: Will start in 9 seconds Jan ...
1
vote
2answers
442 views

Remove one of the two instances of MySQL?

Objective I want to get rid of one of the two instances of MySQL on my iMac. History A while back I installed one just to play around with it - but then I ended up installing a MAMP stack so that I ...
1
vote
2answers
309 views

using virtual machine like mySql server

i'm developing a java program and i need a database. Now i'm using MAMP and it's pretty easy but i would have a virtual machine (ubuntu server) and i need to connect my java program with this virtual ...
1
vote
0answers
24 views

symlink file error [duplicate]

Possible Duplicate: Symlink error when installing MySQL via Homebrew Similar to this question but have problems still trying to solve the issue. I am trying to install mySQL and it keeps ...
0
votes
2answers
523 views

MySQL server [Version 5.0.96] installation fails on Mac Mountain Lion

MySQL Installation fails when installing it on Mac os Mountain Lion. I don't why this simple installation fails. The file that I am trying to install is mysql-5.0.96-osx10.5-x86.dmg.
0
votes
1answer
126 views

Adding MySQL to PATH in OS X

I'm was trying to change the path for mysql so I can merely call mysql in Terminal to start working with my databases. However, although I edited my ~/.profile and inserted ...
0
votes
2answers
1k views

Enable remote access for MySQL on OS X

I need enable the remote access for mysql on my Mac (OS X 10.8). I installed MySQL from the .dmg downloaded from the MySQL website (So no MAMP). I works great on localhost, now how do I enable ...
0
votes
1answer
2k views

How to access MySQL with Sequel Pro on Mac OSx?

So I am having an issue with trying to figure out how to connect to MySQL to create/edit a database using Sequel Pro on Mac OSX Lion. I downloaded and installed MySQl from here: ...
0
votes
1answer
402 views

Is there a MAMP-like application with up-to-date components (Apache, MySQL and PHP)?

I'm using PHP and MySQL to develop websites and web applications on my Mac. Using Git and a deployment service I deploy the code to the production environment. I'm looking for a MAMP-like application ...
2
votes
2answers
2k views

$PATH issues with OSX Lion

I'm having some issues with running mysql from terminal: macmini:~ michael$ which mysql /Applications/XAMPP/xamppfiles/bin/mysql macmini:~ michael$ mysql -bash: /usr/local/mysql/bin/mysql: No such ...
11
votes
2answers
5k views

Symlink error when installing MySQL via Homebrew

Trying to install MySQL via Homebrew. The install seems to work fine but i get an error: "Error: The linking step did not complete successfully The formula built, but is not symlinked into /usr/local ...
0
votes
1answer
3k views

Can't start MySQL server on OSX

I just installed MySQL Server and Startup tools from the DMG at the MySQL site on an OSX 10.6.6. I restarted the computer, but it seems it can't connect to its socket. $ /usr/local/mysql/bin/mysql ...
1
vote
1answer
517 views

Apache can't load dbi module in mac os x

I installed dbd:mysql via cpan. I have the following simple script: #!/usr/bin/perl -U use DBI; $ds = 'DBI:mysql:project:localhost'; $user = 'root'; $password = '123456'; $db = DBI->connect($ds, ...
0
votes
0answers
452 views

how to install Mysql & tomcat on mac os x 10.5.8

Hi can some one provide me how to install both om my mac osx 10.5.8 Hi can some one provide me how to install both om my mac osx 10.5.8 Ok this what I have done Downloaded MySQL version 5.5.22.dmg ...
0
votes
1answer
835 views

PHP web application can't connect mysql installed with Zend Server CE on Mac OSX

I'm setting up development environment on Mac OSX. However the PHP web application can't connect the mysql server installed with Zend Server CE. The error information is below, [Type] dbnot_connect ...
1
vote
1answer
1k views

MAMP set up under the administrator account does not start servers under user account

I set up MAMP under an administrator account on this Mac OS 10.6.6. That works fine. The Apache and MySql server start and php works. When I log on to a user account with administrator privileges ...
1
vote
1answer
394 views

Can't re-install MySQL on OS X Leopard after uninstalling

I'm running Leopard (10.5.8) on a Macbook (not Pro) and I had MySQL running ok, but the Preferences pane wasn't working. I thought a fresh install would be a good idea, so I went through the uninstall ...
0
votes
1answer
1k views

Uninstall MySql on OS X

I accidentally installed the binary package of MySql on my Mac OS X. Now I don't see anything about MySql. How can I uninstall it?
3
votes
1answer
1k views

Reduce MySQL memory usage on a development box

On my mac, after a fresh restart with zero connections, MySQL is currently using 40MB of memory, 188MB of virtual memory (on-disk database paged in?), and has 16 threads. Since there's only ever one ...
1
vote
4answers
1k views

Mac - Better GUI MySQL tool than phpMyAdmin [closed]

I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a ...
2
votes
1answer
310 views

MySQL Workbench Snap To Grid

I'm using MySQL Workbench 5.2.36 in OS X and was wondering where in the options is the Snap To Grid function when editing a model? I can find Show Grid, but that's all... it's sort of pointless ...
0
votes
3answers
921 views

How to keep PHP and MySQL of ampps as default in MacOSX?

I'm using MacOS X 10.6.2. I want to use AMPPS http://www.ampps.com/ as my local development server so my question is how do I keep my AMPPS PHP & MySQL default?
0
votes
1answer
577 views

Unable to update the root password for MySQL — my.cnf is protected

I'm unable to update the root password for MySQL. On MAC OSX my.cnf seems to be protected, even after using sudo open -t my.cnf it still doesn't allow saving of the config file. The message when ...
1
vote
3answers
1k views

Debugging a world of hell when trying to install MySQL-Python on Mac OS X

I've been trying for weeks and weeks to install MySQL-python with absolutely no luck, on Mac OS X 10.6 with Python 7.0 from the Enthought Python Distribution. Many of the issues I ran into have been ...
2
votes
2answers
7k views

Where is MYSQL installed on Mac?

I've always used MAMP or XAMPP to install MYSQL so it's been fairly straightforward. The only most I've had to do is create a symbolic link. I'm now starting to learn Django and I would like to ...