macromedia.dreamweaver.appdev
[Top] [All Lists]

Re: CF8, Mysql db connection

Subject: Re: CF8, Mysql db connection
From: David Powers
Date: Tue, 21 Aug 2007 23:09:37 +0100
Newsgroups: macromedia.dreamweaver.appdev


neuby79 wrote:
Obviously I don't know what I'm doing. I've been doing everything the books says but with no luck. Please, any help.

Sorry, I don't have a copy of the book. I don't know how you have been told to install MySQL. However, inside the DMG there should be a MySQL.prefPane icon. Drag that onto System Preferences to install a preference pane that will allow you to start and stop MySQL through the Mac interface.

To make it easier to access MySQL through Terminal, you need to set the path to MySQL. If you're using OS X 10.4 and your Terminal window says "bash" in the title bar, open BBEdit or TextWrangler (get it free from www.barebones.com, if you don't have it). Type the following in a new file:

export PATH="$PATH:/usr/local/mysql/bin"

Save the file as .profile in your Mac home folder. Because the name begins with a dot, you will be warned that such files are reserved for the system. Select Use "." to save the file. Then close Terminal and reopen it. You can then type mysql commands directly without needing to worry about changing directory. Just type mysql -u root, and you should get into MySQL. Typing mysql -p attempts to log you in as the current user with a password. If it's a brand new installation of MySQL, no passwords are set. It sounds as though your book was written by someone who has never tested the instructions on a Mac.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

<Prev in Thread] Current Thread [Next in Thread>