Sign in to follow this  
Followers 0

OS X Server + Virtual MySQL

26 posts in this topic

Posted

What's the best way to run MySQL virtually on OS X Mountain Lion? I'm now running the fatest internet Optimum could offer, as I'm replacing Host Gator's server options and I need great performance.

Share this post


Link to post
Share on other sites

Posted

Removed

Share this post


Link to post
Share on other sites

Posted

There isn't a particularly great way - none better than anything else you'd get running on Linux or BSD. The basic process is the same as on any other platform: either snag the binary distribution from the website and install it or use a packaging tool like homebrew. In the end you're going to be running the same software so there's no particular reason to prefer one over the other.

"I need great performance" is too vague to offer any better advice. Given that you're seriously considering using a home ISP to make it accessible (I assume, based on your post). You're pretty unlikely to need anything more complicated than a basic installation.

Alright. I've done homebrew and so many methods to get MySQL to work locally on OS X, I'm able to load MySQL from my laptop (temporarily, for development purposes til first site re-launch).

Have you seen this error before? I've tried so many solutions on the internet, and nothing has worked on ML 10.8.2.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Share this post


Link to post
Share on other sites

Posted

Removed

Share this post


Link to post
Share on other sites

Posted

I might if it comes to that, just to use MySQL.

Typically that means MySQL is running or isn't configured to listen on a socket in that location. Does it show up in the process list? Did you follow the instructions after you run brew install mysql? They require adding it to launchd and configuring the root user and that isn't done automatically.

I tried the native & brewed MySQL several times for a week or two, they both still went through the same exact problem.

There is no other MySQL process running. How would I go about doing that manually?

Share this post


Link to post
Share on other sites

Posted

Removed

Share this post


Link to post
Share on other sites

Posted

You need to give more details if you want to get any real help - otherwise I'm going to just give you general directions that aren't very useful.

Alright, alright, here's the problem I get when using the mysql_install_db --verbose command given by brew.

130109  5:32:29 [ERROR] /usr/local/opt/mysql/bin/mysqld: unknown variable 'protocol=TCP'

Share this post


Link to post
Share on other sites

Posted

Removed

Share this post


Link to post
Share on other sites

Posted

I really appreciate what you've done for me and I finally got it to work! :D Having to cleanup all the old files everywhere on OS X, it managed to install it just right using Homebrew and the methods required. Thanks you!

Also, if you haven't heard of this software, call Sequel Pro. It's amazing! It totally kills the thought of ever having phpMyAdmin in my life! :p

Share this post


Link to post
Share on other sites

Posted

What do you mean "Virtually"?

Share this post


Link to post
Share on other sites

Posted

Running another OS at minimum install on a Virtual Box and have SQL running on it. But I have this problem fixed thanks to the evn show, for using it locally. :)

Share this post


Link to post
Share on other sites

Posted

Thanks for the reply - I was curious if you meant virtualization, you are just creating a overhead.

Share this post


Link to post
Share on other sites

Posted

Removed

Share this post


Link to post
Share on other sites

Posted

Also, if you haven't heard of this software, call Sequel Pro. It's amazing! It totally kills the thought of ever having phpMyAdmin in my life! :p

Erm, what?

phpMyAdmin runs as a web service, if you think businesses or hosting companies will open their mysql database server to remote connections so you can use your program, you are in for a huge surprise.

You might be able to use sequel pro locally on the same PC or network but you will NOT ever see that in the production world because you might as well open your database server to everyone without needing a username or password.

Share this post


Link to post
Share on other sites

Posted

It's not bad for free software. If you're spending somebody else's money or making a respectable living diddling with databases then get Navicat: it's significantly more powerful.

Now I know - there will be responses to this.

Honestly, phpMyAdmin in my opinion is only great IF you need to share access to your database servers. Outside of visual ques I am not really sure what the advantage is of using any GUI applications over command line.

(Other than the nice ability to use ctrl + v / ctrl + p lol)

Anytime I have used something graphically to save time - in the long run - time has been wasted with a poor performing query.

Share this post


Link to post
Share on other sites

Posted

Erm, what?

phpMyAdmin runs as a web service, if you think businesses or hosting companies will open their mysql database server to remote connections so you can use your program, you are in for a huge surprise.

You might be able to use sequel pro locally on the same PC or network but you will NOT ever see that in the production world because you might as well open your database server to everyone without needing a username or password.

Trust me, I have it all locked out from the outside world. :)

It's not bad for free software. If you're spending somebody else's money or making a respectable living diddling with databases then get Navicat: it's significantly more powerful.

I suppose that would be great software if I wanted to cluster later on? :)

Share this post


Link to post
Share on other sites

Posted

Command line 100% of the time.

Share this post


Link to post
Share on other sites

Posted

Command line 100% of the time.

When I'm more used to it. I've yet to build my own framework that manages everything for me.

Share this post


Link to post
Share on other sites

Posted

http://www.adminer.org/ If you must have a web interface to your MySQL databases...

Share this post


Link to post
Share on other sites

Posted

When I'm more used to it. I've yet to build my own framework that manages everything for me.

Not sure what you mean, you would prefer to use a GUI for the learning phase?

Share this post


Link to post
Share on other sites

Posted

http://www.adminer.org/ If you must have a web interface to your MySQL databases...

I'm not in favor of web interfaces honestly.

Not sure what you mean, you would prefer to use a GUI for the learning phase?

No, I already know how to handle these types of things, I don't have the database open outside my network, so I prefer to just work with what's on the desktop because it's a lot faster and I use generated passwords.

Share this post


Link to post
Share on other sites

Posted

No, I already know how to handle these types of things, I don't have the database open outside my network, so I prefer to just work with what's on the desktop because it's a lot faster and I use generated passwords.

In this case - I stick with my original answer. Command line is the best solution as it is already built in.

Share this post


Link to post
Share on other sites

Posted

In this case - I stick with my original answer. Command line is the best solution as it is already built in.

I wouldn't say so for many, many accounts and databases, with everything coming with generated characters. Especially passwords that are 25 characters.

Share this post


Link to post
Share on other sites

Posted

I wouldn't say so for many, many accounts and databases, with everything coming with generated characters. Especially passwords that are 25 characters.

Well, it would be specific to your usage scenario / setup but root just has 1 password and from there can access all others without the requirement of typing in 25 character passwords.

Just want to help.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.