Jump to content



Photo

OS X Server + Virtual MySQL


  • Please log in to reply
25 replies to this topic

#1 Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 08 January 2013 - 04:33

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.


#2 vetthe evn show

the evn show

    Removed

  • Joined: 10-June 02

Posted 09 January 2013 - 00:56

Removed

#3 OP Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 09 January 2013 - 01:20

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)


#4 hjf288

hjf288

    Korean Crazy Man!

  • Joined: 19-April 03
  • Location: United Kingdom

Posted 09 January 2013 - 04:21

http://www.mamp.info/en/index.html

#5 vetthe evn show

the evn show

    Removed

  • Joined: 10-June 02

Posted 09 January 2013 - 05:33

Removed

#6 OP Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 09 January 2013 - 06:04

http://www.mamp.info/en/index.html


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?

#7 vetthe evn show

the evn show

    Removed

  • Joined: 10-June 02

Posted 09 January 2013 - 08:35

Removed

#8 OP Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 09 January 2013 - 10:34

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'


#9 vetthe evn show

the evn show

    Removed

  • Joined: 10-June 02

Posted 09 January 2013 - 16:11

Removed

#10 OP Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 09 January 2013 - 17:50

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

#11 tim_s

tim_s

    Default

  • Joined: 07-January 13
  • OS: OSX (Macbook Pro i7), Windows 7 (Gaming), Gentoo
  • Phone: Samsung Galaxy SIII, iPhone 4s

Posted 09 January 2013 - 18:54

What do you mean "Virtually"?

#12 OP Mr.XXIV

Mr.XXIV

    Shine bright like Iron Man.

  • Tech Issues Solved: 1
  • Joined: 30-April 11
  • Location: Durham, North Carolina
  • OS: OS X Mountain Lion 10.8.5
  • Phone: iPhone 5

Posted 09 January 2013 - 18:57

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. :)

#13 tim_s

tim_s

    Default

  • Joined: 07-January 13
  • OS: OSX (Macbook Pro i7), Windows 7 (Gaming), Gentoo
  • Phone: Samsung Galaxy SIII, iPhone 4s

Posted 09 January 2013 - 19:02

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

#14 vetthe evn show

the evn show

    Removed

  • Joined: 10-June 02

Posted 09 January 2013 - 19:04

Removed

#15 n_K

n_K

    Neowinian Senior

  • Tech Issues Solved: 3
  • Joined: 19-March 06
  • Location: here.
  • OS: FreeDOS
  • Phone: Nokia 3315

Posted 09 January 2013 - 19:10

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.