How to start MySQL server on OSX?

I'd like to be a power user, not luser in OSX-land

  • I'm a Windows systems administrator and power user and an enthusiastic user of Unix/Linux-based operating systems. I have hand edited make files and recompiled linux kernels manually. I know how to do administrative scripting and am a Microsoft products (SharePoint, if it matters) support professional/systems engineer in my job. I am certainly not the geekiest person I know but I'm in the top 5 percent.I am switching to a Mac Mini (Lion Server, specs maxed toward storage) after decades of using Windows laptops/desktops and some Linux machines. I'm prepared for the lack of physical mobility, but I don't feel prepared for not being a power user. What methods/resources would you suggest I could use to get up to speed with being a Mac Mini and OSX Lion power user? I have used Applescript to make shortcuts for my Dad to use on his older Mac Mini (like starting Safari with private browsing turned on, or starting Safari with the GMail URL, etc.) I'm totally unafraid of experimenting, but I want to know where to start. I have interests in: - Systems automation and interesting scripting/shell tweaks - Desktop customization - Having the server do household NAS services (music and pictures, primarily) - Having the server share printing services and possibly scanning services with other devices on the network (we will be acquiring an AirPrint-enabled printer, so this is less of a priority) - Using the server as an internet-browsing workstation - Using the server as a gaming platform - Experimental edge cases but not hacking - Integrating as fully as possible with our household iOS devices (1 iPads & 1 iPod Touch) I also have some bonus questions: - If I run a Windows VM via Parallels, do I back up its image/filesystem via the host operating system (OSX Lion) or do I back it up within the VM (I already own Acronis TrueImage for that kind of backup)? - If I should get to the point where I'm using a significant portion of the 1.5TB of storage available on the Mac Mini, what backup options should I plan to use for the data? Should I just get a bunch of 750 GB hard drive enclosures and keep using the same image-backup utilities I use now? (Acronis TrueImage for Windows, SuperDuper for OSX) Should I plan to get a http://store.apple.com/us/product/H5184VC/A/Thunderbolt (Expensive!). Should I back up media/data locally but use cloud backups for personal/identity things? Should I do the reverse? What's the industry standard? What do you do? As always, thanks very much in advance to anyone who takes the time to answers. Also, please no flaminess. I'm not going to revise my choice about platforms now.

  • Answer:

    - If I run a Windows VM via Parallels, Stop right there.... Use VMFusion. What methods/resources would you suggest I could use to get up to speed with being a Mac Mini and OSX Lion power user? Start by growing a soul patch and then brush up on your Unix.

kalessin at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

There's a book called http://oreilly.com/catalog/9780596003562 users. There's tons of Command line stuff available on line like Terminal secrets etc. try http://www.usingmac.com/2007/11/18/leopard-tweaking-terminal-codes

Gungho

Update from my Mac reseller salesguy - though you might appreciate it. Credit to Twitter @chesazeb:Best advice I can give: Learn the keyboard shortcuts. It will make you FLY through the OS, and folks will be impressed when you rarely grab the mouse. Make sure you turn on full keyboard access to buttons, widgets, etc. to be able to navigate through dialogs without mousing. Check out AirMouse for remote controlling the Mac mini with an iPod/iPad/iPhone - acts as a keyboard, trackpad, and scriptable remote all in one. Speaking of scripting, AppleScript is awesome, powerful, and can automate nearly anything. Integrates with shell scripting and vice versa. Can script almost the entire GUI. Check out Automator to build quick and easy automated workflows. Tons of freely downloadable workflows available online. If you have it hooked up to a TV, check out the Kylo web browser for the best TV web-browsing experience around (makes GREAT use of AirMouse) Backup your VM within the VM, using whatever Windows backup tool you like. Tell Time Machine to skip backing up your VM files Since server is just client with a few apps added on, you can easily use it for gaming, internet, etc. without any additional steps. But don't forget to download the server admin tools: http://support.apple.com/kb/DL1419 If you have a library of Windows games, check out Crossover Games http://www.codeweavers.com/products/cxgames/ , it's a version of WINE tuned for gaming designed for Mac OS X This probably goes without saying, but for Mac gaming, get Steam http://store.steampowered.com/ Sharing printers and files really couldn't be simpler, you'll see For a large amount of storage for backup, file hosting, etc. at a decent price, get a Promise SmartStor DS4600 and fill it with 3TB drives. Slice it up to allow between 2-3TB for a Time Machine backup volume, and the rest for general file storage. Or however you want to slice it up after you've got the Time Machine volume carved out. Macports is good, Fink is OK too, they both have strengths and weaknesses. It's entirely possible to run a GNOME or KDE session on top of Darwin w/out using Aqua at all. Set the User preferences so the login screen displays as a username/password entry form, then log in as >console w/ no password to get straight to the CLI, no GUI. From there, you can startx after everything's been installed and configured. Windows/mac integration resource: http://www.macwindows.com/

kalessin

P.S. a soul patch on me would be a very sad one indeed. I shave maybe once every 2 or 3 days. And it's all wispy. Think Lao Tzu.

kalessin

Big +1 on the keyboard shortcuts! That's great advice, overall. Kudos to chesazeb.

krilli

mhoye: You can actually install homebrew without root, putting it in your home directory somewhere. Quite the advantage. (But I'm actually a Fink person myself, love me my Debian tools!)

vasi

If you get interested in the server administration aspect, http://images.apple.com/education/docs/Apple-ClientManagementWhitePaper.pdf is the place to start. It was written by an Apple systems engineer in his free time with cure pictures of his pug, but eventually got wrapped into the Apple official dev world. It's overkill for what you want to do, but hey, it's the world of tinkering! As a mac system administrator, I just use http://www.bombich.com/ to back up our servers. One partition for the boot drive, and for the data. No reason that SuperDuper won't continue to do the job though. For more system administration, http://www.afp548.com/ is the place to be, though it leans more towards the server side than anything else.

jmd82

Macports, not homebrew. Ruby people are not to be trusted with root.

mhoye

Great tips here, the only one I didn't see is under the heading of - Desktop customization Get http://growl.info/. It's a system notification api. The closest windows analogy I can make is to the little dialog boxes that pop up from the task tray, but done in a beautiful, elegant, and skinable way. Most cool non-Apple produced programs (text editors, file transfer software, mp3 players that aren't iTunes) use it, and there are http://growl.info/documentation/applescript-support.php hooks in it.

zabuni

Some other things that are useful: http://perian.org/ is a free, open source QuickTime component that adds native support for many popular video formats. http://hints.macworld.com/ from MacWorld can be useful. http://korrekt.org/page/Mac_OS_Installation_Guide_for_Linux_Users and a much older http://v.cx/2008/11/mac-setup guide might help.

blob

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.