OS 10.5 - MySQL Server

bluethundr · bluethundr #1 (**permalink**)

08-23-2009, 03:13 PM

Hi.

I am trying to install MySQL server on my macbook, so I can study it and get better at it. I downloaded the dmg image from the mysql site for intel macs.

This is the file I downloaded:

Code:

mysql-5.1.37-osx10.5-x86.dmg

I expanded the dmg and ran the installer and everything seemed fine. I copied the mysql bin directory to my path. But when I run mysqladmin this is what I get:

Code:

Mazdayasna:~ bluethundr$ sudo mysqladmin -u root password p4551int3nd2us3
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

vansmith · vansmith #2 (**permalink**)

08-23-2009, 03:43 PM

You haven't started mysql yet. Give this a quick read to get you started.

todd51 · todd51 #3 (**permalink**)

08-23-2009, 03:50 PM

You could also just use MAMP (Mac Apache MySQL PHP) which sets up everything for you. It even comes with a widget to easily earn on/off the servers. I highly recommend it.

vansmith · vansmith #4 (**permalink**)

08-23-2009, 03:58 PM

MAMP, like XAMPP, should only be used for testing and development purposes though. As stated on their website, "MAMP was created primarily as a PHP development environment for Macintosh computer and should therefore not be used as Live Webserver for the Internet. In this case, we recommend that you use Mac OS X server with the provided Apache or a Linux server."

todd51 · todd51 #5 (**permalink**)

08-23-2009, 04:25 PM

Ahh good point, I didn't realize that. Thanks vansmith.

wmprice1240 · wmprice1240 #6 (**permalink**)

08-23-2009, 05:22 PM

In the MySQL vein, once you get the server up and running, you may be interested in

MySQL :: MySQL GUI Tools

These tools provide graphical front ends for both administrative and client tasks. You can always use the mysql client utility in the terminal, but when first starting out sometimes it helps to have a nice front-end environment to ease the learning curve a bit.

bluethundr #1 (permalink)
Guest Posts: n/a	08-23-2009, 03:13 PM Hi. I am trying to install MySQL server on my macbook, so I can study it and get better at it. I downloaded the dmg image from the mysql site for intel macs. This is the file I downloaded: Code: mysql-5.1.37-osx10.5-x86.dmg I expanded the dmg and ran the installer and everything seemed fine. I copied the mysql bin directory to my path. But when I run mysqladmin this is what I get: Code: Mazdayasna:~ bluethundr$ sudo mysqladmin -u root password p4551int3nd2us3 mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
	QUOTE Thanks

vansmith #2 (permalink)
Member Since: Oct 19, 2008 Location: Ottawa Posts: 15,331 Mac Specs: 2012 13" MBP (2.5 i5, 8GB)	08-23-2009, 03:43 PM You haven't started mysql yet. Give this a quick read to get you started. Important Links: Community Guidelines : Use the reputation system if you've been helped. M-F Blog :: Write for the blog :: M-F IRC Channel - Chats every Sunday at 8PM EST.
	QUOTE Thanks

vansmith #4 (permalink)
Member Since: Oct 19, 2008 Location: Ottawa Posts: 15,331 Mac Specs: 2012 13" MBP (2.5 i5, 8GB)	08-23-2009, 03:58 PM MAMP, like XAMPP, should only be used for testing and development purposes though. As stated on their website, "MAMP was created primarily as a PHP development environment for Macintosh computer and should therefore not be used as Live Webserver for the Internet. In this case, we recommend that you use Mac OS X server with the provided Apache or a Linux server." Important Links: Community Guidelines : Use the reputation system if you've been helped. M-F Blog :: Write for the blog :: M-F IRC Channel - Chats every Sunday at 8PM EST.
	QUOTE Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Local server and mySQL server	ant	OS X - Apps and Games	2	03-31-2010 03:31 PM
getting macs to work off an FTP server.	Booshanky	Internet, Networking, and Wireless	3	08-28-2008 04:40 PM
Compiling MySQL for Leopard	Neko_D	OS X - Operating System	0	05-26-2008 06:56 PM
Offline php and MYSQL server.	StonePatch	OS X - Apps and Games	2	09-10-2006 11:52 AM
eMac as a Server?	lokerd	Other Hardware and Peripherals	11	09-13-2004 10:53 PM

OS 10.5 - MySQL Server

Internet Services

Web Development

Digital Marketing

Consumer Tech

todd51 #5 (permalink)
Guest Posts: n/a	08-23-2009, 04:25 PM Ahh good point, I didn't realize that. Thanks vansmith.
	QUOTE Thanks

wmprice1240 #6 (permalink)
Member Since: May 02, 2009 Posts: 480 Mac Specs: MBP 2.33 4GB: MacPro 8 Core 2.8, 16GB: MacMini 2.26 4GB: MacMin 2.53 4GB: iPhone3GS 32GB	08-23-2009, 05:22 PM In the MySQL vein, once you get the server up and running, you may be interested in MySQL :: MySQL GUI Tools These tools provide graphical front ends for both administrative and client tasks. You can always use the mysql client utility in the terminal, but when first starting out sometimes it helps to have a nice front-end environment to ease the learning curve a bit.
	QUOTE Thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)