Thread: Installing mySQl on Mac OS X
08-19-2004, 07:29 AM #1sealeyGuestInstalling mySQl on Mac OS X
Hi, I wonder if anyone can be of assistance. I am doing a few web projects at the moment in PHP using mySQL as a back end but it's so time consuming to keep FTPing the files up to my ISP to test every change.
So I decided to install PHP and mySQL on my Mac running Mac OS X 10.3. Installation of PHP went very smoothly and is running fine with the Apache installation that came with Mac OS X. However I am really struggling to get mySQL up and running. DOwnlaoded it from the mySQL site and run the install and followed the instructions as best I could but I have no idea how to link it in with PHP and have no idea to test if it's installed okay or check if it's running. Can someone please offer me some simple step by step instructions?
Thanks in advance,
08-19-2004, 12:07 PM #2dzinerGuest
I recommend Marc Liyanage's site:
There seems to be a lot of info there. Like you, I have tried to install php and mysql so that I can build dynamic sites locally. BUT, I got into a mess of stuff and I don't think mysql is installed properly... so I kinda gave up. Until I rebuild my system and start over again.
08-19-2004, 12:13 PM #3
- Member Since
- Jun 11, 2003
- Mount Vernon, WA
- MacBook Pro 2.6 GHz Core 2 Duo 4GB RAM OS 10.5.2
Install phpMyAdmin that will help you figure out if it is running or not.---> Join the Mac-Forums Folding team: use 37954 as your team number.
View Mac-Forums Folding team statistics (More Info)
Don't forget to use the User Reputation System
08-19-2004, 04:41 PM #4nr-mediaGuest
Ping port 3306, should get a response if mySql is up.
I use the Navicat client to access mySql.
08-23-2004, 09:28 PM #5h0tk4rlGuest
You don't need to link mysql to php. It's more of a loading php modules in your apache config file. To see if MySQL is functional, from a terminal window,
If the server is running you should get this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 60 to server version: 4.0.20-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Finally get a copy of phpmyadmin. Once you copy that to your site directory you only have to add the phpmyadmin home directory to the config file and if everything is configured, you'll have access to your database.
09-24-2004, 11:14 PM #6steveedgeGuest
05-11-2005, 08:21 PM #7aXidGuest
If all you need is to test your projects, I highly recommend using MAMP (Macintosh, Apache, MySQL, PHP). It has worked fine for me and installing it is a breeze.
Note: By default, you need to specify port when connecting to mysql or localhost:
$link = mysql_connect( "127.0.0.1:8889", "root", "root" );
06-02-2005, 10:45 PM #8mgm_03Guest
NOTE :: Please advise all Mac users you know to use the installer packages at http://www.serverlogistics.com. Complete PHP, Complete Apache, Complete MySQL
Installations do NOT get any easier than this...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By jabo in forum OS X - Operating SystemReplies: 0Last Post: 06-06-2012, 08:28 PM
By Unibody in forum OS X - Development and DarwinReplies: 3Last Post: 12-19-2009, 09:23 PM
By cmessineo in forum OS X - Development and DarwinReplies: 0Last Post: 05-20-2009, 10:18 AM
By hintbanana in forum Web Design and HostingReplies: 3Last Post: 02-06-2008, 04:03 AM
By jeffersno1 in forum Web Design and HostingReplies: 9Last Post: 06-19-2006, 03:46 PM